15.
www.percona.com
To remember
● Disable selinux
● wsrep_cluster_address now supports multiple
entries, wsrep_urls in [mysqld_safe] is
deprecated
● SST method is defined in my.cnf
● when wsrep_node_address is used we can omit
wsrep_sst_receive_address,
wsrep_node_incoming_address and ist.
recv_addr

16.
www.percona.com
Let's have a look...
● Check MySQL error log, what do we see?
● Check variables and status related to PXC
○ SHOW GLOBAL VARIABLES LIKE
'wsrep%';
○ SHOW GLOBAL STATUS LIKE 'wsrep%';
● Play with the cluster (follow instructor)

21.
www.percona.com
To remember
● SST methods are not all the same.
● You can specify a donor per node
● Xtrabackup doesn't freeze the donor for the complete
SST period
● Xtrabackup requires authentication parameter

29.
www.percona.com
To remember
● 3 nodes is the minimum recommended !
● odd numbers of nodes are always better
● you can use a "fake" node (garbd) even to replicate
through it !

30.
www.percona.com
Incremental State Transfer
(IST)
● Used to avoid full SST (using gcache)
● gcache.size can be specified using
wsrep_provider_options
● Now works even after a crash if the state
is consistent

31.
www.percona.com
Incremental State Transfer
(IST)
● Used to avoid full SST (using gcache)
● gcache.size can be specified using
wsrep_provider_options
● Now works even after a crash if the state
is consistent
stop mysql on node3, run pluk.py on
node2, restart node3

32.
www.percona.com
Production Migration
● Backup the production server and restore
the production on node2
● Run pluk.py on node1

33.
www.percona.com
Production Migration (2)
● Start node3
● Run pluk.py on node1
● Start the async replication of node1 to
node2
● What about node3 ?
● Run pluk.py on node1

35.
www.percona.com
Production Migration (3)
● Configure pluk.py to connect to the
loadbalancer
● Run pluk.py
● Scratch data on node1 and install PXC
● Configure PXC on node1
● Start the cluster on node1 (SST should be
done with node3)
● Run pluk.py and check data on all
nodes