How to set up Log Shipping as HA or DR solution for SQL Server on Linux
Log Shipping is a convenient disaster recovery method without complex infrastructure requirements. Log shipping allows you to sync a warm standby replica of your database with the Primary instance. It is available in the Enterprise,...
Disaster Recovery for Galera Cluster Deployed to a Hybrid Cloud
Running a Galera Cluster in a hybrid cloud should consist of at least two different geographical sites, connecting hosts in the on-premises or private cloud with the ones in the public cloud. Whether you use...
Disaster Recovery Options for PostgreSQL Deployed to a Hybrid Cloud
In our previous Hybrid Cloud blogs, we often mention that one of the primary options of availing the Hybrid Cloud topology setup is to use this as your disaster recovery target. It's common for an...
How do Hybrid Clouds Improve Reliability?
Hybrid cloud is a combination of public and private cloud systems, that are distinct and established in separate locations, each with their own data centers and specifications. They interact through an encrypted connection which allows...
How Disaster Recovery is Different in a Hybrid Cloud
Disaster recovery has many means and can be implemented in many ways. The one thing to keep in mind is that when you are designing a production environment, you should always consider how you are...
Using Barman for PostgreSQL Disaster Recovery
There must be many powerful tools available as a backup and restore option for PostgreSQL in general; Barman, PgBackRest, BART are to name a few in this context. What caught our attention was that Barman...
Video: Database Disaster Recovery with ClusterControl
This past week we debuted a series of videos on database disaster recovery. From basic backup and restore, to switchover & failover, to full cluster-to-cluster replication, these videos show how ClusterControl offers you end-to-end protection...
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 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...
pg_restore Alternatives – PostgreSQL Backup and Automatic Recovery with ClusterControl
While there are various ways to recover your PostgreSQL database, one of the most convenient approaches to restore your data from a logical backup. Logical backups play a significant role for Disaster and Recovery Planning...
Comparing Amazon RDS Point-in-Time Recovery to ClusterControl
The Amazon Relational Database Service (AWS RDS) is a fully-managed database service which can support multiple database engines. Among those supported are PostgreSQL, MySQL, and MariaDB. ClusterControl, on the other hand, is a database management...