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

This article mainly explains "how to install and configure Percona under Linux". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "How to install and configure Percona under Linux"!

Percona Server is a standalone database product that provides users with the ability to swap out their MySQL installation and into the Percona Server product. By doing so, you can take advantage of the XtraDB storage engine. Here are the specific steps to install Percona under Linux.

1. Install ##through yum to delete the previous mysql database, I use centos7. When installing the virtual machine again, a lot of software is preinstalled. So mysql and mariadb have some stuff installed. You have to delete rpm -qa| grep mysqlrpm -qa |grep mariadbrpm -e mysqlrpm -e --nodeps mysqlyum remove mariadb-libs-5.5.41-2.el7_0.x86_64##Install other dependencies: perl and libaioyum -y install perl-Module-Install.noarchyum -y install libaio-devel##Configure yum install source yum install https://www.percona.com/redir/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm ##Latest is 0.1-4##Install perconayum install Percona-Server-server-572. xvf https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-5.7.18-16/binary/redhat/7/x86_64/Percona-Server-5.7.18-16-rd7301f8-el7-x86_64-bundle.tartar Percona-Server-5.7.18-16-rd7301f8-el7-x86_64-bundle.tarrpm -ivh Percona-Server-shared-compat-57-5.7.18-16.1.el7.x86_64rpm -ivh Percona-Server-shared-57- 5.7.18-16.1.el7.x86_64rpm-ivh Percona-Server-client-57 - 5.7.18 - 16.1.el7.x86_64rpm-ivh Percona-Server-server-57-5.7.18-16.1.el7.x86_643. Configuration ##Configure user groupsgroupadd mysqluseradd -r -g mysql mysqlmysqld --initialize --user=mysql --datadir=/user/local/webserver/mysql ##If you don't report an error, congratulations

vim /etc/percona-server.conf.d/mysqld.cnf

[mysqld]datadir=/usr/local/webserver/mysqlsocket=/usr/local/webserver/mysql/mysql.sock# initialize needexplicit_defaults_for_timestamp=true# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid[mysql]socket=/usr/local/webserver/mysql/mysql.sock

chown -R mysql:mysql /usr/local/webserver/mysql

service mysqld start ##If you are correct, congratulations.

4. The requested URL/log/index.php was not found on this server.| grep "temporary password" ##Find root's initial password. mysql -u root -pset password = password('root');5. ERROR

mysqld-initialize Error: TIMESTAMP with implicit DEFAULT value is deprecated

❝

Since 5.6, timestamp default behavior has been deprecated

vim /etc/percona-server.conf.d/mysqld.cnfexplicit_defaults_for_timestamp=true ##Add this paragraph (displays fields specifying the default value as timestamp type)

mysql-initialize error: initialize specified but the data directory has files in it. Aborting.

❝

Datadir already exists. delete to

service mysqld start error: InnoDB: .\ ibdata1 must be writable > InnoDB needs to configure the LOG File directory when starting. If no directory is specified, two log files ib_logfile0 and ib_logfile1 will be created under the MySQL Data directory. When creating, you need to ensure that MYSQL has permissions on this directory.

ps -ef |grep mysqldkill 21222 ## kill mysqld progress rm /usr/local/webserver/mysql/ib_logfil*service mysqld startservice mysqld start Error: Could not create unix socket lock file /user/lib/mysql/mysql.sock.lock.## Simple question. Add permissions to chown -R mysql:mysql /user/lib/mysql/to this, I believe everyone has a deeper understanding of "how to install and configure Percona under Linux", may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

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.