From: Database System
Date: March 15 2011 6:05pm
Subject: Re: Certain replication
List-Archive: http://lists.mysql.com/replication/2074
Message-Id: <309559.60741.qm@web113802.mail.gq1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Thank you very much for help.

--- On Tue, 3/15/11, Johan De Meersman <vegivamp@stripped> wrote:

> From: Johan De Meersman <vegivamp@stripped>
> Subject: Re: Certain replication
> To: database100@stripped
> Cc: replication@stripped
> Date: Tuesday, March 15, 2011, 12:24 PM
> ----- Original Message -----
> > From: "Database System" <database100@stripped>
> > 
> > Does GRANT command should be replicated?
> > In my master my.ini file, I have binlog-do-db=mysql,
> But I granted a
> > user privilege, it was added on the master server, it
> was not
> > replicated. It is not in the binlog file. I think any
> change to the
> > mysql database should be replicated by my setting.
> What's wrong?
> 
> Mmm... GRANT/REVOKE aren't, technically, statements against
> a database, they're statements against the authentication
> system. I suspect the binlog-do-db is why they don't
> replicate.
> 
> Row-based replication may replicate them, as that
> replicates actual database changes instead of statements;
> but that option comes with it's own caveats.
> 
> 
> -- 
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>