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

galera replication filter & myisam does not filter

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Won't Fix
        • Affects Version/s: 5.5.37-galera
        • Fix Version/s: None
        • Component/s: None
        • Environment:
          debian wheezy
          3x master/master galera cluster

          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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment - - edited

                I'm not sure these replication filters are expected to have any effect on Galera replication, but Nirbhay Choubey 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.

                Show
                elenst Elena Stepanova added a comment - - edited I'm not sure these replication filters are expected to have any effect on Galera replication, but Nirbhay Choubey 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.
                Hide
                Permalink
                doekia doekia added a comment -

                Any feedback regarding such?

                Show
                doekia doekia added a comment - Any feedback regarding such?
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                "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.

                Show
                nirbhay_c Nirbhay Choubey added a comment - "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.
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment - - edited

                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/

                Show
                nirbhay_c Nirbhay Choubey added a comment - - edited 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/
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

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

                Show
                nirbhay_c Nirbhay Choubey added a comment - Its a limitation for MyISAM engine. Closing it as won't fix as replication of MyISAM tables is still considered 'experimental' in Galera.

                  People

                  • Assignee:
                    nirbhay_c Nirbhay Choubey
                    Reporter:
                    doekia doekia
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: