Installing Percona XtraDB Cluster on Ubuntu 16.04

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

since some says now i try to start a Percona XtraDB Cluster on Ubuntu 16.04. I started with these instructions: [url]https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html[/url] but it seems they are partially outdated. Adding wsrep variables to /etc/mysql/my.cnf does not really work, i added these variables to /etc/mysql/percona-xtradb-cluster.conf.d/mysqld.cnf, maybe that is not correct?. So i ran through this instructions step by step and changed variables to my meet my environment. I could bootstrap the first node successfully, but when i start a second node, the wsrep_cluster_size wont rise to “2” and when i create a new database it is not synced to the 2nd node.

Can somebody please give me a hint, what i did wrong?

My Configs are

  1. Node:
    wsrep_provider=/usr/lib/libgalera_smm.so
    wsrep_cluster_name=DB-Cluster
    wsrep_cluster_address=gcomm://192.168.0.61,192.168.0.62,192.168.0.63
    wsrep_node_name=DB-1
    wsrep_node_address=192.168.0.61
    wsrep_sst_method=xtrabackup-v2
    wsrep_sst_auth=sstuser:S0meSecurePa$$w0rd!
    pxc_strict_mode=ENFORCING
    binlog_format=ROW
    default_storage_engine=InnoDB
    innodb_autoinc_lock_mode=2

  2. Node:
    wsrep_provider=/usr/lib/libgalera_smm.so
    wsrep_cluster_name=DB-Cluster
    wsrep_cluster_address=gcomm://192.168.0.61,192.168.0.62,192.168.0.63
    wsrep_node_name=DB-2
    wsrep_node_address=192.168.0.62
    wsrep_sst_method=xtrabackup-v2
    wsrep_sst_auth=sstuser:S0meSecurePa$$w0rd!
    pxc_strict_mode=ENFORCING
    binlog_format=ROW
    default_storage_engine=InnoDB
    innodb_autoinc_lock_mode=2

  3. Node:
    wsrep_provider=/usr/lib/libgalera_smm.so
    wsrep_cluster_name=DB-Cluster
    wsrep_cluster_address=gcomm://192.168.0.61,192.168.0.62,192.168.0.63
    wsrep_node_name=DB-3
    wsrep_node_address=192.168.0.63
    wsrep_sst_method=xtrabackup-v2
    wsrep_sst_auth=sstuser:S0meSecurePa$$w0rd!
    pxc_strict_mode=ENFORCING
    binlog_format=ROW
    default_storage_engine=InnoDB
    innodb_autoinc_lock_mode=2

Thanks!

Dirk

2

Can you share the error/mysqld.log for node-2.
How big is your DB. Wondeing if SST is taking time.

3

The problem was simple: i edited .cnf file in /etc/mysql/ but there is a predefined wsrep.cnf file for these wsrep variables in /etc/mysql/percona-xtradb-cluster.conf.d/ wich overrides everything i added to any other .cnf File. No wonder why the cluster wont come up, because of this config File! Now i have a working cluster.

Sorry for the delay here.

4

No probs. Good to hear you have working cluster. Enjoy PXC.