MySQL in 2015

http://photos2.meetupstatic.com/photos/event/1/2/4/f/600_437884687.jpeg

Our next meetup has a special guest, Percona (https://www.percona.com/). They are the worldwide reference in MySQL performance and deployment, and they will teach us how to improve our installation and give an overview of the current state of the technology.

His CEO, Peter Zaitsev (https://www.percona.com/about-us/our-team/peter-zaitsev), will be with us to give the talk and to respond any questions.

SCHEDULE

• 18.30 - 19.00

Getting ready! Networking and beverages.

• 19.00 - 19.30

Practical MySQL Optimisations:

This presentation will cover the main areas for improving MySQL performance, pointing out the most important things you need to get right for each of them. Areas include:

• Hardware

• MySQL Configuration

• Schema and Queries

• Application Architecture

In addition, we will highlight tools which offer a practical approach and will help you optimize your time by focusing on the queries that are most important for your application. At the end of this talk, we hope you will know how to optimize MySQL performance in a more practical way.

• 19.30 - 20.00

15 tips to boost your Galera Cluster

During this presentation, we will show how to implement several stuff that will improve your day-to-day workload.

The points will cover topics like Point in Time Recovery, WAN replication with group segments, Avoiding SST when adding new Percona XtraDB Cluster node, ... the tips will be briefly explained to the audience and then put in practice.

• 20.00 - 20.30

Questions and wrap up. Snacks and networking afterwards.