Percona MySQL 5.7 Linux通用二进制包安装(CentOS 6.5)

川长思鸟来 2024-04-18 01:24 60阅读 0赞

MySQL对libaio库有依赖关系，如果没有这个包，数据目录初始化和接下来的服务启动会失败。  
yum install libaio  
  
创建软件安装目录  
mkdir  /mysql\_software\_57  
  
下载软件  
Percona官网的下载页面有两个二进制Tar包，分别对应不同的发行版本  
ssl100 - Debian/Ubuntu  
ssl101 - for CentOS 6 and CentOS 7  
cd / mysql\_software    
wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.17-11/binary/tarball/Percona-Server-5.7.17-11-Linux.x86\_64.ssl101.tar.gz  
  
解压安装包  
\[root@localhost mysql\_software\_57\]\# tar xvfz Percona-Server-5.7.17-11-Linux.x86\_64.ssl101.tar.gz  
\[root@localhost mysql\_software\_57\]\# ls  
Percona-Server-5.7.17-11-Linux.x86\_64.ssl101  
Percona-Server-5.7.17-11-Linux.x86\_64.ssl101.tar.gz  
\[root@localhost mysql\_software\_57\]\# rm -rf Percona-Server-5.7.17-11-Linux.x86\_64.ssl101.tar.gz   
\[root@localhost mysql\_software\_57\]\# ls  
Percona-Server-5.7.17-11-Linux.x86\_64.ssl101  
\[root@localhost mysql\_software\_57\]\# mv Percona-Server-5.7.17-11-Linux.x86\_64.ssl101/\* .  
\[root@localhost mysql\_software\_57\]\# rmdir Percona-Server-5.7.17-11-Linux.x86\_64.ssl101/

创建mysql用户  
\[root@localhost ~\]\# groupadd mysql  
\[root@localhost ~\]\# useradd -r -g mysql -s /bin/false mysql  
  
创建数据目录和日志目录  
\[root@localhost mysql\_software\_57\]\# mkdir /mysql\_data\_57  
\[root@localhost mysql\_software\_57\]\# mkdir /mysql\_log\_57

\[root@localhost mysql\_software\_57\]\# chmod 750 /mysql\_data\_57/

\[root@localhost mysql\_software\_57\]\# chown -R mysql.mysql /mysql\_data\_57/  
\[root@localhost mysql\_software\_57\]\# chown -R mysql.mysql /mysql\_log\_57/  
  
编辑配置文件  
\[root@localhost mysql\_software\_57\]\# vim /etc/my.cn

点击(此处)折叠或打开

