MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL.
The solution is composed of:
- MySQL Server
- MySQL Group Replication Plugin
- MySQL Clone Plugin
- MySQL Router
- MySQL Shell
All those components are developed and tested together to provide the easiest and best experience to the MySQL users.
As the MySQL Router is a TCP Level 4 router (like HA Proxy), some users requiring a more “intelligent” proxy having other extra features like caching, read/write splitting in relation with the user or SQL, firewall, … may be interested in using ProxySQL… and this is a good choice !
ProxySQL / MySQL Router in OSI Model
However, even is ProxySQL supports MysQL Group Replication, for …[Read more]