First steps with CC, creating an empty Percona CLuster
We just installed CC and manage to get 6 VM running Centos.
We need to get to know CC previous to use it in prod.
We have a replica Slave on MariaDB on SUSE.
We manage to create a cluster and deploy 2 VM with PXC
How can I get the data from MariaDB on SUSE.
Should I install a standalone Percona 5.7 on Centos VM as Slave of MariaDB on Suse?
Horacio, sorry to say this but can you please take your question one at a time? I am really confuse a bit here as it seems you're mixing the question on different environment.
IIRC, you guys have the following:
- 1 CC node with 6 VM running CentOS
- Another CC node (previous) with 2 VM with PXC
- You have a replica slave on MariaDB running on Suse env
Now your question is how to get data from MariaDB on Suse?
It's confusing though. Maybe you can take it one at a time and draw the picture clearly. It would be nice you can clarify the situation.
Thank you for clarifying it.
Let me ask you the following:
- What version of MariaDB running on SUSE do you have?
- How large are your dataset?
If version < 10.2, you can use Percona Xtrabackup considering that your data is huge. Since this is a slave, I suppose this is fine to run Xtrabackup on this node but make sure the traffic is low at that moment. If version is > 10.2, then you should use Mariabackup. Using binary backup makes faster provisioning of your new cluster to be managed by ClusterControl. Once you have the binary backup, then instantiate it to one of your cluster nodes running on PXC and let the other nodes SST from that node.
You can start checking https://www.percona.com/doc/percona-xtrabackup/2.4/howtos/recipes_ibkx_local.html
Using CC to handle the installation is pretty simple and straightforward though. You just have to click Deploy and then setup the keys, then add the nodes. Just make sure you have click "Install Software" or is enabled so it will install the package you want to install. Afterwards, select the version of Percona Server and then add the nodes hostname/IP.
Hi Paul, this is our plan.
I need to provision data from Slave on Maria DB on SUSE at Datacenter 2 to Stand Alone Percona 5.7 on Centos already in CC. Our goal is that Percona 5.7 Node acts as Slave of Datacenter 1(SUSE) and Master of Galera Cluster.
What are the steps to accomplish that? Percona XtraBackup on SUSE didn't work.
We select a small DB from Production, less than 20Gb and replicated to VM on a test environment, unfortunately, this was don on MariaDB on SUSE.
Our final objective is to get to know PXC and CC, and implement an HA cluster.
Unfortunately, we do not support ClusterControl running on SUSE. With regards to Percona Xtrabackup, I am not sure if it does support SUSE, but AFAIK, it does not, but of course you can run this at your will on any Linux flavor.
Maybe run on Ubuntu or RHEL/CentOS platforms?
Please sign in to leave a comment.