In this blog, we cover tprovision. tprovision is a complete rewrite of the provisioning tool “tungsten_provision_slave,” included with Tungsten Cluster. It is streamlined and allows easy provisioning of replica databases.
Deploying Composite Active/Active clusters gives end-users the best experience no matter where they are located. Tungsten Cluster makes this possible with the deployment of MySQL clusters at geo-scale, allowing the enterprise to host clusters close to the users. How can we avoid write-conflicts with asynchronous replication and multiple primary databases?
So we’ve established how important backups are, RTO, RPO, and how you can be a hero by having backups that align with business objectives. We just need to pick a good backup tool(s) to take backups of your MySQL database. Databases evolve, grow, and business needs change. That’s why it is important to constantly reevaluate your backup strategy, because what worked last year may not be appropriate this year in terms of RPO/RTO, retention, or costs.
Galera Cluster provides high availability and scalability for MySQL. While this provides high availability in a local region or site, it does not provide any provisions for disaster recovery (DR) or any multi-site deployment in general, so let’s explore how we could extend the functionality of Galera Cluster to deploy at geo-scale.