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

binlog-do-db bypassed by 'create table' DDL

    XMLWordPrintable

Details

    • 5.5.48-0

    Description

      my.cnf (full file attached)

      ...
      binlog-format                  = ROW
      binlog-do-db                   = test_db1
      binlog-do-db                   = test_db2
      ...

      Test case:

      Server version: 10.0.19-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> create database test_db1;
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [(none)]> create database test_db2;
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [(none)]> create database test_db3;
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [(none)]> create table test_db1.t(i int);
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [(none)]> create table test_db2.t(i int);
      Query OK, 0 rows affected (0.01 sec)
       
      MariaDB [(none)]> create table test_db3.t(i int);
      Query OK, 0 rows affected (0.01 sec)
       
      MariaDB [(none)]> insert into test_db1.t values (1);
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [(none)]> insert into test_db2.t values (1);
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [(none)]> insert into test_db3.t values (1);
      Query OK, 1 row affected (0.00 sec)

      Relevant entries in binlog (full file attached)

      create database test_db1
      create database test_db2
      create table test_db1.t(i int)
      create table test_db2.t(i int)
      create table test_db3.t(i int)
      ### INSERT INTO `test_db1`.`t`
      ### INSERT INTO `test_db2`.`t`

      Even though test_db3 is not included in binlog-do-db options, 'create table test_db3.t(i int)' is logged.

      TIA

      Attachments

        1. my.cnf
          0.5 kB
          Carol
        2. mysql-bin.000003
          1 kB
          Carol

        Activity

          People

            serg Sergei Golubchik
            carolmazoy Carol
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.