MySQL Router: New High Availability Building Block
MySQL Router is a plugin-based, packet-level router that provides an easy way to implement high availability (HA) and load balancing for MySQL replication setups. It supports asynchronous replication topologies, Galera-based / group replication clusters and has dedicated plugin to integrate with Oracle's sharding solution (MySQL Fabric) and can be extended through user plugins to do many other things. During this session we'll show you how it works, how to configure it and the performance impact it implies to run MySQL Router in front of your servers, in multiple scenarios. We'll also review the advantages and drawbacks of MySQL Router and how it compares to HA Proxy and similar solutions, and explore potential solutions that could be implemented with it's plugin framework. At the end of the session attendees will know if MySQL Router is a potentially good fit for their HA needs, and will have the necessary knowledge to install and configure the router to start testing it right away.
Principal Technical Services Engineer, Percona
After 12 years working as a PHP/JS developer for local and remote firms, Marcos decided to pursuit true love and become full time DBA, so he has been doing MySQL Support at Percona for the past 6 years providing lead web properties with advise on anything-MySQL and in-depth system performance diagnostic help.