Comment 3 for bug 1251137

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: Galera Replication between 5.6 and 5.5 fails

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

innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2

[client]
user=root
password=test

========================================================================================

As you can see I had binlogging enabled earlier on nodes but disabled it, even then it fails.