1. 发出该语句:
复制代码代码如下:
mysql> FLUSH TABLES WITH READ LOCK;
2. 仍然加锁时,执行该命令(或它的变体):
复制代码代码如下:
shell> tar zcf /tmp/backup.tar.gz /var/lib/mysql
并拷到从服务器上。
3. 发出该语句并且确保记录了以后用到的输出:复制代码代码如下:
mysql>SHOW MASTER STATUS;
4. 释放锁:
复制代码代码如下:
mysql> UNLOCK TABLES;
两个主节点配置
CHANGE MASTER TO
MASTER_HOST='10.0.209.48',
MASTER_PORT=3316,
MASTER_USER='repuser',
MASTER_PASSWORD='repuser',
MASTER_LOG_FILE='mysql-bin.000057', MASTER_LOG_POS= 13895;
CHANGE MASTER TO
MASTER_HOST='10.0.209.51',
MASTER_PORT=3316,
MASTER_USER='repuser',
MASTER_PASSWORD='repuser',
MASTER_LOG_FILE='mysql-bin.000011', MASTER_LOG_POS= 1554;
两个从节点配置