meetup

Fourth brussels php meetup, all about mysql

Date

12 Jun 2015

Hour

19:00

Speakers

Dimitri Vanoverbeke

Dimitri Vanoverbeke

At the age of 7, Dimitri received his first computer, since then he has felt addicted to anything with a digital pulse. Dimitri has been active in IT professionally since 2003 in which he took various roles from internal system engineering to consulting. Prior to joining Percona, Dimitri worked as a Open Source consultant for a leading Open Source software consulting firm in Belgium. During his career, Dimitri became familiar with a broad range of open source solutions and with the devops philosophy. Whenever he's not glued to his computer screen, he enjoys travelling, cultural activities, basketball and the great outdoors. Dimitri is living with his girlfriend in the beautiful city of Ghent, Belgium.

Peter Boros

Peter Boros

Peter joined the European consulting team in May 2012. Before joining Percona, among many other things, he worked at Sun Microsystems, specialized there in performance tuning and was a DBA at Hungary's largest social networking site. He also taught many Oracle University MySQL courses. He has been using and working with open source software from early 2000s. Peter's first and foremost professional interest is performance tuning. He currently lives in Herceghalom, Hungary with his wife and son.

Course of the evening

Hour Program
19:00

Welcome & Food :

20:00

Practical MySQL Optimisations (Dimitri Vanoverbeke) :

Successful applications often become limited by MySQL Performance. Join the Meetup with Percona to discuss how to get great MySQL performance while being practical - spending time on what gives you the best return. The talk 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, Peter 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 webinar, you will know how to optimize MySQL performance in the most practical way.

Register

Rate the talk
21:00

MySQL and Openstack (Peter Boros) :

Like it or leave it, there's no disputing that MySQL is by far the most commonly used database in OpenStack deployments. Most folks know that there are a number of different flavors of MySQL -- standard MySQL, MariaDb, Percona XtraDb, MySQL Galera, Percona XtraDb Cluster, etc. However, there are a number of misconceptions and myths around the pros and cons of these flavors of MySQL. In this talk, we hope to dispel some of these myths and give some clear information on what are the strengths and weaknesses of each of these flavors, what pitfalls to avoid when migrating between them, and what architectural information to take into account when planning your OpenStack MySQL database deployments. We will discuss replication topologies and techniques, and explain how the Galera Cluster variants differ from standard MySQL replication, and demonstrate using pt-query-digest to determine if a synchronously-replication database cluster like Percona XtraDb Cluster is a good fit for certain OpenStack projects.

Register

Rate the talk
23:30

Closing and migration to the closest bar for the most motivated :

Kindly sponsored by Percona