Hi Fred,
> 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.
We want to have a full copy of our database, to put it online again if
something goes wrong with the master...
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 11:21 AM
Subject: Re: Replication : blocking updates to slave
> Eduardo,
>
> 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
> > master.
> >
>
> 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.
>
>
> Regards,
>
> Fred.
>
>
> > ----- 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
> > >
> >
>
> --
> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>
