Install Percona mysql and Virtualmin on Centos

Install Percona mysql and Virtualmin on Centos

First you have to install vitualmin

cd /tmp
http://software.virtualmin.com/gpl/scripts/install.sh
chmod +x install.sh
./install.sh

Launch virtualmin in browser and run install wizard (you can setup whatever you want, set mysql password etc….)

https://ip-adress:10000

Next you have to uninstall mysql

service mysqld stop
yum remove mysql mysql-server mysql-devel

Install Percona mysql

rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
yum install Percona-Server-client-55 Percona-Server-server-55 Percona-Server-devel-55 Percona-Server-shared-55 Percona-Server-shared-compat

At this momment, virtualmin and centos launch default mysql with command  “service mysqld start” or “/etc/init.d/mysqld start” but percona will start with “service mysql start”  or  /etc/init.d/mysql start”.  So, you can go in “Webmin/MYSQL Database server/Module config/System configuration” and change  configuration or a much simple solution:

cd /etc/init.d
ln -s mysql mysqld
chkconfig mysql off
chkconfig mysqld on

Now, you can start Percona just like you start default mysql

service mysqld start

You must have the response

SUCCESS! MySQL (Percona Server) running

Now you can go in virtualmin and create, delete database, restart mysql etc..

 

Good luck!

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *