On Wed, Dec 03, 2003 at 10:56:56AM -0200, Eduardo D Piovesam wrote:
> But we want to replicate the mysql database... we want a exact copy of the
You would just be missing the mysql.* tables and those are only used for
permission related stuff. Permissions are exactly what you want to be
different between slaves and master.
> Is there another way?
Not that I know of. I just looked at the startup options but couldn't
find anything for this purpose.
> ----- 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...
> > > 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
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