On Jul 24, 2010, at 12:47 PM, Bryan O'Neal wrote:
I agree with Alex but this just follows logical design of separation. You dev, qa, prod, ha, and dr environments should be separated and used for those set purposes. Unfortunately I also know that if this most elementary step has not been take it is usually due to a lack of required resources not simple oversight. But even if you do that should not replace the monitoring scripts or, as you mentioned, the commitment to repeatable and documented automated operations.
Not a big deal to run multiple instances of MySQL on different ports on the slave machine. Search for mysqld_multi.
BTW Alex if all you want to do is verify you are in sync you can do a checksum on the tables in both servers. If they are in sync the checksums will match - again, great automated monitoring check.
You can do that if mysql is stopped. --------------------------------------------------- PLUG-discuss mailing list - [email protected] To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
