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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]