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...
Tips for Upgrading Percona XtraDB Cluster to 8.0
MySQL 8.0 has been available for a while and Percona XtraDB Cluster 8.0 has also been available for some time as well. Also, MySQL 5.6 is coming up to its End-of-Life and people using PXC...
Press Release: Building a Private Database-as-a-Service is Emerging as a Prime Alternative to Managed Cloud Databases
Among the many innovations introduced by cloud computing, the database-as-a-service model has a number of advantages that are too beneficial to ignore. PRESS RELEASE STOCKHOLM, October 12, 2020: Severalnines, a pioneer in providing automation and...
How to Perform Rolling Upgrades for MySQL
There are different reasons for upgrading your databases. It could be to apply security fixes, to use new features, solve compatibility issues, or just to keep your system up-to-date. This upgrade can be a major...
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...