My DBA is Sick – Disaster Planning & Backup Tips for SysAdmins
The alarming nature of COVID-19 is being felt globally. Many companies have closed or filed bankruptcy because of the global pandemic. Most organizations did not see this coming. Large companies have a better chance of...
Implementing a Multi-Datacenter Setup for PostgreSQL – Part Two
This blog is the second part of Implementing a Multi-Datacenter Setup for PostgreSQL. In this blow, we will show how to deploy PostgreSQL in this type of environment and how to failover in the case...
Multi-DC PostgreSQL: Setting Up a Standby Node at a Different Geo-Location Over a VPN
Previously, we wrote about Setting Up a Geo-Distributed Database Cluster Using MySQL Replication. This time, it's about PostgreSQL. Setting up a geo-distributed cluster for PostgreSQL is not a new concept and the topology is quite...
Setting Up a Geo-Distributed Database Cluster Using MySQL Replication
A single point of failure (SPOF) is a common reason why organizations are working towards distributing the presence of their database environments to another location geographically. It's part of the Disaster Recovery and Business Continuity...
Using MariaDB Flashback on a MySQL Server
MariaDB has introduced a very cool feature called Flashback. Flashback is a feature that will allow instances, databases or tables to be rolled back to an old snapshot. Traditionally, to perform a point-in-time recovery (PITR),...
Steps to Take if You Have a MySQL Outage
A MySQL outage simply means your MySQL service is not accessible or unresponsive from the other's perspective. Outages can be originated by a bunch of possible causes.. Network issue - Connectivity issue, switch, routing, resolver,...
Managing Database Backup Retention Schedules
Attention: Skip reading this blog post if you can afford unlimited storage space. If you could afford unlimited storage space, you wouldn't have to worry about backup retention at all, since you could store your...
Why Did My MySQL Database Crash? Get Insights with the New MySQL Freeze Frame
In case you haven't seen it, we just released ClusterControl 1.7.5 with major improvements and new useful features. Some of the features include Cluster Wide Maintenance, support for version CentOS 8 and Debian 10, PostgreSQL...
Creating a Cold Standby for PostgreSQL Using Amazon AWS
The need to achieve database High Availability is a pretty common task, and often a must. If your company has a limited budget, then maintaining a replication slave (or more than one) that is running...
How to Configure Cluster-to-Cluster Replication for PostgreSQL
As we recently announced, ClusterControl 1.7.4 has a new feature called Cluster-to-Cluster Replication. It allows you to have a replication running between two autonomous clusters. For more detailed information please refer to the above mentioned...
How to Configure a Cluster-to-Cluster Replication for Percona XtraDB Cluster or MariaDB Cluster
In a previous blog, we announced a new ClusterControl 1.7.4 feature called Cluster-to-Cluster Replication. It automates the entire process of setting up a DR cluster off your primary cluster, with replication in between. For more...
An Overview of Cluster-to-Cluster Replication
Nowadays, it’s pretty common to have a database replicated in another server/datacenter, and it’s also a must in some cases. There are different reasons to replicate your databases to a totally separate environment. Migrate to...