Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.13
-
None
-
CentOS Linux release 7.8.2003 (Core)
Description
Hi,
We already set the options below in our .cnf file
[mariadb]
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
replicate_ignore_db=mysql
replicate_ignore_db=information_schema
replicate_ignore_db=performance_schema
but it keeps writing create user in the bin log, thus the user keeps being replicated in the slave.
CREATE USER `cehau37_Copy1`@`193.1.1.2`
/!/;
- at 486
#200818 22:49:56 server id 101 end_log_pos 528 CRC32 0xe766ab23 GTID 0-101-78 ddl
/Unable to render embedded object: File (100001 SET @@session.gtid_seq_no=78*//*) not found./; - at 528
#200818 22:49:56 server id 101 end_log_pos 964 CRC32 0x97eab2e2 Query thread_id=9 exec_time=0 error_code=0
SET TIMESTAMP=1597765796/!/;
GRANT Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create User, Create View, Delete, Drop, Event, Execute, File, Grant Option, Index, Insert, Lock Tables, Process, References, Reload, Replication Client, Replication Slave, Select, Show Databases, Show View, Shutdown, Super, Trigger, Update ON . TO `cehau37_Copy1`@`193.1.1.2`
/!/; - at 964
#200818 22:50:37 server id 101 end_log_pos 1006 CRC32 0x39ea522d GTID 0-101-79 ddl
/Unable to render embedded object: File (100001 SET @@session.gtid_seq_no=79*//*) not found./; - at 1006
#200818 22:50:37 server id 101 end_log_pos 1106 CRC32 0x37325f6f Query thread_id=9 exec_time=0 error_code=0
SET TIMESTAMP=1597765837/!/;
DROP USER `cehau37_Copy1`@`193.1.1.2`
Please help