Percona MySQL 5.5 Linux通用二进制包安装(CentOS 6.9)

待我称王封你为后i 2024-04-18 00:47 80阅读 0赞

创建软件安装目录  
mkdir  /mysql\_software\_55  
  
下载软件  
Percona官网的下载页面有两个二进制Tar包，分别对应不同的发行版本  
ssl100 - Debian/Ubuntu  
ssl101 - for CentOS 6 and CentOS 7  
  
解压安装包  
tar xvfz Percona-Server-5.5.58-rel38.10-Linux.x86\_64.ssl101.tar.gz -C /mysql\_software\_55/  
  
创建mysql用户  
useradd mysql  
  
创建数据目录、日志目录和临时目录  
mkdir -p /mysql\_55\_3306/data  
mkdir -p /mysql\_55\_3306/log  
mkdir -p /mysql\_55\_3306/tmp  
  
创建错误日志  
touch /mysql\_55\_3306/log/error.log  
  
chown -R mysql.mysql /mysql\_55\_3306  
  
编辑配置文件  
vim /etc/my\_55\_3306.cn

1.  \[client\]  
    port = 3306  
    socket = /mysql\_55\_3306/tmp/mysql.sock  
      
    \# The MySQL server  
    \#\#\#\#\#\#\#Basic\#\#\#\#\#\#\#  
    \[mysqld\]  
    server-id = 101  
    port = 3306  
    user = mysql  
    basedir = /mysql\_software\_55/  
    datadir = /mysql\_55\_3306/data  
    tmpdir = /mysql\_55\_3306/tmp  
    socket = /mysql\_55\_3306/tmp/mysql.sock  
    skip-external-locking  
    skip-name-resolve  
    default-storage-engine = INNODB  
    character-set-server = utf8  
    wait\_timeout = 100  
    connect\_timeout = 20  
    interactive\_timeout = 100  
    back\_log = 500  
    myisam\_recover  
    event\_scheduler = ON  
      
    \#\#\#\#\#\#\#binlog\#\#\#\#\#\#\#  
    log-bin = /mysql\_55\_3306/log/mysql-bin  
    binlog\_format = row  
    max\_binlog\_size = 128M  
    binlog\_cache\_size = 2M  
    expire-logs-days = 5  
      
    \#\#\#\#\#\#\#replication\#\#\#\#\#\#\#  
    slave-net-timeout = 10  
    \#rpl\_semi\_sync\_master\_enabled =1  
    \#rpl\_semi\_sync\_master\_wait\_no\_slave = 1  
    \#rpl\_semi\_sync\_master\_timeout = 1000  
    \#rpl\_semi\_sync\_slave\_enabled = 1  
    skip-slave-start  
    log\_slave\_update = 1  
    relay\_log\_recovery = 1  
      
    \#\#\#\#\#\#\#slow log\#\#\#\#\#\#\#  
    slow\_query\_log = 0  
    slow\_query\_log\_file = /mysql\_55\_3306/log/mysql\_slow.log  
    long\_query\_time = 2  
      
      
    \#\#\#\#\#\#\#error log\#\#\#\#\#\#\#  
    log-error = /mysql\_55\_3306/log/error.log  
    general\_log = 0  
    general\_log\_file = /mysql\_55\_3306/log/general\_query.log  
      
      
    \#\#\#\#\#\#\#per\_thread\_buffers\#\#\#\#\#\#\#\#  
    max\_connections = 1024  
    max\_user\_connections = 1000  
    max\_connect\_errors = 10000  
    key\_buffer\_size = 10M  
    max\_allowed\_packet = 128M  
    table\_cache = 3096  
    table\_open\_cache = 6144  
    table\_definition\_cache = 4096  
    sort\_buffer\_size = 512K  
    read\_buffer\_size = 512K  
    read\_rnd\_buffer\_size = 512K  
    join\_buffer\_size = 512K  
    tmp\_table\_size = 64M  
    max\_heap\_table\_size = 64M  
    query\_cache\_type = 0  
    query\_cache\_size = 0  
    bulk\_insert\_buffer\_size = 32M  
    thread\_cache\_size = 64  
    thread\_concurrency = 32  
    thread\_stack = 256K  
      
    \#\#\#\#\#\#\#InnoDB\#\#\#\#\#\#\#  
    innodb\_data\_home\_dir = /mysql\_55\_3306/data  
    innodb\_log\_group\_home\_dir = /mysql\_55\_3306/log  
    innodb\_data\_file\_path = ibdata1:2G:autoextend  
    innodb\_buffer\_pool\_size = 128M  
    innodb\_buffer\_pool\_instances = 1  
    innodb\_additional\_mem\_pool\_size = 2M  
    innodb\_log\_file\_size = 512M  
    innodb\_log\_buffer\_size = 10M  
    innodb\_log\_files\_in\_group = 3  
    innodb\_flush\_log\_at\_trx\_commit = 2  
    innodb\_lock\_wait\_timeout = 10  
    innodb\_sync\_spin\_loops = 40  
    innodb\_max\_dirty\_pages\_pct = 90  
    innodb\_support\_xa = 1  
    innodb\_thread\_concurrency = 0  
    innodb\_thread\_sleep\_delay = 500  
    innodb\_file\_io\_threads = 4  
    innodb\_concurrency\_tickets = 1000  
    log\_bin\_trust\_function\_creators = 1  
    innodb\_flush\_method = O\_DIRECT  
    innodb\_file\_per\_table  
    innodb\_read\_io\_threads = 16  
    innodb\_write\_io\_threads = 16  
    innodb\_io\_capacity = 2000  
    innodb\_file\_format = Barracuda  
    innodb\_purge\_threads = 1  
    innodb\_purge\_batch\_size = 32  
    innodb\_old\_blocks\_pct = 75  
    innodb\_change\_buffering = all  
    transaction\_isolation = READ-COMMITTED

