ALTER TABLE in MySQL: Friend or Foe?
The ALTER TABLE statement is one of the most frequently used statements in the MySQL world - the statement allows you to add, delete or modify columns in a table. In this blog post we...
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...
A Look at the Percona Toolkit
The Percona Toolkit (PT Toolkit) was initially designed as a swiss army knife for MySQL/MariaDB/Percona Server and its underlying operating system to perform advanced database and system administration tasks that are hard to perform especially...
Monitoring Percona XtraDB Cluster – Key Metrics
Percona XtraDB Cluster is a very well known high availability solution in MySQL world. It is based on Galera Cluster and it does provide virtually synchronous replication across multiple nodes. As with every database, it...
Using the Percona Audit Log Plugin for Database Security
Why Do You Need To Use an Audit Plugin For Your Database? Auditing in a database doesn't deviate from its meaning as it shares the same connotation i.e. to inspect, examine, and evaluate for such...
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...
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...
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...
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...
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...
A Guide to MySQL Indexes
When MySQL query optimization is mentioned, indexes are one of the first things that get covered. Today, we will try to see why they are so important. What are Indexes? In general, an index is...
Connection Handling & Throttling with HAProxy
HAProxy continues to evolve into a more powerful software for load balancing and proxying solutions. It's one of the most popular high availability solutions and can work as a proxy for Layer 4 (TCP) and...