Comment 2 for bug 1455098

Hi, Alex.

binlog_format = ROW for all.

mysql> show variables like 'binlog_format';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW |
+---------------+-------+
1 row in set (0,00 sec)

/etc/my.cnf:

[mysqld_safe]

open-files-limit = 320000
malloc-lib=/usr/lib64/libjemalloc.so.1

[mysqld]

ssl-ca = /etc/mysql/ssl/mysql/ca-cert.pem
ssl-cert = /etc/mysql/ssl/mysql/server-cert.pem
ssl-key = /etc/mysql/ssl/mysql/server-key.pem

skip-name-resolve
event_scheduler = On

server-id = 10

user = mysql
bind-address = 10.10.91.2
port = 3306
max_connections = 2048
max_allowed_packet = 1G

datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
tmpdir = /tmp/mysql

symbolic-links = 0

table_open_cache = 32768
table_definition_cache = 16784
table_open_cache_instances = 16

thread_cache_size = 256

default_storage_engine = InnoDB
explicit_defaults_for_timestamp = On
ft_min_word_len = 3

large-pages

sort_buffer_size = 3M
join_buffer_size = 3M
read_rnd_buffer_size = 3M
read_buffer_size = 2M

max_heap_table_size = 512M
tmp_table_size = 512M

# innodb

innodb_buffer_pool_size = 64G
innodb_buffer_pool_instances = 16

innodb_log_file_size = 8G
innodb_log_buffer_size = 16M
innodb_log_block_size = 4096
innodb_log_group_home_dir = /var/lib/mysql_logs/innodb
innodb_data_file_path = /ibdata1:64M:autoextend
innodb_data_home_dir = /var/lib/mysql_logs/innodb

innodb_open_files = 8192
innodb_file_per_table = 1
innodb_rollback_on_timeout = On
innodb_flush_log_at_trx_commit = 0
innodb_doublewrite = 1
innodb_flush_method = O_DIRECT
innodb_lock_wait_timeout = 300
innodb_flush_neighbors = 0

innodb_sort_buffer_size = 16M

innodb_io_capacity = 60000
innodb_io_capacity_max = 70000

innodb_max_dirty_pages_pct = 90

innodb_write_io_threads = 24
innodb_read_io_threads = 24
innodb_purge_threads = 4
innodb_random_read_ahead = On

innodb_support_xa = 0

innodb_autoinc_lock_mode = 2 # Galera
innodb_locks_unsafe_for_binlog = 1 # Galera

innodb_buffer_pool_load_at_startup = On
innodb_buffer_pool_dump_at_shutdown = On

innodb_file_format = Barracuda

# MyISAM

key_buffer_size = 128M

# binlog \ relaylog

log-bin = /var/lib/mysql_logs/binary/binlog
max_binlog_size = 1024M
binlog_format = ROW
binlog_cache_size = 5M
max_binlog_files = 50
expire_logs_days = 0
sync_binlog = 0

master_info_repository = 'table'
relay_log_info_repository = 'table'

relay_log = /var/lib/mysql_logs/relay/relaylog
slave_load_tmpdir = /tmp/mysql

master_verify_checksum = On
slave_sql_verify_checksum = ON

relay_log_recovery = On

# logs

log_error = "/var/log/mysql/error.log"
slow_query_log_file = "/var/log/mysql/slow.log"

# galera

wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_provider_options="gcache.size = 1G; gcache.page_size = 1G; gcache.name = /var/lib/mysql_logs/galera/galera.cache; gcs.fc_limit = 20000; socket.ssl_cert = /etc/mysql/ssl/galera/cert.pem; socket.ssl_key = /etc/mysql/ssl/galera/key.pem"

wsrep_cluster_address=gcomm://10.10.91.2,10.10.91.3,10.10.91.4

wsrep_node_address="10.10.91.2"

wsrep_cluster_name="PXC"
wsrep_node_name="node1"

wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = sst_xtrabackup:*****

wsrep_forced_binlog_format = ROW

wsrep_retry_autocommit = 2
wsrep_slave_threads = 64
wsrep_convert_LOCK_to_trx = 1

wsrep_max_ws_size = 2147483648
wsrep_max_ws_rows = 1048576

wsrep_sync_wait = 0