Open Tech Calendar

Combining ProxySQL and Orchestrator to eliminate SPoF's in MySQL HA Cluster

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.

https://www.meetup.com/London-Open-Source-Database-Meetup/events/267578754/

Wed 15th Jan 2020 6:00pm (Europe/London)

Wed 15th Jan 2020 9:00pm (Europe/London)

changed

Europe/London

changed

No

Yes

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.

---

If you are attending, please register on the Meetup.com page! This will help us buy the proper amount of food and drinks.