Re: MySQL grant use?

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Alex Dean
Date:  
To: Main PLUG discussion list
Subject: Re: MySQL grant use?

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