win下maridb 10.1.8下主从复制配置

win下maridb 10.1.8下主从复制配置

主库配置

server_id=1read-only=0replicate-do-db=mydatalog-bin=mysql-bin

主库权限设置

GRANT replication slave ON *.* TO'backup'@'%' identified BY 'password';

flush PRIVILEGES;

GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES ON `mydata`.* TO 'backup'@'%' WITH GRANT OPTIONFLUSH PRIVILEGES;

show master status

从库配置：

server_id=2read-only=1replicate-do-db=mydatalog-bin=mysql-bin

change master to MASTER_HOST='172.20.42.224', MASTER_USER='backup',MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000085',MASTER_LOG_POS=839, master_connect_retry=60,MASTER_PORT=3307

注意点：mysql-bin.000085 和 839 这2个参数来自主库show master status的查询。

stop SLAVE

START slave

SHOW SLAVE status

这三个状态 slave_IO_state、slave_IO_running、slave_SQL_running 是yes，配置成功。

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。