Laurent Laborde wrote:
> BIG PS : That was my biggest concern. i wasn't 100% that lock set will
> or will not lock the slave too.
> it never lock the slaves, so you can keep your slave in production
> while moving the master :)
> yay \o/
>   
The really essential thing about LOCK SET is that it eliminates the 
ability to enter *new* replication data.  It locks the origin down so 
that there's no extra replication data to "slip in sideways" that could 
get lost when you switch the origin.

On subscriber nodes, the tables were already "locked" against updates 
(see the "denyaccess" triggers), so LOCK SET is effectively a no-op on them.