Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
22.08.14
-
MXS-SPRINT-221
Description
A client wants to prevent user and user privilege statements from replicating to an offsite replica.
This replica replicates via a binlog router.
The issue is important for the client as they want to use the offsite replica with different users and privileges compared to their on-premise databases and is blocking our ability to fulfil their request. (see support ticket).
I setup an binlog filter to exclude mysql.user statements but the filter does not exclude the create user, grant statements from running via replication on the offsite replica
https://mariadb.com/kb/en/mariadb-maxscale-2208-binlog-filter/
– based on documentation
– exclude/ignore any statements going to mysql.user
[BinlogFilter]
|
type=filter
|
module=binlogfilter
|
exclude=/mysql[.]user/
|
When I reviewed the binlog there is no mention of a table (mysql.user) when those grant statements are run.