Shulou(Shulou.com)06/01 Report--

System environment:

CentOS 6.5 / 7.0 x86_64

Fedora 20 x86_64

Brief introduction

Percona Server is a derivative of MySQL, focusing on the improvement of MySQL database server under Linux/BSD, and has a significant improvement in function and performance compared with MySQL.

The compilation, configuration, and use of Percona Server are exactly the same as MySQL, and you can use it as a MySQL.

Download Percona Server source package # wget or MySQL source package # wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.19.tar.gz installation dependency # yum install gcc-c++ make cmake bison bison-devel ncurses-devel libaio-devel perl

An additional perl-Data-Dumper package needs to be installed for Fedora 20 and CentOS 7:

# yum install perl-Data-Dumper create MySQL user # groupadd mysql# useradd-g mysql-s / sbin/nologin-M mysql create log directory and SOCK directory and change permissions # mkdir / var/log/mysql56# chown-R mysql:mysql / var/log/mysql56/ compilation installation # tar zxf percona-server-5.6.17-66.0.tar.gz-C / usr/local/src/# cd / usr/local/src/percona-server-5.6.17-66 .0 / # cmake\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql56\-DSYSCONFDIR=/usr/local/mysql56/etc\-DMYSQL_DATADIR=/var/lib/mysql56\-DMYSQL_USER=mysql\-DMYSQL_TCP_PORT=3306\-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_MEMORY_STORAGE_ENGINE=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DEXTRA_CHARSETS=all\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8 _ general_ci\-DENABLED_LOCAL_INFILE=1\-DWITH_READLINE=1

DENABLED_LOCAL_INFILE: allow files to be imported into the database to speed up data import, using the SQL statement:

LOAD DATA LOCAL INFILE data file INTO TABLE table name

WITH_READLINE: bind the terminal shortcut key and history function of readline. But after installation, you still can't find the feeling of readline, because DWITH_READLINE was removed in MySQL version 5.6.5, and DWITH_LIBEDIT was also removed in MySQL version 5.6.12.

If the compilation fails, clean up the CMakeCache.txt file in the source directory and recompile it.

# make-jacks make install initializes the database

Change to the MySQL installation directory:

# cd / usr/local/mysql56/

Create the / var/lib/mysql56 datadir directory as mysql and write the initialization database information:

#. / scripts/mysql_install_db-user=mysql-datadir=/var/lib/mysql56

Copy the service file to / etc/init.d/mysql56,mysql56. The file name is also the service name, which can be changed at will. In order to unify, we use mysql56 as the file name:

# cp support-files/mysql.server / etc/init.d/mysql56 configuration my.cnf# vi / usr/local/mysql56/etc/ my.cnf [mysqld] datadir=/var/lib/mysql56socket=/var/run/mysql56/mysqld.sockskip-name-resolvesymbolic-links=0 [mysqld_safe] log-error=/var/log/mysql56/mysqld-err.log#pid-file=/var/lib/mysql56/aboutc.pid

Please pay attention to the file path.

Start the MySQL service # service mysql56 startStarting MySQL (Percona Server).. SUCCESS!

Change root user password

#. / bin/mysqladmin-u root password' new-password'

Delete data where the login user's password is empty

#. / bin/mysql-uroot-pEnter password:mysql > delete from mysql.user where password =''; Query OK, 5 rows affected (0.51 sec) mysql > select user,host,password from mysql.user +-+ | user | host | password | +- -- + | root | localhost | * 9F6F2XXXX40B6DF5D2A5F762E1CF33782CA1ABXX | +-- + 1 row in set (0.01sec) to this MySQL (Percona Server) compilation and installation is complete You can also choose to install Percona Server using YUM, and you can also choose the corresponding my.cnf configuration file for different memory sizes, so that your server resources can be balanced and provide better performance. Frequently asked questions when starting the MySQL service: Starting MySQL. ERROR! The server quit without updating PID file error, please check the path and permissions of log-error configuration in my.cnf. If a: Can't connect to local MySQL server through socket 'xxx.sock' error occurs while accessing the database, check the path and permissions of the socket configuration in my.cnf.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.