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

Slave replication filters do not work as excepted

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.21
    • N/A
    • Replication
    • None
    • OpenSuSE 13.2

    Description

      Have a replication slave setup with following configuration:

      [mysqld]
      replicate-rewrite-db = APPLICATION->APPLICATION_QA
       
      replicate-wild-do-table = APPLICATION.%
      replicate-wild-do-table = APPLICATION_QA.%
       
      replicate-wild-ignore-table=APPLICATION_QA.%_tmp
      replicate-wild-ignore-table=APPLICATION_QA.%_old
      replicate-wild-ignore-table=APPLICATION_QA.%upload
       
      replicate-wild-ignore-table=APPLICATION.%_tmp
      replicate-wild-ignore-table=APPLICATION.%_old
      replicate-wild-ignore-table=APPLICATION.%upload

      The intention is to replicate only one specific schema but renaming it (from APPLICATION to APPLICATION_QA). However need to filter some tables. In the example above its %_tmp, %_old, %upload.

      The problem: all tables from master's APPLICATION schema are being replicated.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Vitaliy Vitaliy Margolen
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.