Using PostgreSQL Replication Slots
Curious how ClusterControl can help you design and implement environment agnostic deployment patterns? Join our final webinar of 2025! What are replication slots? Back in the days when "Replication Slots" were not yet introduced, managing...
MongoDB 4.2 Management & Monitoring Without Vendor Lockin
With the release of a new version of ClusterControl (1.7.5), we can see several new features, one of the main ones being the support for MongoDB 4.2. MongoDB 4.2 is on the market for a...
Why Did My MySQL Database Crash? Get Insights with the New MySQL Freeze Frame
In case you haven't seen it, we just released ClusterControl 1.7.5 with major improvements and new useful features. Some of the features include Cluster Wide Maintenance, support for version CentOS 8 and Debian 10, PostgreSQL...
Database Management & Monitoring for PostgreSQL 12
A few months ago we blogged about the release of PostgreSQL 12, with notable improvements to query performance (particularly over larger data sets and overall space utilization) among other important features. Now, with the ClusterControl...
Cluster-Wide Database Maintenance and Why You Need It
Undoubtedly, there is a long list of maintenance tasks that have to be performed by system administrators, especially when it comes to critical systems. Some of the tasks have to be performed at regular intervals,...
Announcing ClusterControl 1.7.5: Advanced Cluster Maintenance & Support for PostgreSQL 12 and MongoDB 4.2
We’re excited to announce the 1.7.5 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. This new version features support for the latest...
Database Performance Tuning for MariaDB
(Updated on 17 September 2024) Ever since MySQL was originally forked to form MariaDB it has been widely supported and adopted quickly by a large audience in the open source database community. Originally a drop-in...
How to Configure ClusterControl to Run on NGINX
ClusterControl uses the Apache HTTP Server to serve its web interface, but it is also possible to use nginx. nginx + PHP fastcgi is well-known for its capabilities to run on a small memory footprint...
Tips for Delivering MySQL Database Performance – Part One
The database backend affects the application, which can then impact organizational performance. When this happens, those in charge tend to want a quick fix. There are many different roads to improve performance in MySQL. As...
Maximizing Database Query Efficiency for MySQL – Part Two
This is the second part of a two-part series blog for Maximizing Database Query Efficiency In MySQL. You can read part one here. Using Single-Column, Composite, Prefix, and Covering Index Tables that are frequently receiving...
Maximizing Database Query Efficiency for MySQL – Part One
Slow queries, inefficient queries, or long running queries are problems that regularly plague DBA's. They are always ubiquitous, yet are an inevitable part of life for anyone responsible for managing a database. Poor database design...
PostgreSQL Database Monitoring: Tips for What to Monitor
Once you have your database infrastructure up-and-running, you’ll need to keep tabs on what’s happening. Monitoring is a must if you want to be sure everything is going fine or if you might need to...