How to Avoid PostgreSQL Cloud Vendor Lock-in
Vendor lock-in is a well-known concept for database technologies. With cloud usage increasing, this lock-in has also expanded to include cloud providers. We can define vendor lock-in as a proprietary lock-in that makes a customer...
Failover & Failback on Amazon RDS
Previously we posted a blog discussing Achieving MySQL Failover & Failback on Google Cloud Platform (GCP) and in this blog we'll look at how it’s rival, Amazon Relational Database Service (RDS), handles failover. We will...
Comparing Failover Times for Amazon Aurora, Amazon RDS, and ClusterControl
If your IT infrastructure is running on AWS, you have probably heard about Amazon Relational Database Service (RDS), an easy way to set up, operate, and scale a relational database in the cloud. It provides...
Database Load Balancing with ProxySQL & AWS Aurora
ProxySQL is a proven solution that helps database administrators dealing with the requirements for high availability of their databases. Because it is SQL-aware, it can also be used for shaping the traffic heading towards databases...
Cloud Vendor Deep-Dive: PostgreSQL on AWS Aurora
How deep should we go with this? I’ll start by saying that as of this writing, I could locate only 3 books on Amazon about PostgreSQL in the cloud, and 117 discussions on PostgreSQL mailing...
Benchmarking Managed PostgreSQL Cloud Solutions – Part One: Amazon Aurora
This blog starts a multi-series documenting my journey on benchmarking PostgreSQL in the cloud. The first part includes an overview of benchmarking tools, and kickstarts the fun with Amazon Aurora PostgreSQL. Selecting the PostgreSQL Cloud...
An Overview of Amazon RDS & Aurora Offerings for PostgreSQL
AWS PostgreSQL services fall under the RDS umbrella, which is Amazon’s DaaS offering for all known database engines. Managed database services offer certain advantages that are appealing to the customer seeking independence from infrastructure maintenance,...