dwayne_22491
Nimbostratus
Jan 25, 2011Remote execution of script from GTM
I have two sites, one of which is the primary and the other which is secondary. I have MySQL databases at both and need to be able to keep track of which site is currently the primary and execute scripts on the MySQL servers in the event of a failure which will take care of necessary locking/unlocking/cleanup/etc of the database. What is the best way to accomplish this (sample code in addition to the methodology would be greatly appreciated)?