1.mysql主从同步部署
master:10.3.30.243
slave:10.3.30.244
2.master端
vim /etc/my.cnf
server-id = 1 #master端ID号
binlog-do-db = cacti #同步库的名字:wq
mysql -u root -p Fancy
mysql>grant replication slave on *.* to Fancy@'10.3.30.244' identified by 'Fancy';
mysql>flush privileges;
mysql>flush tables with read lock;
mysql>show master status;#记住file和positon,从库需要使用
File | Position |
+------------------+----------
| mysql-bin.000023 | 332
mysql>unlock tables;
3.slave端
vim /etc/my.cnf
server-id = 2 slave的ID号,此处一定要大于master端。
stop slave;
change master to master_host='10.3.30.243', #master端
master_user='Fancy', #master端创建的用于主从同步的密码
master_password='Fancy', #master端创建的用于主从同步的密码
master_port=3306, #master端设置的client端使用的端口号
master_log_file='mysql-bin.000057',#master端记录的file值
master_log_pos=1253536;#master端记录的position值
start slave;
show slave status \G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes两个均为Yes表示成功
Slave_SQL_Running:No解决方案
show variables like ‘server_id’;//查看端口如果唯一重启mysql
Slave_IO_Running:No解决方案
评论0