Not the answer you need?
Register and ask your own question!

Incremental option for wsrep_sst_method

mandmmandm ContributorInactive User Role Beginner
Hi
Currently i am using this configuration for setting up a cluster on node1

node 1
binlog_format=ROW
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=gcomm://
wsrep_slave_threads=2
wsrep_cluster_name=dev_cluster
wsrep_sst_method=rsync
wsrep_node_name=node1
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
wsrep_replicate_myisam=1

node2
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=[URL]gcomm://10.1.0.1:4567[/URL]
wsrep_slave_threads=2
wsrep_sst_method=rsync
wsrep_cluster_name=dev_cluster
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
wsrep_replicate_myisam=1

and what i understand is in case node 2 goes down and comes backup, it will perform a full rsync from node1 /var/lib/mysql directory in order to get unto date with the data and depemding on the size of data it can take much longer for big db's
so here are my questions
1) how do i configure this to only patch all the incremental updates from node1?
2) how does node 1 know where to store all the increments for node2 to patchup once it is up?
3) How does this scenario work when node2 is up and node1 goes down and comes back up?

Thanks once again...
i am using
Server version: 5.5.24-55-log Percona XtraDB Cluster (GPL), wsrep_23.6.r341
on ubuntu 10.04

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.