{"id":4428,"date":"2024-07-02T22:54:22","date_gmt":"2024-07-03T02:54:22","guid":{"rendered":"https:\/\/underhost.com\/blog\/?p=4428"},"modified":"2024-07-08T17:00:29","modified_gmt":"2024-07-08T21:00:29","slug":"almalinux-9-with-cpanel-mysql-8-to-mariadb-10-11-guide","status":"publish","type":"post","link":"https:\/\/underhost.com\/blog\/almalinux-9-with-cpanel-mysql-8-to-mariadb-10-11-guide\/","title":{"rendered":"AlmaLinux 9 with cPanel: MySQL 8 to MariaDB 10.11 Guide"},"content":{"rendered":"

Welcome to the Future: AlmaLinux 9 with cPanel!<\/h2>\n

As pioneers in the hosting industry, UnderHost is excited to introduce AlmaLinux 9 paired with the latest cPanel & WHM version 120. Our commitment to delivering cutting-edge solutions ensures you stay ahead in the fast-paced world of web hosting.<\/p>\n

Important Notice for New Installations with MySQL 8<\/h3>\n

Transitioning from MySQL 8.0 to MariaDB 10.11 on a New cPanel & WHM Server<\/h2>\n

If you’ve recently installed cPanel and it defaulted to MySQL 8, but you wish to switch to MariaDB 10.11, ensure your server is new with no pre-existing databases before proceeding. This change is experimental and not supported officially.<\/p>\n

Warning: This migration method is entirely experimental and unsupported. Please refrain from contacting cPanel support for issues related to this guide.<\/strong><\/p>\n

If you initially forgot to set your preferred database in \/root\/cpanel_profile\/cpanel.config<\/code> during your recent installations of cPanel & WHM, here’s a guide allowing a seamless switch from the default MySQL to MariaDB 10.11:<\/p>\n

Step-by-Step Guide to Migrate from MySQL 8.0 to MariaDB 10.11<\/h3>\n

As the root user, start by removing MySQL 8.0:<\/p>\n

dnf -y remove mysql-community-*<\/code><\/p>\n

Next, completely remove the MySQL data directory:<\/p>\n

rm -rf \/var\/lib\/mysql<\/code><\/p>\n

Update the desired SQL version in the cPanel configuration:<\/p>\n

sed -i 's\/mysql-version=8.0\/mysql-version=10.11\/g' \/var\/cpanel\/cpanel.config<\/code><\/p>\n

Begin the MariaDB installation with this API command:<\/p>\n

whmapi1 start_background_mysql_upgrade version=10.11<\/code><\/p>\n

To monitor the installation progress:<\/p>\n

tail -f \/var\/cpanel\/logs\/mysql_upgrade.YYYYMMDD-HHMMSS<\/strong>\/unattended_background_upgrade.log<\/code><\/p>\n

After installation, check the MySQL version to verify the update:<\/p>\n

mysql -V<\/code><\/p>\n

Customizing MySQL or MariaDB Version During Initial cPanel Setup<\/h3>\n

To set a specific database version during the initial installation of cPanel, follow these steps:<\/p>\n

Adjust the RPM Installation Preferences:<\/h4>\n

echo \"mysql-server=mysql-version=10.11\" > \/etc\/cpanel_mysql_installation.profile<\/code><\/p>\n

Database Version Options:<\/h4>\n

# For MySQL 8
\nmysql-version=8.0<\/code><\/p>\n

# For MariaDB 10.6
\nmysql-version=10.6<\/code><\/p>\n

# For MariaDB 10.5
\nmysql-version=10.5<\/code><\/p>\n

# For MariaDB 10.11
\nmysql-version=10.11<\/code><\/p>\n

cPanel Installation Overview on AlmaLinux<\/h3>\n

For a detailed walkthrough of installing cPanel on AlmaLinux, refer to cPanel’s official installation guide<\/a>.<\/p>\n

Prerequisites for AlmaLinux 9:<\/h4>\n

Before installing, ensure your system is updated:<\/p>\n

sudo dnf update -y<\/code><\/p>\n

Update \/etc\/resolv.conf:<\/h4>\n

# Google DNS
\nnameserver 8.8.8.8
\nnameserver 8.8.4.4<\/code><\/p>\n

# Cloudflare DNS
\nnameserver 1.1.1.1
\nnameserver 1.0.0.1<\/code><\/p>\n

Then download and run the cPanel installation script:<\/p>\n

cd \/home
\ncurl -o latest -L https:\/\/securedownloads.cpanel.net\/latest
\nsh latest<\/code><\/p>\n

Enhance Your Hosting with UnderHost and AlmaLinux 9<\/h2>\n

Advance your hosting capabilities with UnderHost’s VPS, cloud, and dedicated server solutions, now optimized for AlmaLinux 9. Explore the forefront of hosting technology with us today.<\/p>\n

Conclusion<\/h2>\n

With AlmaLinux 9 and cPanel now available for innovative use, UnderHost continues to drive forward in a future rich with hosting innovations. Whether you are a developer, a business owner, or in need of reliable hosting services, our solutions are crafted to meet diverse demands.<\/p>\n

Have questions or need assistance? Contact our support team<\/a> anytime. At UnderHost, we are dedicated to ensuring your hosting experience is exceptional.<\/p>\n","protected":false},"excerpt":{"rendered":"

Welcome to the Future: AlmaLinux 9 with cPanel! UnderHost introduces cutting-edge solutions for web hosting, including transitioning to MariaDB 10.11 from MySQL 8.0.<\/p>\n","protected":false},"author":1,"featured_media":4436,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61,1,3],"tags":[],"class_list":["post-4428","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-almalinux","category-news","category-controlpanel"],"_links":{"self":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts\/4428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/comments?post=4428"}],"version-history":[{"count":10,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts\/4428\/revisions"}],"predecessor-version":[{"id":4478,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts\/4428\/revisions\/4478"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/media\/4436"}],"wp:attachment":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/media?parent=4428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/categories?post=4428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/tags?post=4428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}