Breaking Semisynchronous Replication in MySQL 5.5
1
vote
2
answers
383
views
I've set up Semisynchronous Replication between two MySQL 5.5 servers running on Windows 7.
My application is running and updating the database of the master server and same is being updated in the slave database server.
But due to some unknown reasons sometimes, Replication breaks.
On running the command:
SHOW STATUS LIKE 'Rpl_semi_sync%';
It gives this status:
'Rpl_semi_sync_master_no_times', '0'
'Rpl_semi_sync_master_no_tx', '0'
'Rpl_semi_sync_master_status', 'ON' <<-------------
'Rpl_semi_sync_master_timefunc_failures', '0'
'Rpl_semi_sync_master_tx_avg_wait_time', '338846'
'Rpl_semi_sync_master_tx_wait_time', '29479685'
'Rpl_semi_sync_master_tx_waits', '87'
'Rpl_semi_sync_master_wait_pos_backtraverse', '0'
'Rpl_semi_sync_master_wait_sessions', '0'
'Rpl_semi_sync_master_yes_tx', '3106'
Ideally, in semi synchronization, when the sync breaks the status should come as OFF since master is not able to receive any acknowledgement from the slave.
Please help us in this regard.
Asked by Neeru Sharma
(173 rep)
Mar 12, 2013, 10:32 AM
Last activity: Aug 30, 2013, 01:41 PM
Last activity: Aug 30, 2013, 01:41 PM