MySQL grant use?

[Alex Dean]

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.