Mysql多实例安装

朱雀 2022-01-11 01:55 273阅读 0赞

1.  \--1.查看现有实例的选项值
2.  \[root@mast ~\]\# mysqladmin \--user=root --password=123456 --host=mast --port=3306 variables
3.  
4.  
5.  \--2.安装另一mysql
6.  \[root@mast mysql-5.5.30\]\# mkdir -p /usr/local/mysql3307
7.  \[root@mast mysql-5.5.30\]\# mkdir -p /usr/local/mysql3307/data
8.  
9.  \[root@mast mysql-5.5.30\]\# cmake . \\
10. > -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql3307 \\
11. > -DMYSQL\_DATADIR=/usr/local/mysql3307/data \\
12. > -DDEFAULT\_CHARSET=utf8 \\
13. > -DDEFAULT\_COLLATION=utf8\_general\_ci \\
14. > -DEXTRA\_CHARSETS=all \\
15. > -DENABLED\_LOCAL\_INFILE=1 \\
16. > -DMYSQL\_TCP\_PORT=3307 \\
17. > -DMYSQL\_UNIX\_ADDR=/tmp/mysql3307.sock
18. 
19. \[root@mast mysql-5.5.30\]\# make
20. \[root@mast mysql-5.5.30\]\# make install
21. 
22. \[root@mast mysql-5.5.30\]\# cd /usr/local/mysql3307
23. \[root@mast mysql3307\]\# scripts/mysql\_install\_db \--user=mysql \\
24. > \--basedir=/usr/local/mysql3307 \\
25. > \--datadir=/usr/local/mysql3307/data
26. 
27. \[root@mast mysql3307\]\# chown -R root:mysql .
28. \[root@mast mysql3307\]\# chown -R mysql:mysql data
29. 
30. 
31. \--3.编辑my.cnf
32. vi /etc/my.cnf
33. \[mysqld\_multi\]
34. mysqld = /usr/local/mysql/bin/mysqld\_safe
35. mysqladmin = /usr/local/mysql/bin/mysqladmin
36. user = multi\_admin
37. password = multipass
38. 
39. \# The MySQL server
40. \[mysqld1\]
41. port = 3306
42. socket = /tmp/mysql.sock
43. skip-external-locking
44. key\_buffer\_size = 16M
45. max\_allowed\_packet = 1M
46. table\_open\_cache = 64
47. sort\_buffer\_size = 512K
48. net\_buffer\_length = 8K
49. read\_buffer\_size = 256K
50. read\_rnd\_buffer\_size = 512K
51. myisam\_sort\_buffer\_size = 8M
52. 
53. general\_log=1
54. log\_output=TABLE,FILE
55. slow\_query\_log=1
56. long\_query\_time=1
57. basedir=/usr/local/mysql
58. datadir=/usr/local/mysql/data
59. 
60. \[mysqld2\]
61. port = 3307
62. socket = /tmp/mysql3307.sock
63. skip-external-locking
64. key\_buffer\_size = 16M
65. max\_allowed\_packet = 1M
66. table\_open\_cache = 64
67. sort\_buffer\_size = 512K
68. net\_buffer\_length = 8K
69. read\_buffer\_size = 256K
70. read\_rnd\_buffer\_size = 512K
71. myisam\_sort\_buffer\_size = 8M
72. 
73. general\_log=1
74. log\_output=TABLE,FILE
75. slow\_query\_log=1
76. long\_query\_time=1
77. basedir=/usr/local/mysql3307
78. datadir=/usr/local/mysql3307/data
79. user=mysql
80. 
81. 
82. \--4.启动mysql,为各个实例的multi\_admin设置密码，
83. mysqld\_safe \--user=mysql --port=3307 --socket=/tmp/mysql3307.sock --basedir=/usr/local/mysql3307 --datadir=/usr/local/mysql3307/data & 
84. mysqld\_safe \--user=mysql --port=3306 --socket=/tmp/mysql.sock --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data & 
85. 
86. mysql -uroot \--socket=/tmp/mysql3307.sock --port=3307 -p
87. mysql -uroot \--socket=/tmp/mysql.sock --port=3306 -p
88. 
89. \--各个实例设置密码
90. GRANT SHUTDOWN ON \*.\* TO 'multi\_admin'@'localhost' IDENTIFIED BY 'multipass';
91. 
92. mysqladmin -uroot \--socket=/tmp/mysql3307.sock --port=3307 -p shutdown
93. mysqladmin -uroot \--socket=/tmp/mysql.sock --port=3306 -p shutdown
94. 
95. 
96. \--5.启动与关闭mysql
97. /usr/local/mysql/bin/mysqld\_multi \--defaults-file=/etc/my.cnf start 1,2
98. /usr/local/mysql/bin/mysqld\_multi \--defaults-file=/etc/my.cnf stop 1,2

转载于:https://blog.51cto.com/raugher/1162439