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" <[EMAIL PROTECTED]> To: "Eduardo D Piovesam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > > To: "Eduardo D Piovesam" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] Televisieweg 2 > > > tel: +31 36 5462400 1322 AC Almere > > > fax: +31 36 5462424 The Netherlands > > > > > > > -- > Fred van Engen XB Networks B.V. > email: [EMAIL PROTECTED] 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
