1.配置主库:my.ini
[mysqld]
log-bin=catic_log
server-id=3141
2.配置从库my.ini
[mysqld]
server-id=3142
3.在主库上执行
CREATE USER 'repl'@'%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
//mysql 8.0启用了新的加密方式,为兼容改回以前的加密方式
alter user 'repl'@'%' identified with mysql_native_password by '123456';
//刷新
flush privileges;
//锁表操作
FLUSH TABLES WITH READ LOCK;
//手工同以前的数据并解锁
unlock tables;
//查看请库同步状态
SHOW MASTER STATUS;
4.在从库上执行
change master to
master_host='192.168.9.194',
master_port=3306,
MASTER_USER='backup',
MASTER_PASSWORD='123456',
MASTER_LOG_FILE='wgz_log_bin.000001',
MASTER_LOG_POS=156;
//启动主从复制
start slave;
//查看从库配置状态
show slave status;
//停止主从复制,不用执行
-- stop slave;
mySql主从复制实操步骤
最新推荐文章于 2023-03-07 20:33:17 发布