mysql主从同步随笔
vim /etc/my.cnf
server-id=1
log-bin=/data/binlog/mysql-bin
binlog-ignore-db=mysql
binlog-ignore-db=test
binlog-ignore-db=information_schema
flush tables with read lock;
show master status;
server-id=2
stop slave;
chage master to
master_host=
master_user=
master_password=
master_port=
master_log-file=
master_log_pos=
start slave;
show slave status;
bitsCN.comCopyright © 2019- tachun.com.cn 版权所有
违法及侵权请联系：TEL:199 18 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务