From: Eduardo D Piovesam
Date: December 3 2003 12:56pm
Subject: Re: Replication : blocking updates to slave
List-Archive: http://lists.mysql.com/mysql/154935
Message-Id: <001301c3b99c$ee509100$d275e7c8@afaxtd210>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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?

Thanks,
Eduardo


----- Original Message -----
From: "Fred van Engen" <fred.van.engen@stripped>
To: "Eduardo D Piovesam" <eduardo@stripped>
Cc: <mysql@stripped>
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: fred.van.engen@stripped                Televisieweg 2
> tel: +31 36 5462400                         1322 AC  Almere
> fax: +31 36 5462424                         The Netherlands
>