Mysql-5.6 二进制多实例部署(下)

修改my.cnf（在一个文件中修改即可）

vim /etc/my.cnf

1. [client]
2. port=3306
3. socket=/tmp/mysql.sock
4. [mysqld_multi] #一定要配置的，管理多实例
5. mysqld = /usr/local/mysql/bin/mysqld_safe
6. mysqladmin = /usr/local/mysql/bin/mysqladmin
7. log = /data/mysql/mysqld_multi.log
8. [mysqld] #服务端公用配置
9. user=mysql
10. basedir = /usr/local/mysql
11. sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
12. [mysqld3306] #3306实例的私有配置
13. mysqld=mysqld
14. mysqladmin=mysqladmin
15. datadir=/data/mysql/mysql_3306/data
16. port=3306
17. server_id=3306
18. socket=/tmp/mysql_3306.sock
19. log-output=file
20. slow_query_log = 1
21. long_query_time = 1
22. slow_query_log_file = /data/mysql/mysql_3306/log/slow.log
23. log-error = /data/mysql/mysql_3306/log/error.log
24. binlog_format = mixed
25. log-bin = /data/mysql/mysql_3306/log/mysql3306_bin
26. [mysqld3307] #3307私有配置
27. mysqld=mysqld
28. mysqladmin=mysqladmin
29. datadir=/data/mysql/mysql_3307/data
30. port=3307
31. server_id=3307
32. socket=/tmp/mysql_3307.sock
33. log-output=file
34. slow_query_log = 1
35. long_query_time = 1
36. slow_query_log_file = /data/mysql/mysql_3307/log/slow.log
37. log-error = /data/mysql/mysql_3307/log/error.log
38. binlog_format = mixed
39. log-bin = /data/mysql/mysql_3307/log/mysql3307_bin

.初始化数据库

初始化3306数据库 /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/mysql/mysql_3306/data --defaults-file=/etc/my.cnf

初始化3307数据库 /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/mysql/mysql_3307/data --defaults-file=/etc/my.cnf

检查数据库是否初始化成功 出现两个”OK”

file

8.设置启动文件 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

9.mysqld_multi进行多实例管理 启动全部实例：/usr/local/mysql/bin/mysqld_multi start

查看全部实例状态：/usr/local/mysql/bin/mysqld_multi report

启动单个实例：/usr/local/mysql/bin/mysqld_multi start 3306

停止单个实例：/usr/local/mysql/bin/mysqld_multi stop 3306

查看单个实例状态：/usr/local/mysql/bin/mysqld_multi report 3306

10.启动全部实例 /usr/local/mysql/bin/mysqld_multi start /usr/local/mysql/bin/mysqld_multi report

11.配置密码 mysql的root用户初始密码是空，所以需要登录mysql进行修改密码，下面以3306为例：

登陆，也可以正常的加端口用ip登陆 mysql -S /tmp/mysql_3306.sock set password for root@'localhost'=password('123456'); flush privileges;