Severalnines Blog
The automation and management blog for open source databases

Choosing a Database Proxy for MySQL & MariaDB - New Whitepaper

We’re happy to announce that our new whitepaper Choosing a Database Proxy for MySQL and MariaDB is now available to download for free!

Load balancing and high availability go hand-in-hand. Without them, you are left with a single point of entry for your MySQL or MariaDB databases and any spike in traffic could cause your setup to crash.

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.

In this whitepaper, we discuss what proxies are, what their use is and how to build a highly available and highly controllable MySQL and MariaDB database environment using modern proxies.

Topics included in this whitepaper are …

  • What is a database proxy?
  • Overview of different proxy types
  • Features of advanced, SQL-aware proxies
    • Query Routing
    • Query Rewriting
    • Query Caching
    • Killing or slowing a Query
  • Designing a highly available proxy architecture
    • Dedicated proxy instances
    • Virtual IPs
    • Elastic load balancing
    • Application-side proxy discovery
    • Collocating proxies on application hosts
    • Silo approach to proxies
  • Managing large proxy deployments
  • Setting up highly available proxy layers with ClusterControl
    • ProxySQL
    • HAProxy
  • What proxy should I pick?

Download the whitepaper today!

ClusterControl
Single Console for Your Entire Database Infrastructure
Find out what else is new in ClusterControl

About ClusterControl

ClusterControl is the all-inclusive open source database management system for users with mixed environments that removes the need for multiple management tools. ClusterControl provides advanced deployment, management, monitoring, and scaling functionality to get your MySQL, MongoDB, and PostgreSQL databases up-and-running using proven methodologies that you can depend on to work. At the core of ClusterControl is it’s automation functionality that lets you automate many of the database tasks you have to perform regularly like deploying new databases, adding and scaling new nodes, running backups and upgrades, and more.

To learn more about ClusterControl click here.

About Severalnines

Severalnines provides automation and management software for database clusters. We help companies deploy their databases in any environment, and manage all operational aspects to achieve high-scale availability.

Severalnines' products are used by developers and administrators of all skills levels to provide the full 'deploy, manage, monitor, scale' database cycle, thus freeing them from the complexity and learning curves that are typically associated with highly available database clusters. Severalnines is often called the “anti-startup” as it is entirely self-funded by its founders. The company has enabled over 32,000 deployments to date via its popular product ClusterControl. Currently counting BT, Orange, Cisco, CNRS, Technicolor, AVG, Ping Identity and Paytrail as customers. Severalnines is a private company headquartered in Stockholm, Sweden with offices in Singapore, Japan and the United States. To see who is using Severalnines today visit, https://www.severalnines.com/company.