MySQL 主从搭建

# 获取主节点的 master 信息
mysql> show master status;

mysql> CHANGE MASTER TO MASTER_HOST='192.168.1.199',MASTER_USER='reader',\
MASTER_PASSWORD='reader',MASTER_LOG_FILE='',MASTER_LOG_POS=0;
mysql> start slave;
mysql> show slave status\G;