MySQL 5.1.14 and later.
Data modification statements made to tables in the
mysql
database are replicated according to
the value of binlog_format
;
if this value is MIXED
, these statement are
replicated using the row-based format. However, statements
that would normally update this information indirectly —
such GRANT
,
REVOKE
, and statements
manipulating triggers, stored routines, and views — are
replicated to slaves using statement-based replication.
MySQL 5.1.13 and earlier.
User privileges are replicated only if the
mysql
database is replicated. That is, the
GRANT
,
REVOKE
,
SET PASSWORD
,
CREATE USER
, and
DROP USER
statements take
effect on the slave only if the replication setup includes the
mysql
database.
User Comments
Add your own comment.