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 - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss