Name

MASTER_POS_WAIT( )

Synopsis

MASTER_POS_WAIT(filename, position[, timeout])

Use this function to synchronize MySQL master and slave server logging. The function causes the master to wait until the slave server has read and applied all updates to the position (given in the second argument) in the master log (named in the first argument). You can specify a third argument to set the number of seconds the master will wait. The function returns the number of log entries that were made by the slave while the master was waiting. A value of NULL is returned if there is an error.

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.