It's time to replace MySQL with PERCONADB.

Source: Internet
Author: User
Tags percona percona server

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?
    1. # Cp-rf/var/lib/mysql/var/lib/mysql-orig
    2. # Mv/etc/my.cnf/etc/my.cnf.orig

2) Disable the target so that cpanel does not process MySQL updates

[JavaScript]View PlainCopyprint?
    1. #/scripts/update_local_rpm_versions--edit target_settings. MYSQL50 uninstalled
    2. #/scripts/update_local_rpm_versions--edit target_settings. MySQL51 uninstalled
    3. #/scripts/update_local_rpm_versions--edit target_settings. MySQL55 uninstalled

3) Remove all MySQL RPM packages from the server

[JavaScript]View PlainCopyprint?
    1. #/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?
    1. # Vi/etc/yum.repos.d/perconadb.repo

Add the following content:

[JavaScript]View PlainCopy print?
    1. [Percona]
    2. Name = CentOS $releasever-percona
    3. Baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
    4. Enabled = 1
    5. Gpgkey = http://www.percona.com/redir/downloads/percona-release/rpm-gpg-key-percona
    6. 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?
    1. # yum Install percona-server-client-55 percona-server-server-55 percona-server-devel-55

7) Start Percona MySQL

[JavaScript]View PlainCopyprint?
    1. #/etc/init.d/mysql Start

8) then run Percona MySQL upgrade

[JavaScript]View PlainCopyprint?
    1. # Mysql_upgrade
9) Restart Percona MySQL
[JavaScript]View PlainCopyprint?
    1. #/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?
    1. #/scripts/easyapache--build
    2. /etc/init.d/mysql status
    3. success! MySQL (Percona Server) running (9425)

Ok!

It's time to replace MySQL with PERCONADB.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.