[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

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');

SET sql_log_bin = OFF;

delete from test where id =1;