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

binlog_ignore_db keep replicating mysql user

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3.13
    • Fix Version/s: None
    • Component/s: Replication
    • Labels:
    • Environment:
      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

            Assignee:
            Unassigned Unassigned
            Reporter:
            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.