mysql主从同步
主,修改mysql配置文件
windows文件目录:C:\Program Files\MySQL\MySQL Server 6.0\my.ini
linux文件目录:/etc/mysql/my.cnf
log-bin=mysql-bin#开启二进制日志
server-id=1
binlog-do-db=f#需要同步的数据库
重启mysql
sudo /etc/init.d/mysql restart
SHOW MASTER STATUS;
------------------------------------------------------------------------------------------------------
从,修改mysql配置文件[mysqld]
server_id = 2
log-bin=my-bin
重启mysql
sudo /etc/init.d/mysql restart
mysql>CHANGE MASTER TO
>MASTER_HOST=’192.168.95.11’,
>MASTER_USER=’mysql12’,
>MASTER_PASSWORD=’mysql12’,
>MASTER_LOG_FILE=’mysql-bin.000048’,
>MASTER_LOG_POS=432;
、
mysql>SLAVE START; #开启复制
mysql>SHOW SLAVE STATUS\G #查看主从复制是否配置成功
当看到Slave_IO_Running: YES、Slave_SQL_Running: YES才表明状态正常