Upgrade to MySQL 5.5

[programmer2188]

Hello,

I just installed CloudLinux on a new server yesterday. However, the server had MySQL 5.1, so mysql-governor installed 5.1 as well. However, I want to upgrade it to 5.5. How can I do this?

[alexey.com.s]

Hello, Brandon!

Can you wait until Monday next week? We going to release new governor with own utility to changing MySQL(5.0, 5.1, 5.5) or MariaDB.
Or manualy upgrade. Make sure before update that you have backup of mysql data (users data and system tables). Example for cl6, x86_64 server:
1) rpm -e --justdb cl-MySQL-server cl-MySQL-shared cl-MySQL-client cl-MySQL-test cl-MySQL-devel
2) wget http://repo.cloudlinux.com/other/cl6...-beta-5.5.repo -O /etc/yum.repos.d/cl-mysql.repo
3)
rpm -Uhv --force --nodeps http://repo.cloudlinux.com/other/cl6...nux.x86_64.rpm
rpm -Uhv --force --nodeps http://repo.cloudlinux.com/other/cl6...nux.x86_64.rpm
rpm -Uhv --force --nodeps http://repo.cloudlinux.com/other/cl6...nux.x86_64.rpm
rpm -Uhv --force --nodeps http://repo.cloudlinux.com/other/cl6...nux.x86_64.rpm
rpm -Uhv --force --nodeps http://repo.cloudlinux.com/other/cl6...nux.x86_64.rpm
4) service mysql restart
5) /usr/bin/mysql_upgrade
6) /usr/bin/mysql_fix_privilege_tables
7) service db_governor restart
8) rebuild php through easyapache

[programmer2188]

Hello,

I can certainly wait until Monday. Do you mean this coming Monday, May 20? Is this definite?

Also, are you saying you will have *full* support for MariaDB/ Ive been wanting to switch to MariaDB, but also wanted MySQL Governor to work with it. So with this coming release, it will be supported?

Where can I find the update information when the update comes out?

Thanks so much.

[alexey.com.s]

Hello,

sorry for delay, but release of new governor will be tomorrow. Yes, release will be support install MariaDB on the server and work with it. I will write here how to upgrade or install new governor.

[programmer2188]

Thank you so much. I look forward to it.

[alexey.com.s]

Hello,

we released new governor(1.0-3).

IMPORTANT THING:
Please make full database backup(including system tables) before you will do upgrade of MySQL, especially if you will change from MySQL to MariaDB. This action will prevent data losing in case if something goes wrong.

How to install new package:
1) yum install governor-mysql --enablerepo=cloudlinux-

updates-testing
2) /usr/share/lve/dbgovernor/mysqlgovernor.py --install

One important note:
if you have installed MariDB on the server, on installation do:
1) yum install governor-mysql --enablerepo=cloudlinux-updates-testing
2) /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb55
3) /usr/share/lve/dbgovernor/mysqlgovernor.py --install

How to upgrade:
1) yum upd ate governor-mysql --enablerepo=cloudlinux-updates-testing

Now in governor is available database type selection utility:
[~]# /usr/share/lve/dbgovernor/db-select-mysql --help
Usage: db-select-mysql [options]
options:
--mysql-version= or -m se t version of mysql
mysql type: auto, mysql50, mysql51, mysql55, mariadb55
--install-now if need reinstall mysql now
--current-mysql show current installed mysql
--current-running-mysql show current running mysql

For upgradeing to MySQL 5.5(for example), you should to do:
1) /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mysql55
2) /usr/share/lve/dbgovernor/db-select-mysql --install-now
3) for cPanel can be needed to rebuild php through easyapache

For installation of MariaDB 5.5, you should to do:
1) /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb55
2) /usr/share/lve/dbgovernor/db-select-mysql --install-now
3) for cPanel can be needed to rebuild php through easyapache

Available type of DB:
auto - install MySQL as earlier(default for CL5 & CL6 and according to options of cPanel)

mysql50 - cl-MySQL-5.0
mysql51 - cl-MySQL-5.1
mysql55 - cl-MySQL-5.5
mariadb55 - cl-mariadb-5.5

Script installs mysqlclient1x - for backward compatibility

[programmer2188]

Thank you so much. This worked perfectly. I love the new functionality.