Recently a Continuent Customer Asked: Part 2

The Question

“Can I provision a Replica from a Primary node using the tprovision command? In the documentation it only shows a Replica node being provisioned from another Replica node.”

The Answer

You can definitely provision a Replica node from a Primary node, but with the following caveat - there is the possibility of downtime or poor performance during the backup of the primary due to locked tables and general overhead (CPU, disk and network), especially when using the mysqldump backup method (as opposed to xtrabackup).

We therefore urge you to use a Replica node as a source whenever possible.

The documentation for the provision command is located here:

https://docs.continuent.com/tungsten-clustering-7.0/cmdline-tools-tprovision.html

and the sections on Backup and Restore are here:

https://docs.continuent.com/tungsten-clustering-7.0/operations-backup.html

https://docs.continuent.com/tungsten-clustering-7.0/operations-restore.html

Wrap-Up

In this post we explored why it is always best to use a Replica node, not the Primary node, as the source for provisioning another Replica node.

Smooth sailing!