[MDEV-7203] replicate_events_marked_for_skip didn't work on Galera cluster Created: 2014-11-25  Updated: 2015-03-11  Resolved: 2015-03-06

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.0.13-galera, 10.0.14-galera
Fix Version/s: 5.5.43-galera, 10.0.17-galera

Type: Bug Priority: Blocker
Reporter: Aurélien LEQUOY Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: galera


 Description   

the cluster & replication :

https://farm8.staticflickr.com/7544/15874745401_d3975432f6_b.jpg

my galera.ini

[mysqld]
#mysql settings

log-slave-updates=1
default-storage-engine=innodb
query_cache_size=0
query_cache_type=0
bind-address=0.0.0.0

server-id=1746717299

skip-slave-start

datadir = /data/mysql/data
#galera settings
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_name="iways_cluster"
wsrep_cluster_address="gcomm://10.7.20.3,10.7.20.4,10.7.20.6"
wsrep_sst_method=rsync
wsrep_provider_options="gcache.size=20G"

#innoDB
innodb_file_per_table
connect_timeout = 60
wait_timeout = 3600
innodb_buffer_pool_size = 16G
innodb_flush_method = O_DIRECT

innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_autoinc_lock_mode=2

#for master

binlog_format=ROW
log_bin = /data/mysql/binlog/mariadb-bin
log_bin_index = /data/mysql/binlog/mariadb-bin.index
max_binlog_size = 1G
expire_logs_days = 10

sync_binlog=1

sort_buffer_size = 10M
bulk_insert_buffer_size = 16M
tmp_table_size = 64M
max_heap_table_size = 64M

#log
slow_query_log_file = /data/mysql/log/mariadb-slow.log
long_query_time = 1

performance_schema = 'ON'

collation-server = utf8_unicode_ci
character-set-server = utf8
init-connect = 'SET NAMES utf8'

max_connections = 500
open_files_limit = 65535
log-error=/data/mysql/log/error.log

on node 1 :
use PRODUCTION;
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

INSERT INTO `PRODUCTION`.`test` (`id`) VALUES ('1'), ('2');

====
two rows are present on all servers (and on slave)

slave have configuration :
replicate-events-marked-for-skip = filter_on_slave

=========
if i run on node 2 :
SET @@skip_replication = ON;
delete from test where id =1;

it's work perfectly, i still got the line on slave

========

if i run on node 1 or 3 :
SET @@skip_replication = ON;
delete from test where id =1;

it's didn't work, I lost the line on the slave.

-I saw this problem has been fixed on 10.0.14, I would to know if it was knowed.-



 Comments   
Comment by Aurélien LEQUOY [ 2014-12-05 ]

I made a terrible mistake, it's don't work on 10.0.14-galera too just fusked my history server

Comment by Nirbhay Choubey (Inactive) [ 2015-03-05 ]

http://lists.askmonty.org/pipermail/commits/2015-March/007519.html

Comment by Jan Lindström (Inactive) [ 2015-03-06 ]

ok to push.

Comment by Nirbhay Choubey (Inactive) [ 2015-03-06 ]

https://github.com/MariaDB/server/commit/c6acdf7c281f91026cfac549d718511b9ed083aa

Generated at Thu Feb 08 07:17:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.