mysql雙機互備方式如何配置

這篇文章主要介紹了mysql雙機互備方式如何配置，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓小編帶著大家一起了解一下。

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

----------測試是否正確。

感謝你能夠認真閱讀完這篇文章，希望小編分享的“mysql雙機互備方式如何配置”這篇文章對大家有幫助，同時也希望大家多多支持億速云，關注億速云行業資訊頻道，更多相關知識等著你來學習!