Open Tech Calendar

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.

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

MariaDB and MySQL dad meets the London Community!

Monty Widenius and Vicentiu Ciorbaru from the MariaDB Foundation will be in London, and will meet the Community. Monty is the creator of MySQL and MariaDB. Vicentiu is a software engineer of MariaDB Foundation.

THE CALL FOR PAPERS FOR LIGHTNING TALKS IS OPEN!
To propose a 5mm talk, please send an email to: info@federico-razzoli.com

AGENDA
* 18:00 - Welcome and networking
* 18:20 - Introduction, by Federico Razzoli
* 18:30 - Lightning talks
* 19:00 - MariaDB and MySQL - What Statistics Optimizer Needs Or When and How Not to Use Indexes by Vicentiu Ciorbaru, software engineer @ MariaDB Foundation
* 19:30 - Pause
* 19:40 Meet the creator of MariaDB and MySQL - by Monty Widenius, CTO @ MariaDB, founder @ MariaDB Foundation

Afterwards, we can move to a nearby pub.

ABSTRACTS

Vicențiu Ciorbaru
MariaDB and MySQL - What Statistics Optimizer Needs Or When and How Not to Use Indexes

When your SQL query reaches the DBMS, it's the optimizer's job to decide how to execute it for you to get the result as fast as possible. To make this decision optimizer can examine the actual table data, but with multi gigabyte and terabyte tables, the only practical solution is to use various data statistics that were collected in advance. The better the statistics and the more precisely it describes the actual data, the faster the plan will be because the optimizer image of reality will be closer to the actual reality.

In this talk, you'll learn what data statistics MariaDB and MySQL can collect, what statements do that, how to tell the optimizer to use it (it won't necessarily do it automatically!) and how it can make your queries many times faster.

And, of course, when not to use indexes, when up-to-date statistics is enough.

Michael (Monty) Widenius - Meet the creator of MariaDB and MySQL

Ever wondered why MariaDB was created in the first place and where it is going now? Or perhaps you are curious what Monty thought when designing MySQL initially?

Come ask Monty anything you would like to know about MariaDB or MySQL, all while enjoying a nice drink in a relaxed atmosphere.

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

Mon 15th Jul 2019 6:00pm (Europe/London)

Mon 15th Jul 2019 9:00pm (Europe/London)

changed

Europe/London

changed

No

Yes

Peter Zaitsev meets the Community in London!

Peter Zaitsev, Percona's CEO, will be at our meetup. He will give a talk, and will answer any question from the community.

Before his talk, there will be the opportunity to give lightning talks, with a length of 5 minutes.

THE CALL FOR PAPER FOR LIGHTNING TALKS IS OPEN!
We'd really love to see some lightning talks to open the evening. It's an opportunity to give a short, low-effort speech in a friendly environment, at the presence of Peter Zaitsev and his audience.

To propose a lightning talk, please send an email to info@federico-razzoli.com

ABOUT PETER

Co-author of the highly regarded O’Reilly book High Performance MySQL, Peter is a long-time vociferous supporter of open source software at its most noble. He managed the High Performance Group within MySQL until 2006, when he co-founded Percona. He’s since stayed rigidly to his commitment free and open-source software, and in my view knows all there is to know about running a business underpinned by a truly open source software model. He’s also a well-known speaker at conferences and events such as All Things Open

AGENDA

18:00 - Welcome and networking
18:20 - Introduction, Federico Razzoli
18:30 - Lightning talks (TBD)
19.00 - Peter Zaitsev: Ten things developers should know about databases
19:50 - Pause with beer and food kindly offered by Percona
20:00 - Peter Zaitsev: Ask me anything

Afterwards, we can move to a nearby pub.

This talk works for developers or experienced database people. If you’re a developer there could be some surprises. If you’re a DBA then it’s good to get a perspective of things that may not come so naturally to developers. The points are valid for all flavours of open source database.

Peter has views on open source, on database technologies, on licensing, and on all kinds of other things. It’s good to talk, you can ask PZ anything! :)

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

Thu 4th Jul 2019 6:00pm (Europe/London)

Thu 4th Jul 2019 9:00pm (Europe/London)

changed

Europe/London

changed

No

Yes