Windowsmysql bidirectional synchronization settings

If you need a two-way synchronization environment for the windowsmysql master and slave, follow these steps:

If you need a two-way synchronization environment for windows mysql master and slave, follow these steps:

Host operations

######

#

Host operations

#

Verify Data Synchronization

| 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 |

#

Node:

#

-> MASTER_LOG_POS = 98 ;#

Slave_IO_Running: Yes

Slave_ SQL _Running: Yes

Other ">

Other ">

Other ">

Other ">

Other ">

Other ">