Link You Today
Bookmark your Free, Libre software & tech link

Checking if a Slave Has Applied a Transaction from the Master

mariadb, mysql, percona

In this blog post, we will discuss how we can verify if an application transaction executed on the master has been applied to the slaves… One way to do this is using a built-in function called MASTER_POS_WAIT. This function receives a binary log name and position. It will block the query until the slave applies transactions up to that point, or timeout.