How to Perform an Online Upgrade of Percona XtraDB Cluster to Percona XtraDB Cluster 8.0
Percona XtraDB Cluster based on MySQL 8.0 has been out there for some time, so it’s not surprising more and more people are attempting to migrate into it. You may wonder how to approach this...
Tips for Upgrading ClusterControl
ClusterControl is an automation tool for managing open source databases. It supports various databases such as MySQL, MariaDB, PostgreSQL, Timescale, and MongoDB. It is used to handle the full “deploy, monitor, and scale” cycle of...
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...
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...
ClusterControl’s Vault Integration Adds Dynamic Data Security Protections
The security is paramount nowadays, especially for the organizations that deal with the sensitive data - financial, health, personal data. In those cases you are obliged to comply with numerous security and data protection standards...
Announcing ClusterControl 1.8: Manage Hundreds of Databases from a Single Interface
We’re excited to announce the 1.8 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. ClusterControl has always allowed our users to manage...
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...
Data Backups for SOC 2 Compliance
SOC 2 is an auditing procedure, developed by the American Institute of CPAs (AICPA), that seeks to verify if your service providers are securely managing your data to protect the interests of your business and...
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...
Driving Performance for PostgreSQL with HAProxy
Database performance is a very important concern when maintaining your database cluster, especially as it grows over the time. This is especially true if your application started out with low traffic going then growting to...
Tips for Managing & Monitoring Your Moodle Database
No matter what kind of application/system you are running, you will always need to manage and monitor your databases. Even in a small project, you want to be sure everything is going fine or if...
Scaling Out the Moodle Database
Moodle is a very popular platform to run online courses. With the situation we see in 2020, Moodle, along with communicators like Zoom forms the backbone of the services that allow online learning and stay-at-home...