Quick Note on "Why upgrade to Percona MySQL 5.6"
- In short, Percona MySQL server is a modified MySQL 5.6 distribution that is optimized for maximum performance and will improve the overall performance of your database services (in theory, in most cases).
wget -q -O - http://www.atomicorp.com/installers/atomic |sh
You should see some sort of a successful message that the repository was added and is available for use.
Now that the repository is installed, we need to upgrade MySQL 5.1 that's installed to MySQL 5.5. This step is a little tricky - my server crashed / seg. faulted at this step, immediately after the installation. If you observe faults right after or during this step, you may need to reboot your machine to clear the conflict.
Begin MySQL upgrade by issuing this command as sudo:
yum upgrade mysql
(Did it crash after install? Run: shutdown -r now) If it did not crash, continue.
Now we must run the MySQL upgrade script to upgrade the default mysql user table(s) from MySQL 5.1 to 5.5. There is a schema differences between 5.1 and 5.5 and if this is not executed certain functionality may break.
mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow `
At this time you've upgraded MySQL to 5.5 and you should log into your plesk panel to make sure it's working. Try changing something, like a user account. You should get no errors and everything should be working. If all OK, continue.
Now we start with the Percona 5.6 upgrade. If you have databases on your server - you should create a good backup mysql dump - just in case things go wrong. If your databases are large, you will have to modify this command to find a good location for your dump file.
mysqldump -uadmin -p`< /etc/psa/.psa.shadow ` --all-databases | gzip > /root/mysql-backup/mysql.all.dump.sql.gz
Stop all mysql processes and make sure they are not running.
service mysqld stop
and check if they stopped, you shouldn't see any:
ps ax | grep mysql
Continue removing MySQL 5.5 packages with commands below. Please note that you may not have plesk-mysql package, so if that's the case just delete it from the command.
rpm -e --nodeps `rpm -q --whatprovides mysql-server`
yum remove mysql mysql-server plesk-mysql
Install the Percona repository with the command below:
yum install http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Install Percona components with the following command:
yum install Percona-Server-client-56 Percona-Server-server-56 Percona-Server-shared-56
(Optionally, I also needed mysql-devel for SphinxSearch, so I installed a fourth component. yum install Percona-Server-devel-56)
At this time, Percona services were installed and you should be able to restart your Percona MySQL 5.6 Server with the following command. After restarting the MySQL server, log into your Plesk panel and change something small to make sure MySQL is working.
service mysql start
Works like a charm. Thank you.ReplyDelete
I got this error message during backup "Warning: Skipping the data of table mysql.event. Specify the --events option explicitly."ReplyDelete
so I had to use this command
mysqldump -uadmin -p`< /etc/psa/.psa.shadow` --all-databases --events | gzip > /root/mysql-backup/mysql.all.dump.sql.gz