mysql主从

开启两台mysql log-bin.log
server_id不能相同 设置从服务器server_id=2;

主服务器建立一个主从账号
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY '1234';

查看主服务器信息(主要是file,position供从服务器使用)
SHOW MASTER STATUS;

stop

CHANGE MASTER TO
MASTER_HOST='192.168.3.175',MASTER_USER='slave',MASTER_PASSWORD='1234',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=154;

START SLAVE;

查看主从状态
show slave status;
//两项yes代表成功
slave_io_running yes
slave_sql_running yes