MariaDB MaxScale Load Balancing on Docker: Management: Part Two
This blog post is a continuation of MariaDB MaxScale Load Balancing on Docker: Deployment - Part1. In this part, we are going to focus more on management operations with advanced use cases like service control,...
Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL
HAProxy and ProxySQL are both very popular load balancers in MySQL world, but there is a significant difference between both those proxies. We will not go into details here, you can read more about HAProxy...
Master High Availability Manager (MHA) Has Crashed! What Do I Do Now?
MySQL Replication is very popular way of building highly available database layers. It is very well known, tested and robust. It is not without limitations, though. One of them, definitely, is the fact that it...
Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions
High availability is a high percentage of time that the system is working and responding according to the business needs. For production database systems it is typically the highest priority to keep it close to...
PostgreSQL High Availability with Master-Slave & Master-Master Architectures
Below is an excerpt from our whitepaper “PostgreSQL Management and Automation with ClusterControl” which can be downloaded for free. Revision Note: Keep in mind that the terms used in this blog Master-Slave are synonymous of Master-Standby...
How to Monitor HAProxy Metrics with ClusterControl
Load balancers are an essential component of any highly available database setup. They’re used to increase the capacity and reliability of your critical systems and applications by preventing any one server from becoming overloaded. We...
How to Cluster Your ProxySQL Load Balancers
A proxy layer between applications and databases would typically consist of multiple proxy nodes for high availability. This is no different for ProxySQL. ProxySQL, just like other modern proxies, can be used to build complex...
How to Deploy PostgreSQL for High Availability
Introduction Nowadays, high availability is a requirement for many systems, no matter what technology you’re using. This is especially important for databases, as they store data that critical applications and systems rely on. The most...
A Guide to PGpool – Hints & Observations: Part Three
In the previous part I dared to play with a not implemented feature fantasising how would it work. Well HA in first place is a matter of design and only then implementation. It does not...
Webinar Replay: How to Measure Database Availability
Watch the replay of Part 2 of our database high availability webinar special! Thanks to to everyone who participated in this week’s webinar on how to measure database availability. The replay and slides are now...
A Guide to Pgpool for PostgreSQL: Part One
Pgpool is less actual today, than it used to be 10 years ago, when it was the default part of a production PostgreSQL set up. Often when somebody was talking about PostgreSQL cluster, they were...
A Guide to Using pgBouncer for PostgreSQL
When reading PostgreSQL getting started, you see the line: “The PostgreSQL server can handle multiple concurrent connections from clients. To achieve this, it starts (“forks”) a new process for each connection. From that point on,...