1.  \[client\]
2.  port = 3306
3.  socket = /mysql\_data\_57/mysql.sock
4.  
5.  
6.  \[mysqld\]
7.  
8.  \#MySQL Server layer basic setting
9.  server-id = 1
10. port = 3306
11. socket = /mysql\_data\_57/mysql.sock
12. 
13. \#MySQL Server layer directory setting
14. basedir = /mysql\_software\_57
15. datadir = /mysql\_data\_57
16. tmpdir = /mysql\_data\_57
17. 
18. 
19. \#MySQL Server layer connection setting
20. max\_connections = 900
21. \#MySQL Server layer connection setting
22. max\_connections = 900
23. max\_connect\_errors = 100000
24. max\_allowed\_packet = 16M
25. back\_log = 50
26. 
27. \#MySQL Server layer binlog setting
28. log\_bin\_trust\_function\_creators = on
29. expire\_logs\_days = 5
30. binlog\_cache\_size = 1M
31. log-bin = /mysql\_log\_57/mysql-bin
32. binlog\_format = mixed
33. 
34. \#MySQL Server layer memory management setting
35. tmp\_table\_size = 64M
36. max\_heap\_table\_size = 64M
37. read\_buffer\_size = 2M
38. read\_rnd\_buffer\_size = 16M
39. sort\_buffer\_size = 8M
40. join\_buffer\_size = 16M
41. query\_cache\_size = 0
42. thread\_stack = 192K
43. query\_cache\_size = 0
44. thread\_stack = 192K
45. 
46. \#MySQL Server layer transaction management setting
47. transaction\_isolation = READ-COMMITTED
48. autocommit = OFF
49. 
50. \#MySQL Server layer log related setting
51. log\_warnings = 2 \#\#this value have been the default value in MySQL 5.7
52. slow\_query\_log = ON
53. long\_query\_time = 2
54. slow\_query\_log\_file = /mysql\_log\_57/mysql-slow.log
55. \#log\_queries\_not\_using\_indexes = 1
56. 
57. \#MySQL Server layer other behaviour setting
58. sql\_mode = PIPES\_AS\_CONCAT,IGNORE\_SPACE,STRICT\_TRANS\_TABLES
59. event\_scheduler = ON
60. lower\_case\_table\_names = 1
61. explicit\_defaults\_for\_timestamp = ON
62. default-storage-engine = INNODB
63. explicit\_defaults\_for\_timestamp = ON
64. default-storage-engine = INNODB
65. \#\#ft\_min\_word\_len = 4
66. 
67. \# Statistic
68. \# userstat = ON
69. \# thread\_statistics = ON
70. \# End statistics
71. 
72. 
73. \# MyISAM Engine related setting
74. key\_buffer\_size = 32M
75. bulk\_insert\_buffer\_size = 64M
76. myisam\_sort\_buffer\_size = 128M
77. myisam\_max\_sort\_file\_size = 10G
78. myisam\_repair\_threads = 1
79. \#myisam\_recover
80. 
81. \#InnoDB Engine related setting
82. \#InnoDB memory management related setting
83. innodb\_buffer\_pool\_size = 2G
84. innodb\_max\_dirty\_pages\_pct = 90
85. innodb\_sync\_array\_size = 16
86. innodb\_max\_dirty\_pages\_pct = 90
87. innodb\_sync\_array\_size = 16
88. 
89. \#table open cache related
90. table\_open\_cache = 4096
91. table\_open\_cache\_instances = 16
92. \#innodb\_additional\_mem\_pool\_size = 16M \#\#This variable have been removed MySQL 5.7
93. 
94. \#innodb\_numa\_interleave = 1 \#\#Only work with Percona 5.6.27 and later
95. 
96. \#\#InnoDB engine I/O related setting
97. innodb\_write\_io\_threads = 8
98. innodb\_read\_io\_threads = 8
99. innodb\_flush\_method = O\_DIRECT
100. 
101. \#InnoDB engine File management related setting
102. innodb\_data\_file\_path = ibdata1:12M:autoextend \#10M-->12M, 12M is default values, it is meaningless to set it to 10M
103. innodb\_file\_per\_table = 1 \#this value have been the default value in MySQL 5.7
104. innodb\_data\_file\_path = ibdata1:12M:autoextend \#10M-->12M, 12M is default values, it is meaningless to set it to 10M
105. innodb\_file\_per\_table = 1 \#this value have been the default value in MySQL 5.7
106. innodb\_file\_format = Barracuda \#this value have been the default value in MySQL 5.7
107. 
108. \#InnoDB engine undo log related setting
109. innodb\_undo\_directory = /mysql\_data\_57
110. innodb\_undo\_tablespaces = 4
111. innodb\_purge\_batch\_size = 5000
112. innodb\_purge\_threads = 8
113. 
114. \#InnoDB engine redo log related setting
115. innodb\_flush\_log\_at\_trx\_commit = 2
116. innodb\_log\_buffer\_size = 8M
117. innodb\_log\_file\_size = 256M
118. innodb\_log\_files\_in\_group = 3
119. innodb\_log\_group\_home\_dir = /mysql\_log\_57
120. 
121. \#InnoDB engine lock and transaction management setting
122. innodb\_lock\_wait\_timeout = 120
123. innodb\_lock\_wait\_timeout = 120
124. 
125. \#InnoDB engine other behaviour setting
126. innodb\_large\_prefix = ON \#\#this value have been the default value in MySQL 5.7
127. innodb\_strict\_mode = ON \#\#this value have been the default value in MySQL 5.7
128. innodb\_checksum\_algorithm = crc32 \#\#this value have been the default value in MySQL 5.7
129. 
130. 
131. \[mysqldump\]
132. quick
133. max\_allowed\_packet = 16M
134. 
135. \[mysql\]
136. no-auto-rehash
137. \# Only allow UPDATEs and DELETEs that use keys.
138. \#safe-updates
139. 
140. \[myisamchk\]
141. key\_buffer\_size = 512M
142. sort\_buffer\_size = 512M
143. key\_buffer\_size = 512M
144. sort\_buffer\_size = 512M
145. read\_buffer = 8M
146. write\_buffer = 8M
147. 
148. \[mysqlhotcopy\]
149. interactive-timeout
150. 
151. \[mysqld\_safe\]
152. \# Increase the amount of open files allowed per process. Warning: Make
153. \# sure you have set the global system limit high enough! The high value
154. \# is required for a large number of opened tables
155. open-files-limit = 8192
156. log-error = /mysql\_log\_57/mysqld\_error.log

