We are looking to upgrade mysql 5.6 to Percona 5.6 on a production CentOS 6.5 server. We know there will be a bit of downtime, which is ok. What are the exact steps to do the upgrade? We tried:
cp /etc/my.cnf /etc/my.cnf.backup
service mysqld stop
yum install Percona-Server-client-56 Percona-Server-server-56
But yum is complaining about a conflict with MySQL from their yum-repo:
conflicts with file from package mysql-community-server-5.6.17
What is the right procedure here? Do we have to do:
yum remove mysql-community-server mysql-community-client