Online Migration from MySQL 5.6 Non-GTID to MySQL 5.7 with GTID
In this blog post, we are going to look into how to perform online migration from MySQL 5.6 standalone setup to a new replication set running on MySQL 5.7, deployed and managed by ClusterControl. The...
Multi-Cloud Deployment for MySQL Replication
In recent years, the use of platform infrastructure has shifted from on-premise to cloud computing. This is based on the absence of cost capital costs that must be incurred by the company if used when...
Database Backups in the Cloud for Disaster Recovery
Multi-cloud deployments of open source databases require considerations such as high availability, scalability, resiliency, backups, and disaster recovery. In this blog, we will emphasize the importance of database backups in the cloud which provide you...
Multi-Cloud Full Database Cluster Failover Options for PostgreSQL
Failover is the ability of a system to continue working even if some failure occurs. It suggests that the functions of the system are assumed by secondary components if the primary components fail or if...
How to Reduce Replication Lag in Multi-Cloud Deployments
Replication lag is an inevitable occurrence for multi-cloud database deployments, as it causes delays of transactions to reflect into the target node or cluster. When implementing a multi-cloud database deployment, the most common scenario (and...
Eliminating PostgreSQL Split-Brain in Multi-Cloud Databases
Using a multi-cloud or multi-datacenter environment is useful for geo-distributed topologies or even for a disaster recovery plan, and actually, it is becoming more popular nowadays, therefore the concept of split-brain is also becoming more...
MariaDB Cluster Offline Installation for CentOS
Most of the installation steps available on the Internet cover the standard online installation, presuming the database hosts are having an active internet connection to the package repositories and satisfy all dependencies. However, installation steps...
Eliminating MySQL Split-Brain in Multi-Cloud Databases
These days databases spanning across multiple clouds are quite common. They promise high availability and possibility to easily implement disaster recovery procedures. They are also a method to avoid vendor lock-in: if you design your...
A Guide to Database Backup Archiving in the Cloud
Having a backup plan is a must when running a database in production. Running a backup every day, however, can eventually lead to an excess of backup storage space, especially when running on premises. One...
Multi-Cloud Full Database Cluster Failover Options for MariaDB Cluster
High availability is paramount in today's business reality. But every service provider comes with an inherited risk of disruption -- and cloud service providers are no different. If they go down, even temporarily, then so...
PostgreSQL Multi-Cloud Cluster Deployment
A multi-cloud environment is a good option for a Disaster Recovery Plan (DRP), but it can be a time-consuming task as you need to configure the connectivity between the different cloud providers and you will...
What is a Multi-Cloud Database?
During the recent 24-hour Percona Live, multi-cloud was regularly one of the key topics. This is just another key indicator of the trend of many organizations who are switching their architectures or expanding their businesses...