Business Solutions

PostgreSQL Updatable Views: Performing Schema Updates With Minimal Downtime

postgres updatable views

Recently, one of our customers asked us how to minimize downtime when upgrading the database structure with changes that are not backwards-compatible. It’s an interesting question and I would like to visit some alternatives here. I will use PostgreSQL for this series of posts and walk through updatable views, INSTEAD OF Triggers, and the […]

Read more

Amazon RDS Aurora Serverless – The Basics

amazon aurora serverless

When I attended AWS Re:Invent 2018, I saw there was a lot of attention from both customers and the AWS team on Amazon RDS Aurora Serverless. So I decided to take a deeper look at this technology, and write a series of blog posts on this topic.
In this first post of the series, you will learn […]

Read more

How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse

MySQL High Availability 2

Let’s talk about MySQL high availability (HA) and synchronous replication once more.
It’s part of a longer series on some high availability reference architecture solutions over geographically distributed areas.
Part 1: Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?
Part 2: MySQL High Availability On-Premises: A Geographically Distributed Scenario
The Problem
A question I often […]

Read more

MySQL High Availability On-Premises: A Geographically Distributed Scenario

On-Premises MySQL High Availability

MySQL High Availability. Shutterstock.com
In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution. It’s part of a longer series on some high availability reference architecture solutions over geographically distributed areas.
Part 1: Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?
Percona consulting’s main aim is […]

Read more

Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?

High Availability Solutions

High Availability Solutions. Shutterstock.com
In this series of blog posts, I’m going to look at some high availability reference architecture solutions over geographically distributed areas.
The Problem
Nowadays, when businesses plan a new service or application, it is very common for them to worry about ensuring a very high level of availability. 
It doesn’t matter if we […]

Read more