Can i control access end point When some table data changed In Mysql Semisynchronous Replication
"Semisync" implies


One of the slaves has received the DML and stored it safely (in the relay log).
That slave has not necessarily applied the statement.
If the Master crashes, then at least one slave has every transaction that was COMMITted on the Master.
Once you find that Slave, you could promote it to Master with confidence.