Hi Duncan,
Great tip!
It's not exactly what I was looking for (block only updates, and permit
selects), but it's the best option...
Removing the mysql db from replicating, and then granting only selects to
the users, will cause more work to us when the master "crash"... we'll need
to rebuild all the priveleges on the slave.
Thanks,
Eduardo
----- Original Message -----
From: "Duncan Hill" <duncanh@stripped>
To: "Eduardo D Piovesam" <eduardo@stripped>
Sent: Wednesday, December 03, 2003 11:00 AM
Subject: Re: Replication : blocking updates to slave
> On Wednesday 03 December 2003 12:56, Eduardo D Piovesam wrote:
> > Hi Fred, thanks for reply.
> >
> > But we want to replicate the mysql database... we want a exact copy of
the
> > master.
> >
> > Is there another way?
>
> Firewall the users from the slave server? If they're not meant to use it,
> don't let them see it.
>
>
