mysql实现主存复制,mysql5.7.21 主存复制

备份

PlUSH TABLES WITH READ LOCK;

mysqldump -u username -p --databases dbname2 dbname2 > weshop_test.sql

mysqldump -uroot -p -h192.168.56.9 --set-gtid-purged=off --databases weshop_test>weshop_t est.sql

UNLOCK TABLES

恢复 mysql -uroot -p -h 127.0.0.1 -P23306  weshop_test

master

[mysqld]

log_bin=master-bin

log_bin_index = master-bin.index

server-id=1

binlog_do_db=weshop_test

binlog_ignore_db = mysql

expire-logs-days=7

执行：

grant replication slave on *.* to 'slave1' @'%' identified by '123456';

show master status;

slave

[mysqld]

server-id=2

relay-log = slave-relay-bin

relay-log-index = slave-relay-bin.index

执行：

change master to master_host='master',master_port=3306,master_user='slave1',master_password='123456',master_log_file='master-bin.000002',master_log_pos=154

show satus status;