mysql集群搭建相关命令

主库配置：
1.cp /etc/my.cnf /etc/my.cnf.bak
2.cp /usr/local/tmp/my.cnf /etc/
备份my.cnf文件
3.vim /etc/my.cnf

4.启动mysql
[root@localhost /]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@localhost /]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
[root@localhost /]# service mysql restart
5.进入mysql
mysql -u root -p123456
6.创建从库访问主库的用户信息
GRANT all privileges ON . to 'slave'@'192.168.159.135' identified by '123456' with grant option;

flush privileges;
7.use mysql(切换数据库)
8.select user,host from user;

9. mysql>show master status;
主库信息

从库配置：
find / -name file
1.cp /etc/my.cnf /etc/my.cnf.bak
2.cp /usr/local/tmp/my.cnf /etc/
备份my.cnf文件
3.vim /etc/my.cnf

4.修改uuid 因为复制问题导致的uuid重复
vim /usr/local/mysql/data/auto.cnf
5.重启mysql服务
/usr/local/mysql/support-files/mysql.server start
/usr/local/mysql/support-files/mysql.server restart
/usr/local/mysql/support-files/mysql.server start
6.配置slave
(1).访问mysql
mysql -uroot -p123456
(2).停止slave(mysql5.5以上默认有slave功能，但是无效)
stop slave
7.配置主库信息
change master to master_host='192.168.159.134' , master_user='slave' , master_password='123456' ,
master_log_file='master_log.000008',master_log_pos=4;

change master to master_host='192.168.159.129' , master_user='slave' ,
master_password='123456' , MASTER_LOG_FILE='master_log.000001';

启动slave
start slave;

查看配置的结果
mysql> show slave status\G;