Details
Blocker
Description
my servers:
https://farm8.staticflickr.com/7544/15874745401_d3975432f6_b.jpg
configuration on each node : (except server-id ofc)
[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');
After on each node (1 at once)
SET sql_log_bin = OFF; delete from test where id =1;
successfull on the node where it's executed and the DELETE is not applied on other node of cluster ....
The problem here the cluster is desynchronized.
My goal, got a cluster and a server of history behind. (where delete not executed on slave)
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Aurélien LEQUOY While I have pushed the fix for this bug to 10.1, I skipped
5.5-galera and 10.0-galera as the patch modifies some critical areas that seem
quite risky for GA versions.
I can later backport the fix to GA versions if it causes no side effects.
Nirbhay Choubey can this implemented behaviour be documented at least on the binary logging system variables page
thx, I will check if it's work fine in 10.1
Daniel Black Added a note under 'sql_log_bin' :
https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-variables/#sql_log_bin
Thanks!
Thanks Nirbhay Choubey.
your goal can probably be achieved with set session wsrep_on=off