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.-
{"report":{"fcp":727.9000000953674,"ttfb":146.29999995231628,"pageVisibility":"visible","entityId":49123,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"c8da7b88-9244-47f2-aadf-a06648345e8c","navigationType":0,"readyForUser":830.5,"redirectCount":0,"resourceLoadedEnd":456.7000000476837,"resourceLoadedStart":154.29999995231628,"resourceTiming":[{"duration":8.400000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":154.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":162.70000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":8.200000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":154.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":162.70000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":193.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":154.70000004768372,"connectEnd":164.5,"connectStart":164.5,"domainLookupEnd":164.5,"domainLookupStart":164.5,"fetchStart":154.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":165.60000014305115,"responseEnd":347.90000009536743,"responseStart":178.79999995231628,"secureConnectionStart":164.5},{"duration":31.800000190734863,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":154.79999995231628,"connectEnd":154.79999995231628,"connectStart":154.79999995231628,"domainLookupEnd":154.79999995231628,"domainLookupStart":154.79999995231628,"fetchStart":154.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":169,"responseEnd":186.60000014305115,"responseStart":185.40000009536743,"secureConnectionStart":154.79999995231628},{"duration":301.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":154.79999995231628,"connectEnd":154.79999995231628,"connectStart":154.79999995231628,"domainLookupEnd":154.79999995231628,"domainLookupStart":154.79999995231628,"fetchStart":154.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":168.5,"responseEnd":456.7000000476837,"responseStart":187.60000014305115,"secureConnectionStart":154.79999995231628},{"duration":33.799999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":155,"connectEnd":155,"connectStart":155,"domainLookupEnd":155,"domainLookupStart":155,"fetchStart":155,"redirectEnd":0,"redirectStart":0,"requestStart":169.10000014305115,"responseEnd":188.79999995231628,"responseStart":187.10000014305115,"secureConnectionStart":155},{"duration":38,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":155.10000014305115,"connectEnd":155.10000014305115,"connectStart":155.10000014305115,"domainLookupEnd":155.10000014305115,"domainLookupStart":155.10000014305115,"fetchStart":155.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":169.70000004768372,"responseEnd":193.10000014305115,"responseStart":191.40000009536743,"secureConnectionStart":155.10000014305115},{"duration":14.200000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":155.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":169.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":14.600000143051147,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":155.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":169.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":72.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":155.29999995231628,"connectEnd":155.29999995231628,"connectStart":155.29999995231628,"domainLookupEnd":155.29999995231628,"domainLookupStart":155.29999995231628,"fetchStart":155.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":172.5,"responseEnd":227.70000004768372,"responseStart":224.40000009536743,"secureConnectionStart":155.29999995231628},{"duration":45.700000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":155.5,"connectEnd":155.5,"connectStart":155.5,"domainLookupEnd":155.5,"domainLookupStart":155.5,"fetchStart":155.5,"redirectEnd":0,"redirectStart":0,"requestStart":174.10000014305115,"responseEnd":201.20000004768372,"responseStart":195.79999995231628,"secureConnectionStart":155.5},{"duration":282.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":160.60000014305115,"connectEnd":160.60000014305115,"connectStart":160.60000014305115,"domainLookupEnd":160.60000014305115,"domainLookupStart":160.60000014305115,"fetchStart":160.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":208.5,"responseEnd":443.40000009536743,"responseStart":437.10000014305115,"secureConnectionStart":160.60000014305115},{"duration":278.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":165.10000014305115,"connectEnd":165.10000014305115,"connectStart":165.10000014305115,"domainLookupEnd":165.10000014305115,"domainLookupStart":165.10000014305115,"fetchStart":165.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":228.20000004768372,"responseEnd":443.90000009536743,"responseStart":438.5,"secureConnectionStart":165.10000014305115},{"duration":69,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":492.7000000476837,"connectEnd":492.7000000476837,"connectStart":492.7000000476837,"domainLookupEnd":492.7000000476837,"domainLookupStart":492.7000000476837,"fetchStart":492.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":531,"responseEnd":561.7000000476837,"responseStart":560.6000001430511,"secureConnectionStart":492.7000000476837},{"duration":120.89999985694885,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":721.6000001430511,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":721.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":842.5,"responseStart":0,"secureConnectionStart":0},{"duration":149.89999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":728.1000001430511,"connectEnd":728.1000001430511,"connectStart":728.1000001430511,"domainLookupEnd":728.1000001430511,"domainLookupStart":728.1000001430511,"fetchStart":728.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":846.2999999523163,"responseEnd":878,"responseStart":876.5,"secureConnectionStart":728.1000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":14,"responseStart":146,"responseEnd":165,"domLoading":149,"domInteractive":881,"domContentLoadedEventStart":881,"domContentLoadedEventEnd":919,"domComplete":1449,"loadEventStart":1449,"loadEventEnd":1450,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":861.4000000953674},{"name":"bigPipe.sidebar-id.end","time":862.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":862.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":863.5},{"name":"activityTabFullyLoaded","time":934.2000000476837}],"measures":[],"correlationId":"d1a4d7d8d9f475","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":72,"dbReadsTimeInMs":9,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
I made a terrible mistake, it's don't work on 10.0.14-galera too just fusked my history server