5.6 config: ========================================================================== [mysqld] datadir=/var/lib/mysql
#log_slave_updates
server-id=341 #log_bin = /var/lib/mysql/mysql-bin.log
binlog_format = ROW innodb_buffer_pool_size = 100M innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 512M innodb_file_per_table = 1 wsrep-node-address=10.0.2.153
wsrep_cluster_address='gcomm://Pxc1,Pxc2' wsrep_provider=/usr/lib64/libgalera_smm.so wsrep_provider_options = "socket.checksum = 1"
wsrep_slave_threads=2 wsrep_cluster_name=PXC wsrep_sst_method=xtrabackup-v2 wsrep_node_name=Pxc1
innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2
[client] user=root password=test
5.5 config: ============================================================ [mysqld] datadir=/var/lib/mysql
server-id=248
binlog_format = ROW thread_stack = 256K thread_cache_size = 512 tmp_table_size = 32M max_heap_table_size = 32M max_connections = 10000 open-files-limit = 65535 table_open_cache = 8192 table_definition_cache = 8192 key_buffer_size = 64M innodb_buffer_pool_size = 500M innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 512M innodb_file_per_table = 1 wsrep-node-address=10.0.2.154
loose-query_response_time_stats
wsrep_cluster_address='gcomm://Pxc1,Pxc2' wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_slave_threads=2 wsrep_cluster_name=PXC wsrep_sst_method=xtrabackup-v2 wsrep_node_name=Pxc2
========================================================================================
As you can see I had binlogging enabled earlier on nodes but disabled it, even then it fails.
5.6 config: ======= ======= ======= ======= ======= ======= ======= ======= ======= ==== /var/lib/ mysql
=======
[mysqld]
datadir=
#log_slave_updates
server-id=341 mysql/mysql- bin.log
#log_bin = /var/lib/
binlog_format = ROW buffer_ pool_size = 100M flush_log_ at_trx_ commit = 2 log_files_ in_group = 2 log_file_ size = 512M file_per_ table = 1 address= 10.0.2. 153
innodb_
innodb_
innodb_flush_method = O_DIRECT
innodb_
innodb_
innodb_
wsrep-node-
wsrep_cluster_ address= 'gcomm: //Pxc1, Pxc2' /usr/lib64/ libgalera_ smm.so options = "socket.checksum = 1"
wsrep_provider=
wsrep_provider_
wsrep_slave_ threads= 2 name=PXC method= xtrabackup- v2 name=Pxc1
wsrep_cluster_
wsrep_sst_
wsrep_node_
innodb_ locks_unsafe_ for_binlog= 1 autoinc_ lock_mode= 2
innodb_
[client]
user=root
password=test
5.5 config: ======= ======= ======= ======= ======= ======= ======= ==== /var/lib/ mysql
=======
[mysqld]
datadir=
server-id=248
binlog_format = ROW n_cache = 8192 buffer_ pool_size = 500M flush_log_ at_trx_ commit = 2 log_files_ in_group = 2 log_file_ size = 512M file_per_ table = 1 address= 10.0.2. 154
thread_stack = 256K
thread_cache_size = 512
tmp_table_size = 32M
max_heap_table_size = 32M
max_connections = 10000
open-files-limit = 65535
table_open_cache = 8192
table_definitio
key_buffer_size = 64M
innodb_
innodb_
innodb_flush_method = O_DIRECT
innodb_
innodb_
innodb_
wsrep-node-
loose-query_ response_ time_stats
wsrep_cluster_ address= 'gcomm: //Pxc1, Pxc2' /usr/lib64/ libgalera_ smm.so
wsrep_provider=
wsrep_slave_ threads= 2 name=PXC method= xtrabackup- v2 name=Pxc2
wsrep_cluster_
wsrep_sst_
wsrep_node_
innodb_ locks_unsafe_ for_binlog= 1 autoinc_ lock_mode= 2
innodb_
[client]
user=root
password=test
======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ====
As you can see I had binlogging enabled earlier on nodes but disabled it, even then it fails.