Would using firewall style access control be an option? You would configure iptables (or whatever access filter the slave computer supported) to deny access from users to the MySQL port of the slave machine.
Fred van Engen wrote:
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
-- Lloyd Kvam Venix Corp. 1 Court Street, Suite 378 Lebanon, NH 03766-1358
voice: 603-653-8139 fax: 801-459-9582
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]