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

galera replication filter & myisam does not filter

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5.37-galera
    • None
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.