Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.0.13-galera, 10.0.14-galera
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)
Attachments
Issue Links
- relates to
-
MDEV-9037 DML statements on a Galera Cluster node with sql_log_bin=OFF still appears in binary log on _other_ nodes
- Closed
-
MDEV-20087 Galera + SET SQL_LOG_BIN=0 on binlog on others nodes
- Closed