Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL Router: New High Availability Building Block

MySQL Router: New High Availability Building Block

 20 April 02:00 PM - 02:50 PM @ Ballroom A
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Architecture/Design
New and Trending Topics
Topics:
MySQL
High Availability
Replication

Description

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.

Speakers

Marcos Albe's picture

Marcos Albe

Principal Technical Services Engineer, Percona

Biography:

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.

Share this talk


Slides