It is time to replace MySQL with PerconaDB

It's time to replace MySQL with PerconaDB with bitsCN.com. it's time to replace MySQL with PerconaDB.

Author: chszs, reprinted with note. Blog Homepage: http://blog.csdn.net/chszs

Percona database server is an enhanced MySQL version. it is not complicated to replace MySQL.

1. features of PerconaDB

1) faster query speed and better data consistency

2) server operation and stability

3) you can delay or avoid fragments.

4) the cost to be paid is lower than that of MySQL.

5) less time spent on optimization and management

6) higher normal running time

7) do not exclude speculation

There are also some features:

1) more INFORMATION_SCHEMA tables

2) more Global Performance parameters and Status Counters)

3) performance counters for each index

4) performance counters for each user

5) performance counters for each client

6) high-precision process list timing

7) quick verification algorithm

8) buffer pool pre-loading

9) supports Flash buffer

10) tables can be imported from different servers.

2. use PerconaDB to replace MySQL

1) ensure that the current data is backed up
# Cp-Rf/var/lib/mysql-orig # mv/etc/my. cnf/etc/my. cnf. orig

2) disable the target so that cPanel does not process MySQL updates.
#/Scripts/update_local_rpm_versions -- edit target_settings.MySQL50 uninstalled #/scripts/update_local_rpm_versions -- edit target_settings.MySQL51 uninstalled #/scripts/update_local_rpm_versions -- edit target_settings.MySQL55 uninstalled

3) remove all MySQL RPM packages from the server
#/Scripts/check_cpanel_rpms -- fix -- targets = MySQL50, MySQL51, MySQL55

The above Command will uninstall MySQL RPM installation from the server

4) create the database configuration file PerconaDB. repo
# Vi/etc/yum. repos. d/PerconaDB. repo

Add the following content:
[Percona] name = CentOS $ releasever-Percona baseurl = http://repo.percona.com/centos/?releasever/ OS /?basearch/ enabled = 1 gpgkey = http://www.percona.com/redir/downloads/percona-release/RPM-GPG-KEY-percona gpgcheck = 1

5) remove php from the "exclude" list in the/etc/yum. conf file.

6) install PerconaDB-server, PerconaDB-client, and PerconaDB-devel.
# Yum install Percona-Server-client-55 Percona-Server-server-55 Percona-Server-devel-55

7) start Percona MySQL
#/Etc/init. d/mysql start

8) then run Percona MySQL upgrade
# Mysql_upgrade

9) restart Percona MySQL
#/Etc/init. d/mysql restart

10) add php back to the "exclude" list in the/etc/yum. conf file.

11) recompile Apache with PHP
#/Scripts/easyapache -- build/etc/init. d/mysql status SUCCESS! MySQL (Percona Server) running (9425)

OK!

BitsCN.com