初始化MySQL数据库的数据文件路径，并且创建系统表  
删除Percona-Server-5.5.58-rel38.10-Linux.x86\_64.ssl101目录，将软件文件移动到上一级目录，否则初始化的时候会报错  
cd /mysql\_software\_55/Percona-Server-5.5.58-rel38.10-Linux.x86\_64.ssl101  
\[root@MySQL01 Percona-Server-5.5.58-rel38.10-Linux.x86\_64.ssl101\]\# mv \* ..  
\[root@MySQL01 Percona-Server-5.5.58-rel38.10-Linux.x86\_64.ssl101\]\# cd ..  
\[root@MySQL01 mysql\_software\_55\]\# rmdir Percona-Server-5.5.58-rel38.10-Linux.x86\_64.ssl101/  
  
执行初始化  
\[root@MySQL01 mysql\_software\_55\]\# ./scripts/mysql\_install\_db --user=mysql  --basedir=/mysql\_software\_55/ --datadir=/mysql\_55\_3306/data/  
WARNING: The host 'MySQL01' could not be looked up with resolveip.  
This probably means that your libc libraries are not 100 % compatible  
with this binary MySQL version. The MySQL daemon, mysqld, should work  
normally with the exception that host name resolving will not work.  
This means that you should use IP addresses instead of hostnames  
when specifying MySQL privileges !  
Installing MySQL system tables...  
171214  9:56:46 \[Note\] Ignoring --secure-file-priv value as server is running with --bootstrap.  
171214  9:56:46 \[Note\] /mysql\_software\_55//bin/mysqld (mysqld 5.5.58-38.10) starting as process 9175 ...  
OK  
Filling help tables...  
171214  9:56:47 \[Note\] Ignoring --secure-file-priv value as server is running with --bootstrap.  
171214  9:56:47 \[Note\] /mysql\_software\_55//bin/mysqld (mysqld 5.5.58-38.10) starting as process 9182 ...  
OK  
  
To start mysqld at boot time you have to copy  
support-files/mysql.server to the right place for your system  
  
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !  
To do so, start the server, then issue the following commands:  
  
/mysql\_software\_55//bin/mysqladmin -u root password 'new-password'  
/mysql\_software\_55//bin/mysqladmin -u root -h MySQL01 password 'new-password'  
  
Alternatively you can run:  
/mysql\_software\_55//bin/mysql\_secure\_installation  
  
which will also give you the option of removing the test  
databases and anonymous user created by default.  This is  
strongly recommended for production servers.  
  
See the manual for more instructions.  
  
You can start the MySQL daemon with:  
cd /mysql\_software\_55/ ; /mysql\_software\_55//bin/mysqld\_safe &  
  
You can test the MySQL daemon with mysql-test-run.pl  
cd /mysql\_software\_55//mysql-test ; perl mysql-test-run.pl  
  
Please report any problems at  
  https://bugs.launchpad.net/percona-server/+filebug  
  
Percona recommends that all production deployments be protected with a support  
contract (http://www.percona.com/mysql-suppport/) to ensure the highest uptime,  
be eligible for hot fixes, and boost your team's productivity.

启动 MySQL

\[root@MySQL01 mysql\_software\_55\]\# bin/mysqld\_safe --defaults-file=/etc/my\_55\_3306.cn &  
\[1\] 21953

\[root@MySQL01 mysql\_software\_55\]\# ps -ef|grep mysql  
root     10302 10278  0 10:11 pts/1    00:00:00 su - mysql  
mysql    10303 10302  0 10:11 pts/1    00:00:00 -bash  
mysql    21952 10303  0 10:45 pts/1    00:00:00 tailf error.log  
root     21953  1960  0 10:45 pts/0    00:00:00 /bin/sh bin/mysqld\_safe --defaults-file=/etc/my\_55\_3306.cn  
mysql    23005 21953  0 10:45 pts/0    00:00:00 /mysql\_software\_55/bin/mysqld --defaults-file=/etc/my\_55\_3306.cn --basedir=/mysql\_software\_55/ --datadir=/mysql\_55\_3306/data --plugin-dir=/mysql\_software\_55//lib/mysql/plugin --user=mysql --log-error=/mysql\_55\_3306/log/error.log --pid-file=/mysql\_55\_3306/data/MySQL01.pid --socket=/mysql\_55\_3306/tmp/mysql.sock --port=3306  
root     23051  1960  0 10:46 pts/0    00:00:00 grep mysql

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2148690/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2148690/