如果你需要windows mysql 主、备机双向同步环境，可按照以下步骤进行操作
######
#
#
| Position | Binlog_Do_DB| Binlog_Ignore_DB |
98 | ikey_db,ikey_log ||
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.101
Master_User: ym
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 98
Relay_Log_File: testBBB-relay-bin.000002
Relay_Log_Pos: 235
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: ikey_db,ikey_log
| Position | Binlog_Do_DB| Binlog_Ignore_DB |
118 | ikey_db,ikey_log ||
-> MASTER_HOST='192.168.1.103',# Master
-> MASTER_USER='ym',
->MASTER_PASSWORD='ym',-> ->MASTER_LOG_FILE='mysql-bin.000002',#
-> MASTER_LOG_POS=118;#
| Position | Binlog_Do_DB| Binlog_Ignore_DB |
98 | ikey_db,ikey_log ||
#
#
-> MASTER_LOG_POS=98;#
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
下载本文
