MySQL 主从复制
摘要:
Master: 192.186.40.130Slave : 192.186.40.131以下是在Master库进行的操作# 在Master上启用bin log,设置唯一Server IDshell> vi /etc/my.cnf[mysqld]log-bin=mysql-binserver-id = 1# 建立复制用的usermysql>CREATE USER 'repl'@'%' IDENTIFIED BY 'repl';mysql>GRANT REPLICATION SLAVE ON *.* TO 'repl' 阅读全文