First London OpenSource DB meetup of the year!

We want to start 2020 with a high level talk, for those who need high availability with MySQL, using purely open source tools.

Matthias is a well known, highly experienced database consultant. Some of you already met him. The event is sponsored by Pythian.

AGENDA

• 18:00 - Arrival and networking
• 18:20 - Pizza & Drinks, kindly offered by Pythian
• 18:30 - Intro by Federico Razzoli
• 18:40 - "How to combine ProxySQL and Orchestrator to eliminate single-points-of-failure in your MySQL HA cluster", by Matthias Crauwels, Lead Database Consultant @ Pythian

Afterwards we'll move to a nearby pub.

ABSTRACT

How to combine ProxySQL and Orchestrator to eliminate single-points-of-failure in your MySQL HA cluster

In this session we will be considering a standard asynchronous MySQL replication technology. We'll go and analyse how we can eliminate single points of failure in the technology stack and how we can avoid network partitioning issues. We will use Orchestrator to help us achieve master high availability and we will use ProxySQL to redirect application traffic to the appropriate MySQL servers.

I will show how we can make each component on its own highly available, how we can prepare for a full datacenter outage and even up to a full scale regional outage when leveraging a public cloud provider.

SPECIAL NEEEDS

Please let us know if you have dietary restrictions or cat allergies by dropping an email to hello@federico-razzoli.com