[MDEV-22919] replicate_ignore_table is not honored in a Galera Cluster Created: 2020-06-17  Updated: 2020-06-22  Resolved: 2020-06-22

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.13
Fix Version/s: N/A

Type: Bug Priority: Blocker
Reporter: Alexandru Nagy Assignee: Jan Lindström (Inactive)
Resolution: Not a Bug Votes: 0
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.



 Comments   
Comment by Jan Lindström (Inactive) [ 2020-06-22 ]

replicate_ignore_table is intended to be used with normal asynchronous MySQL replication not for Galera replication.

Generated at Thu Feb 08 09:18:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.