Customers often ask where they should install their MySQL, MariaDB, or Percona MySQL database proxies for high availability clusters, and how many. What is optimal for you may not be the right configuration for everyone. However there are some best practices we’ll discuss in this basic blog about deploying MySQL database proxies.
This blog provides basic information about business-critical application to database connections; my team focuses on MySQL, MariaDB, and Percona Server for MySQL on Linux/Unix that’s infrastructure-agnostic (on-prem, VM, hybrid-cloud, cloud, multi-cloud, etc.).
View this presentation to learn about two types of (MySQL) database proxies, which we refer to as ‘fast & simple proxy’ and ‘intelligent proxy’; and how transparent failover and read-write splitting works for these.
Watch our new on-demand webinar: “An introduction to database proxies (for MySQL)”. From a simple database connectivity scenario all the way through to advanced database connectivity setups and proxy functionalities, this webinar provides a solid introduction to database proxies (for MySQL).
This is the first in a series of blogs we’ll be publishing in 2020 with regards to database proxies for MySQL, including our very own Tungsten Proxy, which we’ll introduce to the MySQL community in more detail in the coming months.