I may also recommend that you don't do selective replication. Due to the ability to manipulate data using fully qualified statements you can circumvent replication rules. So it is best not to have them. I also highly recommend you do not do circular replication, which is typically the next brilliant idea after writing to the slaves which should be read only..

On Fri, Jul 23, 2010 at 6:03 PM, der.hans <PLUGd@lufthans.com> wrote:
Am 23. Jul, 2010 schwätzte Ben Trussell so:


With the general query log enabled in advance its easy to see when a
and by whom a query was run, just be sure to put that log in the
logrotate cycle because it can get big, fast..

Yeah, not activating that on prod :).

But, I might be able to block those users on prod and audit them on the
slaves as we want to move unnecessary load off of prod anyway.


ciao,

der.hans
--
#  http://www.LuftHans.com/Classes        http://www.TwoGeekTechs.com/
#  Director of Engineering, FonWallet Transaction Solutions, Inc.
#  Don't step in front of speeding cars, don't eat explosives
#  and don't use m$ LookOut :). - der.hans
---------------------------------------------------
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