MySQL Forums
Forum List  »  Replication

Semi Sync replication with MySQL 5.7
Posted by: Devrishi Shandilya
Date: June 06, 2016 08:00AM

Hi Friends,

I want to troubleshoot semi sync replication performance, so that come to know, where was the issue or root cause of tx commit delay.

I processed 25000 inserts statement with Async and Semi sync replication.
with Async replication, all statements executes in 13 seconds master.
with Semi sync repl, all statements executes in 1.54 minutes on master.

How can i break and monitor the entire process of semi sync replication.

1- Tx on master and written to binlog
2- binlog flush to disk
3- Tx sent to slave's relay log
4- Relay log flush to disk
5- Acknowledgement received on master and tx commit on master.

I need to know, which state is responsible for delay, and how we can tune it.

Apart for that, slave_compressed_protocol is compatible with semi sync repl or not in MySQL 5.7

I set it 1 on my semi sync slave and then all my tx not successfully acknowledged by slave.

variable 'Rpl_semi_sync_master_no_tx' value updates to all my transactions ?

can any one help me out to understand this behaviour ?

I am using semi sync repl with MySQL 5.7.12 with "AFTER_SYNC".

Options: ReplyQuote


Subject
Views
Written By
Posted
Semi Sync replication with MySQL 5.7
1420
June 06, 2016 08:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.