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

galera replication filter & myisam does not filter

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • 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.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: