Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23504

binlog_ignore_db keep replicating mysql user

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.13
    • None
    • Replication
    • 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`
      /!/;

      1. 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./;
      2. 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`
        /!/;
      3. 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./;
      4. 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            cehau37 Hau
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.