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

replicate_ignore_table is not honored in a Galera Cluster

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Not a Bug
    • Affects Version/s: 10.4.13
    • Fix Version/s: N/A
    • Component/s: Galera
    • Labels:
      None
    • Environment:
      CENTOS 7

      Description

      Galera Config:
      [mysqld]
      log-bin
      binlog_format=ROW
      default-storage-engine=innodb
      innodb_autoinc_lock_mode=2
      bind-address=0.0.0.0

      1. Galera Provider Configuration
        wsrep_on=ON
        wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
      1. Galera Cluster Configuration
        wsrep_cluster_name="test_cluster"
        wsrep_cluster_address="gcomm://192.168.56.101,192.168.56.105,192.168.56.106"
      1. Galera Synchronization Configuration
        wsrep_sst_method=rsync
      1. Galera Node Configuration
        wsrep_node_address="192.168.56.101"
        wsrep_node_name="debug"
      1. Table configuration
        replicate_ignore_table=mfg.backend_fixtureprocess

      The Galera cluster has 3 nodes.

      Node 3:
      MariaDB [mfg]> select * from backend_fixtureprocess;
      ----------------------------------------------+

      fixture_name process_id

      ----------------------------------------------+

      1-3 234de06ee794423dbe95c22586a003ab
      1-4 f19f668c491e4f49a86f4a750dbcf4da
      1-5 f5dfb550380a4cf9a3f5ba9fc702e7b2
      2-3 4d001043269b4483b3c5abaf3b1c4aa5
      3-2 f61c4892dd554e3dac4ac0d5fe0f5e33

      ----------------------------------------------+

      After I issue:
      update backend_fixtureprocess set process_id='blahblah' where fixture_name="1-3";

      It gets replicated on the other 2 nodes
      Node 2:
      MariaDB [mfg]> select * from backend_fixtureprocess;
      ----------------------------------------------+

      fixture_name process_id

      ----------------------------------------------+

      1-3 blahblah
      1-4 f19f668c491e4f49a86f4a750dbcf4da
      1-5 f5dfb550380a4cf9a3f5ba9fc702e7b2
      2-3 4d001043269b4483b3c5abaf3b1c4aa5
      3-2 f61c4892dd554e3dac4ac0d5fe0f5e33

      ----------------------------------------------+
      5 rows in set (0.000 sec)

      Node 1:
      MariaDB [mfg]> select * from backend_fixtureprocess;
      ----------------------------------------------+

      fixture_name process_id

      ----------------------------------------------+

      1-3 blahblah
      1-4 f19f668c491e4f49a86f4a750dbcf4da
      1-5 f5dfb550380a4cf9a3f5ba9fc702e7b2
      2-3 4d001043269b4483b3c5abaf3b1c4aa5
      3-2 f61c4892dd554e3dac4ac0d5fe0f5e33

      ----------------------------------------------+

      ------------------------------------------------------------+

      Variable_name Value

      ------------------------------------------------------------+

      replicate_annotate_row_events ON
      replicate_do_db  
      replicate_do_table  
      replicate_events_marked_for_skip REPLICATE
      replicate_ignore_db  
      replicate_ignore_table mfg.backend_fixtureprocess
      replicate_wild_do_table  
      replicate_wild_ignore_table  

      ------------------------------------------------------------+
      I opened it as blocker because I am unable to continue deployment.

      Thank you for reviewing it.

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            alexnagy73 Alexandru Nagy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: