Categories
Products
Technologies
Top Rated docs

April 13, 2022

What is MariaDB Enterprise and How to Manage it with ClusterControl?

Have you ever wondered what products MariaDB Enterprise has to offer? Is it different from MariaDB Community? Can I manage them with ClusterControl? MariaDB provides two distributions of their software — Enterprise and Community. The...

June 7, 2021

PostgreSQL Replication Best Practices – Part 1

Using replication for your PostgreSQL databases could be useful not only to have a high availability and fault tolerant environment but also to improve the performance on your system by balancing the traffic between the...

December 1, 2020

An Overview of ProxySQL Clustering in ClusterControl

ProxySQL is a well known load balancer in MySQL world - it comes with a great set of features that allow you to take control over your traffic and shape it however you see it...

October 26, 2020

Tips for Migrating from HAProxy to ProxySQL

ProxySQL is a dedicated load balancer for MySQL which comes with a variety of features including, but not limited to query redirecting, query caching or traffic shaping. It can be used to easily set up...

October 21, 2020

Migrating from Maxscale to the ProxySQL Load Balancer

A database load balancer, or proxy, is a middleware service between application layer and database layer. Application connects to the database proxy, and the proxy forwards the connection to the database. There are some benefits...

October 9, 2020

An Overview of PostgreSQL Query Caching & Load Balancing

The topic of caching appeared in PostgreSQL as far back as 22 years ago, and at that time the focus was on database reliability. Fast forward to 2020, the disk platters are hidden even deeper...

October 1, 2020

Comparing load balancers for PostgreSQL

Load balancing increases system performance, especially from the application standpoint, allowing several computers to serve the same data. It works such that the load is being distributed among client queries to replica nodes aside from...

September 30, 2020

Scaling PostgreSQL Using Connection Poolers & Load Balancers

Scalability is the property of a system to handle a growing amount of demands by adding resources. The reasons for this amount of demands could be temporary, for example, if you are launching a discount...

September 24, 2020

Understanding the HAProxy Statistics for MySQL & PostgreSQL

Having a Load Balancer is always a good option to improve your database environment. It can help you on redirect applications to available database nodes, distribute the traffic across multiple servers to improve performance, or...

September 23, 2020

MaxScale Basic Management Using MaxCtrl for MariaDB Cluster – Part Two

In the previous blog post, we have covered 4 basic management components using the MaxCtrl command-line client. In this blog post, we are going to cover the remaining part of the MaxScale components which are...

September 22, 2020

How Load Balancing Works with DBaaS Setups

Database as a Service (DBaaS) takes away the pain of operating a database. So as a user, when you decide to use a DBaas from a cloud service provider, you would only know the database...

September 21, 2020

Connection Handling & Throttling with ProxySQL

The ability to shape the traffic that goes to the database is one of the most important ones. In the past days you had not that much control over it - applications sent the traffic...

Subscribe below to be notified of fresh posts