A库：192.168.190.130
B库：192.168.190.131
A库建用户
grant FILE,SELECT, replication slave on *.* to 'gaok_bak'@'192.168.190.131' identified by 'gaok';
flush privileges;
show grants for 'gaok_bak'@'192.168.190.131';
B库建用户
grant FILE,SELECT, replication slave on *.* to 'gaok_bak'@'192.168.190.130' identified by 'gaok';
flush privileges;
show grants for 'gaok_bak'@'192.168.190.130';
A库my.cnf配置(添加以下内容)：
[mysqld]
server-id = 1
log_bin = /usr/local/mysql/data/mysql-bin.log
relay_log = /usr/local/mysql/data/mysql-relay.log
log-slave-updates = ON
sync_binlog=1
auto-increment-increment=10
auto-increment-offset=1
B库my.cnf配置(添加以下内容)：
[mysqld]
server-id = 2
log_bin = /usr/local/mysql/data/mysql-bin.log
relay_log = /usr/local/mysql/data/mysql-relay.log
log-slave-updates = ON
auto-increment-increment=10
auto-increment-offset=1
sync_binlog=1
#####两个mysql重启
A库、B库查看master状态
A库:
change master to
master_host='192.168.190.131',
master_user='gaok_bak',
master_password='gaok',
master_log_file='mysql-bin.000002',
master_log_pos=154;
start slave;
show slave status\G
B库：
change master to
master_host='192.168.190.130',
master_user='gaok_bak',
master_password='gaok',
master_log_file='mysql-bin.000002',
master_log_pos=154;
start slave;
show slave status\G
----------测试是否正确。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23850820/viewspace-2146232/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle 11g中的密码延迟功能
下一篇：
没有了~
请登录后发表评论
登录
全部评论
