Friday, August 11, 2017

Scalable MySQL Cluster With ProxySQL and Orchestrator

DZone Database Zone
Scalable MySQL Cluster With ProxySQL and Orchestrator

MySQL is one of the most popular open-source relational databases, used by lots of projects around the world — including incredibly large-scale ones like Facebook, Twitter, and YouTube. Obviously, such projects need a truly reliable and highly available data storing system to ensure the appropriate level of a service quality. And the very first and the main way to get the most efficiency from your data storage is setting up database clustering so that it could process a big number of requests simultaneously and remain workable in conditions of increased load. However, configuring such solution from the scratch can appear to be a rather complicated task.

Thus, the Jelastic team has prepared a one-click installation package for you: a Scalable MySQL Cluster with out-of-box master-slave replication, event request distribution, and node auto-discovery. It is intended to instantly deploy a pair of interconnected MySQL containers, which handle asynchronous data replication and are automatically reconfigured upon cluster scaling (i.e. changing the number of nodes). In addition, this solution is supplied with a ProxySQL load balancer in front of the database nodes set and embedded Orchestrator for its convenient management via GUI.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...