pghoard Alternatives – PostgreSQL Backup Management with ClusterControl
Managing backups could be a complex and risky task to do in a manual way. You must know that the backup is working according to your backup policy as you don’t want to be in...
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...
Amazon RDS for PostgreSQL Alternatives – ClusterControl for PostgreSQL
Amazon RDS for PostgreSQL is a managed service for PostgreSQL available as part of Amazon Web Services. It comes with a handful of management functions that are intended to reduce the workload of managing the...
PostgreSQL Load Balancing in the Cloud Made Easy
We’d mentioned many times the advantages of using a Load Balancer in your database topology. It could be for redirecting traffic to healthy database nodes, distribute the traffic across multiple servers to improve performance, or...
Announcing ClusterControl 1.7.6: HA Stack Deployments in the Cloud with HAProxy
We’re excited to announce the 1.7.6 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. This new edition expands our commitment to cloud...
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...
Implementing a Multi-Datacenter Setup for PostgreSQL – Part One
Having a multi-datacenter setup is a common topology for a Disaster Recovery Plan(DRP), but there are some limitations around implementing this kind of environment. You should first solve the communication between the data centers by...
Database Load Balancing on Google Cloud Platform (GCP) Using HAProxy
Using a Load Balancer is a good idea for any database technology, as you can redirect applications to the available or healthy database nodes and even distribute the traffic across multiple servers to improve performance....
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...
Migrating PostgreSQL to the Cloud – Comparing Solutions from Amazon, Google & Microsoft
From a bird’s eye view, it would appear that when it comes to migrating the PostgreSQL workloads into the cloud, the choice of cloud provider should make no difference. Out of the box, PostgreSQL makes...
Cloud Vendor Deep-Dive: PostgreSQL on DigitalOcean
DigitalOcean is a cloud service provider, more of an IaaS (Infrastructure-as-a-Service) provider which is more suitable for small to medium scale businesses. You can get to know more about DigitalOcean here. What it does is...
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...