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

wild-do-table doesn't work for multisource replication with rewriten database name

Details

    Description

      Two masters, one slave. All are running MariaDB 10,1.

      Slave's my.cnf:
      m1.replicate-rewrite-db=testdb->m1testdb
      replicate-do-db=m1testdb
      replicate-wild-do-table=m1testdb.%

      m2.replicate-rewrite-db=testdb->m2testdb
      replicate-do-db=m2testdb
      replicate-wild-do-table=m2testdb.%

      Inserting, updating & deleting on the masters work and changes are replicated to the slave but only when testdb is current db and the table name is unqualified.

      insert into testdb.testtable values(1,2,3) <-- Does NOT work whether testdb is current or not
      insert into testtable values(1,2,3) <-- Works

      Attachments

        Activity

          Hussain Hussain Akbar created issue -
          Hussain Hussain Akbar made changes -
          Field Original Value New Value
          Description Two masters, one slave. All are running MariaDB 10,1.

          Slave's my.cnf:
          m1.replicate-rewrite-db=testdb->m1testdb
          m1.replicate-do-db=m1testdb
          m1.replicate-wild-do-table=m1testdb.%

          m2.replicate-rewrite-db=testdb->m2testdb
          m2.replicate-do-db=m2testdb
          m2.replicate-wild-do-table=m2testdb.%

          Inserting, updating & deleting on the masters work and changes are replicated to the slave but only when testdb is current db and the table name is unqualified.

          insert into testdb.testtable values(1,2,3) <-- Does NOT work whether testdb is current or not
          insert into testtable values(1,2,3) <-- Works
          Two masters, one slave. All are running MariaDB 10,1.

          Slave's my.cnf:
          m1.replicate-rewrite-db=testdb->m1testdb
          replicate-do-db=m1testdb
          replicate-wild-do-table=m1testdb.%

          m2.replicate-rewrite-db=testdb->m2testdb
          replicate-do-db=m2testdb
          replicate-wild-do-table=m2testdb.%

          Inserting, updating & deleting on the masters work and changes are replicated to the slave but only when testdb is current db and the table name is unqualified.

          insert into testdb.testtable values(1,2,3) <-- Does NOT work whether testdb is current or not
          insert into testtable values(1,2,3) <-- Works
          elenst Elena Stepanova made changes -
          Fix Version/s N/A [ 14700 ]
          Resolution Not a Bug [ 6 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 80317 ] MariaDB v4 [ 151953 ]

          People

            Unassigned Unassigned
            Hussain Hussain Akbar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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