Testing Percona XtraDB Cluster 8.0 with DBdeployer

testing Percona XtraDB Cluster DBdeployerIn the light of support for Percona XtraDB Cluster (PXC), the DBdeployer anniversary, and the newly released Percona XtraDB Cluster 8.0, I’m happy to announce that Giuseppe Maxia has recently updated DBdeployer to support Percona XtraDB Cluster 8.0.

We at Percona, with my colleague Ramesh Sivaraman, have tested and deployed Percona XtraDB Cluster (PXC) 8.0.18  successfully using DBdeployer.

What is DBdeployer and How Do You Install it?

It’s an open source tool to test and deploy multiple MySQL topologies in a single host using different ports. It allows DBAs and developers to quickly launch and test certain functionalities, syntax, and features. It’s a critical tool to launch MySQL instances with minimum resources.

Here’s a quick rundown of DBdeployer:

DBdeployer use case with PXC-8.0

OS: Ubuntu Xenial

Note: Be sure to check your system and make sure that the packages are installed which Percona XtraDB Cluster 8.0 depends on.

Please select Linux Generic packages if you are downloading PXC from the web:

Configure a Single Node Percona XtraDB Cluster

The following command will help you to set up a single node cluster.

Before moving on to multi-node cluster, remove the single-node cluster.

Configure 3 Node Percona XtraDB Cluster

Testing and Verification

There are several pre-set scripts under this deployment. We can start with testing replication status for this cluster.

Also following $HOME/sandboxes/pxc_msb_pxc8_0_18/n[1-3] scripts will help to login to the respective PXC node.

You can also check the node status using the following command: