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.