Re: Replication : blocking updates to slave

[Fred van Engen]

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: [phone]                         1322 AC  Almere
fax: [phone]                         The Netherlands