Hi Duncan,

Great tip!

It's not exactly what I was looking for (block only updates, and permit
selects), but it's the best option...

Removing the mysql db from replicating, and then granting only selects to
the users, will cause more work to us when the master "crash"... we'll need
to rebuild all the priveleges on the slave.

Thanks,
Eduardo


----- Original Message -----
From: "Duncan Hill" <[EMAIL PROTECTED]>
To: "Eduardo D Piovesam" <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 11:00 AM
Subject: Re: Replication : blocking updates to slave


> On Wednesday 03 December 2003 12:56, Eduardo D Piovesam wrote:
> > Hi Fred, thanks for reply.
> >
> > But we want to replicate the mysql database... we want a exact copy of
the
> > master.
> >
> > Is there another way?
>
> Firewall the users from the slave server?  If they're not meant to use it,
> don't let them see it.
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to