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?
Thanks,
Eduardo
----- Original Message -----
From: "Fred van Engen" <fred.van.engen@stripped>
To: "Eduardo D Piovesam" <eduardo@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, December 03, 2003 10:32 AM
Subject: Re: Replication : blocking updates to slave
> Eduardo,
>
> On Wed, Dec 03, 2003 at 10:25:28AM -0200, Eduardo D Piovesam wrote:
> > We're using replication (1 master + 1 slave), and we want to block
updates /
> > deletes, issued by the users, to the slave.
> >
> > Because sometimes they get confused and use the slave as the master...
got
> > it?
> >
>
> Give their account different GRANTs on the master than on the slave(s)
> and make sure that GRANTs (the `mysql` database) are not replicated from
> the master to the slaves.
>
>
> Regards,
>
> Fred.
>
> --
> Fred van Engen XB Networks B.V.
> email: fred.van.engen@stripped Televisieweg 2
> tel: +31 36 5462400 1322 AC Almere
> fax: +31 36 5462424 The Netherlands
>
