mysql主从同步开始用的master_log_pos点为77270703,同步失败
(主从同步步骤没错)mysql主从同步开始用的master_log_pos点为77270703, 同步失败,提示 We stopped at log ‘mysql-bin.000033’ position 77270703 ,死活同步失败,不管是删除原来的master.info-重启-重新同步,还是其他的方法,都不行。但是为什么就换了个主服务器后边的master_log_pos点77273546就能实现同步呢?虽然是同步了,但是前面不就要丢一段数据了么?
--主机开两个窗口,一个进入mysql,一个是shell
--主机阻断写操作
mysql> FLUSH TABLES WITHREADLOCK;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW MASTERSTATUS;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000003 | 983407 | openser | mysql,test |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
--另外一个窗口导出主机数据库
mysqldump -u root -ppassword --master-data=2 --opt -R openser > openser20120204.sql
--刚才的窗口主机解锁
mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)
mysql>
--打包数据文件到从机
drop database openser;
create database openser;
mysql -u root -ppassword openser < openser20120204.sql
--从机操作
SLAVE STOP;
reset slave;
CHANGEMASTERTO MASTER_HOST='192.168.21.26',
MASTER_USER='repl_user',
MASTER_PASSWORD='password',
MASTER_LOG_FILE='mysql-bin.000003',
MASTER_LOG_POS=983407;
start slave;
show slave statusG