[MDEV-6229] galera replication filter & myisam does not filter Created: 2014-05-11  Updated: 2018-07-27  Resolved: 2014-06-20

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.37-galera
Fix Version/s: None

Type: Bug Priority: Major
Reporter: doekia Assignee: Nirbhay Choubey (Inactive)
Resolution: Won't Fix Votes: 0
Labels: galera, replication
Environment:

debian wheezy
3x master/master galera cluster


Issue Links:
Relates

 Description   

Reproduction step:

my.cnf
 
...
 
[server]
 
wsrep_replicate_myisam=ON
 
replicate_wild_ignore_table=a_local_database.% ...
 
...
 

node1> CREATE TABLE `a_local_database`.`a_table` (  `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,  `data` varchar(64) NOT NULL )  ENGINE='MyISAM' COLLATE 'utf8_bin';
 
 
 
node2> CREATE TABLE `a_local_database`.`a_table` (  `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,  `data` varchar(64) NOT NULL )  ENGINE='MyISAM' COLLATE 'utf8_bin';
 
Error in query (1050): Table 'a_table' already exists 
 
 
node1> INSERT INTO `a_local_database`.`a_table` VALUES(null,'node1');
 
1 row inserted
 
 
 
node2> SELECT * from  `a_local_database`.`a_table`;
 
+----+-------+
 
| id | data  |
 
+----+-------+
 
|  1 | node1 |
 
+----+-------+
 
1 row in set (0.00 sec)

======
As a general comment, precedence of replication filters should be explained in the documentation.

 Comments   
Comment by Elena Stepanova [ 2014-05-11 ]

I'm not sure these replication filters are expected to have any effect on Galera replication, but nirbhay_c will be able to say for sure.
And indeed, if they don't work with Galera, it should be documented, I failed to find anything.

Comment by doekia [ 2014-06-18 ]

Any feedback regarding such?

Comment by Nirbhay Choubey (Inactive) [ 2014-06-18 ]

"replicate_wild_ignore_table" affects replication slave thread which is not used in Galera replication.
Also, a similar feature (if implemented & used) will certainly bring data inconsistency across galera
nodes, which is undesirable. I will updates the docs.

Comment by Nirbhay Choubey (Inactive) [ 2014-06-20 ]

Hi doekia, I looked futher into the replication filter support and it turned out that
except for DML updates for InnoDB tables, replicate-wild-[do|ignore]-table is
currently not support. So unfortunately, it cannot be used for MyISAM tables.

Added a note in the Galera limitations page :
https://mariadb.com/kb/en/mariadb-galera-cluster-known-limitations/

Comment by Nirbhay Choubey (Inactive) [ 2014-06-20 ]

Its a limitation for MyISAM engine. Closing it as won't fix as replication of MyISAM tables is still considered 'experimental' in Galera.

Generated at Thu Feb 08 07:10:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.