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

Installing Percona XtraDB Cluster on Ubuntu 16.04

Dirk23Dirk23 EntrantInactive User Role Beginner
Hi,

since some says now i try to start a Percona XtraDB Cluster on Ubuntu 16.04. I started with these instructions: https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html 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

Comments

  • krunalbauskarkrunalbauskar Advisor Inactive User Role Novice
    Can you share the error/mysqld.log for node-2.
    How big is your DB. Wondeing if SST is taking time.
  • Dirk23Dirk23 Entrant Inactive User Role Beginner
    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.
  • krunalbauskarkrunalbauskar Advisor Inactive User Role Novice
    No probs. Good to hear you have working cluster. Enjoy PXC.
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.