Percona database server is an enhanced version of MySQL, and replacing MySQL is not complicated.
first, the characteristics of perconadb
1) Faster query speed, better data consistency
2) server operation and its stability
3) can delay sharding, or avoid sharding
4) The cost to pay is lower than MySQL
5) Less time spent on optimization and management
6) Higher uptime
7) Do not rule out speculation
There are some features:
1) A larger number of INFORMATION_SCHEMA tables
2) Greater number of global performance parameters (global performance) and status counters (state Counters)
3) per index performance counter
4) per User performance counter
5) per client performance counter
6) High-precision process list timing
7) Fast Check algorithm
8) Buffer pool pre-loading
9) Supports Flash buffering
10) You can import tables from different servers
Second, replace MySQL with perconadb
1) Ensure that the current data is backed up
[JavaScript]View PlainCopyprint?
- # Cp-rf/var/lib/mysql/var/lib/mysql-orig
- # Mv/etc/my.cnf/etc/my.cnf.orig
2) Disable the target so that cpanel does not process MySQL updates
[JavaScript]View PlainCopyprint?
- #/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
[JavaScript]View PlainCopyprint?
- #/scripts/check_cpanel_rpms--fix--targets=mysql50,mysql51,mysql55
The above command uninstalls the MySQL RPM installation from the server
4) Create a database configuration file Perconadb.repo
[JavaScript]View PlainCopyprint?
- # Vi/etc/yum.repos.d/perconadb.repo
Add the following content:
[JavaScript]View PlainCopy print?
- [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 within the/etc/yum.conf file
6) Install Perconadb-server, perconadb-client and Perconadb-devel
[JavaScript]View PlainCopy print?
- # yum Install percona-server-client-55 percona-server-server-55 percona-server-devel-55
7) Start Percona MySQL
[JavaScript]View PlainCopyprint?
- #/etc/init.d/mysql Start
8) then run Percona MySQL upgrade
[JavaScript]View PlainCopyprint?
- # Mysql_upgrade
9) Restart Percona MySQL
[JavaScript]View PlainCopyprint?
- #/etc/init.d/mysql Restart
10) Add PHP back to the "exclude" list in the/etc/yum.conf file
11) Re-compiling Apache with PHP
[JavaScript]View PlainCopyprint?
- #/scripts/easyapache--build
- /etc/init.d/mysql status
- success! MySQL (Percona Server) running (9425)
Ok!
It's time to replace MySQL with PERCONADB.