初始化MySQL数据库的数据文件路径，并且创建系统表  
5.7.6及以上版本，要使用mysqld来初始化数据库  
\[root@localhost mysql\_software\_57\]\# bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure --user=mysql  
...  
2017-04-02T07:54:13.022906Z 0 \[Note\] Shutting down slave threads  
2017-04-02T07:54:13.022915Z 0 \[Note\] Forcefully disconnecting 0 remaining clients  
2017-04-02T07:54:13.068736Z 0 \[Note\] Binlog end  
2017-04-02T07:54:13.072400Z 0 \[Note\] InnoDB: FTS optimize thread exiting.  
2017-04-02T07:54:13.072548Z 0 \[Note\] InnoDB: Starting shutdown...  
2017-04-02T07:54:13.173584Z 0 \[Note\] InnoDB: Dumping buffer pool(s) to /mysql\_data\_57/ib\_buffer\_pool  
2017-04-02T07:54:13.174062Z 0 \[Note\] InnoDB: Buffer pool(s) dump completed at 170402  0:54:13  
2017-04-02T07:54:14.956340Z 0 \[Note\] InnoDB: Waiting for page\_cleaner to finish flushing of buffer pool  
2017-04-02T07:54:16.679052Z 0 \[Note\] InnoDB: Shutdown completed; log sequence number 2411492  
2017-04-02T07:54:16.679587Z 0 \[Note\] InnoDB: Removed temporary tablespace data file: "ibtmp1"  
  
启动数据库  
\[root@localhost mysql\_software\_57\]\# bin/mysqld\_safe --defaults-file=/etc/my.cnf &

\[root@localhost mysql\_software\_57\]\# 2017-04-02T08:02:36.065640Z mysqld\_safe Logging to '/mysql\_log\_57/mysqld\_error.log'.  
2017-04-02T08:02:36.068876Z mysqld\_safe error: log-error set to '/mysql\_log\_57/mysqld\_error.log', however file don't exists. Create writable for user 'mysql'.  
  
\[1\]+  Exit 1                  bin/mysqld\_safe --defaults-file=/etc/my.cnf  
  
日志文件不存在报错，手动创建日志文件  
\[root@localhost mysql\_log\_57\]\# su - mysql  
\[mysql@localhost ~\]$ cd /mysql\_log\_57/  
\[mysql@localhost mysql\_log\_57\]$ touch mysqld\_error.log

再次启动数据库  
\[root@localhost mysql\_software\_57\]\# bin/mysqld\_safe --defaults-file=/etc/my.cnf &  
\[1\] 37100  
\[root@localhost mysql\_software\_57\]\# 2017-04-02T08:03:44.853263Z mysqld\_safe Logging to '/mysql\_log\_57/mysqld\_error.log'.  
2017-04-02T08:03:44.857901Z mysqld\_safe Logging to '/mysql\_log\_57/mysqld\_error.log'.  
2017-04-02T08:03:44.922034Z mysqld\_safe Starting mysqld daemon with databases from /mysql\_data\_57

更改root 密码

\[root@localhost mysql\_software\_57\]\# bin/mysql -uroot -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 4  
Server version: 5.7.17-11-log Percona Server (GPL), Release 11, Revision f60191c  
  
Copyright (c) 2009-2016 Percona LLC and/or its affiliates  
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql> set password = password('root');  
Query OK, 0 rows affected, 1 warning (0.01 sec)  
  
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)

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

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