Severalnines has integrated the open source database load balancing technology, ProxySQL, with its comprehensive database management system, ClusterControl. Packaged in the latest ClusterControl release, ProxySQL enables MySQL and MariaDB database systems to easily manage intense, high-traffic database applications without losing availability. ClusterControl is the first and only database management system to automate the deployment and management of this exciting new technology. This capability increases a company’s ability to maintain business-critical productivity and end user satisfaction and, in turn, revenue.
High-traffic database applications draw an enormous amount of queries daily and DBAs and SysAdmins require reliable technology solutions that can automatically scale to handle those connections while remaining available for still more. Improper load balancing leads to downtime, an avoidable, detrimental effect estimated to cost companies an average of $5,600 per minute (or $300K per hour) across the globe according to industry research organization Gartner.
Load balancers are an essential component in database high availability; especially when making topology changes transparent to applications and implementing read-write split functionality. This is especially true with high-traffic websites where potentially hundreds of thousands of concurrent connections are constantly trying to access your data. ProxySQL has an advanced multi-core architecture to handle that large number of connections, multiplexed to potentially hundreds of backend servers squeezing every drop of performance out of your database cluster; all with zero downtime. This integration came from requests from Severalnines users who needed greater levels of scalability.
But having a highly-available load balancer designed for high-traffic isn’t the end-all solution to delivering high availability. You also need a way to deploy and manage the database cluster, handle upgrades, run backups, ensure failover and recovery, and the ability to scale the data nodes to accommodate ever-growing data. For this you will need ClusterControl, an all-inclusive open source database management system that removes the need for multiple management tools.
Vinay Joosery, Severalnines CEO, had this to say about ProxySQL: “With the growing importance of load balancers in today’s distributed database environments, ProxySQL has the potential to become an indispensable part of the high-availability stack. ProxySQL offers an alternative load balancing technology for MySQL users who need to handle massive amounts of connections. This addition complements the other load balancing technologies currently supported in ClusterControl.”
Ren? Canna?, Creator of ProxySQL added: “The ability of ClusterControl to deploy, configure and monitor the majority of the open-source databases makes it an ideal tool for their complete management. I am really excited to see ProxySQL into ClusterControl load balancers offering for MySQL, allowing the possibility to manage even more complex setups through the intuitive interfaces that ClusterControl provides”
