[MDEV-421] Galera: replication ignores binlog-do-db and binlog-ignore-db for DDL, although honors them for DML Created: 2012-08-01  Updated: 2019-12-14  Resolved: 2019-12-14

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 5.5.33a-galera
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 1
Labels: galera

Issue Links:
Relates

 Description   

If a server is started with binlog-ignore-db or binlog-do-db, Galera still magically replicates DDL statements which relate to the databases chosen to be ignored (even although the statements are not written to the binary log).
DML works as expected.

The problem is not limited to breaking rather confusing rules for SBR vs RBR, but shows up in the simplest possible case:

- start 1st node with --binlog-ignore-db=test;
 
- start 2nd node with --binlog-ignore-db=test;
 
- synchronize the nodes;
 
- connect to the 1st node, set test as a default schema (if it's MySQL client, run USE test);
 
- run CREATE TABLE t (i INT PRIMARY KEY);
 
- connect to the 2nd node, set test as a default schema;
 
- run SHOW TABLES to see that the table is there;   <<<=== This is the wrong behavior
 
- run INSERT INTO t VALUES (1);
 
- check that the table is still empty on the 1st node.
 
- optionally: run SHOW BINLOG EVENTS on the 1st node to see that CREATE TABLE statement is not there.

bzr version-info

revision-id: seppo.jaakola@codership.com-20120612212332-h2ay711nh1vhaiob
 
date: 2012-06-13 00:23:32 +0300
 
build-date: 2012-08-01 04:51:46 +0400
 
revno: 3341

Note: If it's another limitation, it should be added to http://www.codership.com/wiki/doku.php?id=limitations

 Comments   
Comment by Elena Stepanova [ 2014-03-18 ]

Nirbhay,

Could you please see if it's still relevant, if it is, decide whether there is anything to be done about it, and update the report accordingly?

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

Hi elenst, It is still the case. binlog-[do|ignore]-db is currently honored only for InnoDB DML updates.
However, I believe it can be fixed for DDLs too. For now, added a note to the Galera limitations KB :
https://mariadb.com/kb/en/mariadb-galera-cluster-known-limitations/

Comment by Jan Lindström (Inactive) [ 2019-12-14 ]

Support for 5.5-galera has ended.

Generated at Thu Feb 08 06:28:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.