Assumes you use CentOS and MySQL 5.5 64-bit.
What are the steps?
- Install the Yum repository
- stop mysql
- remove mysql server 5.5
- install percona server 5.5 + percona toolkit, xtrabackup and php/python/perl connectors
- start percona server
The actual commands
- rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
- /etc/init.d/mysql stop
- yum remove mysql-server mysql-client MySQL-shared-compat
- yum install Percona-Server-server-55 Percona-Server-client-55 Percona-Server-shared-55 Percona-Server-shared-compat percona-toolkit xtrabackup perl-DBD-MySQL php-mysql MySQL-python
- /etc/init.d/mysql start
Assuming everything goes according to plan, this procedure should only take a few minutes.
These facts are really interesting. Few of them were well known for me but many of them were brand new for me too!
ReplyDeleteI will print this one out and show to my friends because they will be definitely interested in that. Thanks!
MySQL
Thanks, it works!
ReplyDelete/etc/init.d/mysql stop
ReplyDeleteShould be
/etc/init.d/mysqld stop
or
service mysqld stop