mysql主从能直接修改从库_mysql主从同步 从数据库能修改吗

--主机开两个窗口，一个进入mysql，一个是shell

--主机阻断写操作

mysql> FLUSH TABLES WITH READ LOCK;

Query OK, 0 rows affected (0.00 sec)

mysql>

mysql>

mysql> SHOW MASTER STATUS;

+------------------+----------+--------------+------------------+

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |

+------------------+----------+--------------+------------------+

| mysql-bin.000002 | 1529881 | openser | mysql,test |

+------------------+----------+--------------+------------------+

1 row in set (0.00 sec)

--另外一个窗口导出主机数据库

mysqldump -u root -p123456 --opt -R openser > openser20121203.sql

--刚才的窗口主机解锁

mysql> UNLOCK TABLES;

Query OK, 0 rows affected (0.00 sec)

mysql>

--打包数据文件到从机

drop database openser;

create database openser;

mysql -u root -p123456 openser < openser20121127.sql

--从机操作

SLAVE STOP;

reset slave;

CHANGE MASTER TO MASTER_HOST='192.168.21.26',

MASTER_USER='repl_user',

MASTER_PASSWORD='123456',

MASTER_LOG_FILE='mysql-bin.000002',

MASTER_LOG_POS=1529881;

start slave;

show slave status\G

取消

评论