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

Galera: replicate-do-db and replicate-ignore-db filters not honored at all

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.1.22, 10.0.30-galera
    • N/A
    • Galera, Replication
    • None
    • OS: Linux (Debian Jessie)

    Description

      I have a Galera cluster with 3 nodes, all configured like so (only differing in wsrep_node_address and wsrep_node_name):

      [galera]
      wsrep_on=ON
      wsrep_provider=/usr/lib/galera/libgalera_smm.so
      wsrep_cluster_name="test_cluster"
      wsrep_cluster_address="gcomm://172.17.0.2,172.17.0.3,172.17.0.4"
      wsrep_sst_method=rsync
      wsrep_node_address="172.17.0.2"
      wsrep_node_name="master1-node"
      binlog_format=row
      default_storage_engine=InnoDB
      innodb_autoinc_lock_mode=2
      bind-address=0.0.0.0
       
      [mysqld]
      replicate-do-db=replicated_db
      

      While replication appears to work fine, the replicate-do-db and replicate-ignore-db filters are not honored at all. According to https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/, they should.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            Richard Cox Richard Cox
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.