Category Archives: MySQL

MySQL & Friends Community Dinner 2016

FOSDEM is once again descending on the ULB in Brussels, and so again will there be a MySQL and Friends Devroom. Tradition calls for a MySQL and Friends Community Dinner, and we certainly aim not to disappoint this year!

fosdem16_mysql_logo

Like last year, we’ll be renting the same private space to allow for easy socializing (at ICAB , more detailed directions below).

As such, prepare for an evening of food, drink and jolly conversation rivaling the great feasts of old. Disclaimer: Apart from jolliness, overindulgence on any account can not be blamed on the organizers of this event.

The listed ticket price includes all-you-can-eat Belgian Delicacies (or until we run out… go ahead, we dare you), as well as a great selection of Specialty Beers and other beverages. We’ll make sure that vegetarians will have options available, but anyone intending to join us with special dietary requirements (vegan, gluten-free, carnivore…), please let us know ahead of time!

In the interest of transparency: The price we’ve set is based on an assumption of a certain amount of people attending, based on last year’s attendance. If the amount of people ends lower than our target, and we end up having a surplus, any remaining funds will be donated to the Fosdem organization.

The reason we charge money up front is two-fold:

  1. We need to be able to give ourselves a rough estimate of the amount of attendees ahead of time, so we can make sure the caterer prepares enough food for everyone to enjoy. Free signups tend to make that number a bit less reliable. We want to make sure there is enough food to go around for everyone attending!
  2. Stress-free financials on the night of the dinner! We all know the effects of Belgian Beer on arithmetic skills. Flash your ticket, get your food.
We’re looking forward to meeting you all again at Fosdem and the Community Dinner. See you then!

Party-Squad – Dimitri VanoverbekeKenny GrypLiz van Dijk, Tjerk Ameel


Please register on Eventbrite_Logo_Small

Once again, we want to thank our generous sponsors, whose help makes this affordable at such a great price.

FOSDEM MySQL & Friends Devroom CfP is open !

fosdem16_mysql_logo

FOSDEM 2016 edition will be held January 30 and 31 in Brussels like every year since 2000.

The MySQL & Friends Devroom is back on Saturday from 9.00AM.

What is FOSDEM? It stands for the “Free and Open Source Software Developers’ European Meeting.” It’s a free event that offers open-source communities a place to meet, share ideas and collaborate.

CfP is open until December 1st!

Don’t forget to submit your sessions (submit here, don’t forget to select MySQL track) trackbefore December and see you soon in Brussels to discover amazing stuff related to MySQL and have some beers with Friends!

This year we propose two different types of talks :

  • 20 min session (15 slots)
  • 40 min session (3 slots)

fosdem_schedule

Choose 20 or 40 timeminutes for the talk.

 

fosdem_abstract

Don’t forget the Abstract in the description (second tab).

Last minute change in the Schedule

Dear MySQL Friends,

Unfortunately, this year we won’t have the pleasure to attend Raghu’s show. Indeed, he couldn’t apply in time for his Visa.

I would like to thank Andrew Morgan to have accepted to present his talk “MySQL & NoSQL – best of both worlds” to replace “ENOMEM: Will databases ever stop asking for more memory” from Raghu.

Respecting the logic, the next talk should have been “Introduction to MySQL Binlog Events” from Neha Kumari, but once again it was too late for Visa appliance.
Logically, Andrew was the next one and he agrred to present his talk even if the notification was very short.

The final schedule is:

Event Speakers Start End

Sunday

Welcome to MySQL & Friends Devroom Frédéric Descamps 09:00 09:15
ProxySQL : High Availability and High Performance Proxy for MySQL René Cannaò 09:15 09:35
Web mapping with MySQL
An introduction to MySQL GIS
Norvald H. Ryeng 09:40 10:00
Using MySQL Global Transaction IDs in Production Stephane Combaudon 10:05 10:25
Pseudo GTID and easy replication management Shlomi Noach 10:30 10:50
Zooming in on the New MySQL Group Replication Plugin Luis Soares 10:55 11:15
Docker and MySQL
Fun and bad practice
Erkan Yanar 11:20 11:40
Understanding & using authentication plugins Colin Charles 11:45 12:05
Moving to the NoSQL side: MySQL JSON functions Sveta Smirnova 12:10 12:30
Undelete rows from the binary log
a hacking session
Frédéric Descamps 12:35 12:55
Multi-threaded replication in MySQL 5.6 and 5.7 Stephane Combaudon 13:00 13:20
The New MySQL Replication Features in MySQL 5.7 and Beyond Luis Soares 13:25 13:45
Materialized Views for MySQL
Using Flexviews for MySQL
Justin Swanhart 13:50 14:10
Character encoding: breaking and unbreaking your data Maciej Dobrzanski 14:15 14:35
gdb tips and tricks for MySQL DBAs
How gdb can help you to solve MySQL problems
Valerii Kravchuk 14:40 15:00
Visualizing benchmark data with R and gpplot2 Peter Boros 15:05 15:25
Capacity metrics in daily MySQL checks Vlad Fedorkov 15:30 15:50
Performance Schema for MySQL Troubleshooting Sveta Smirnova 15:55 16:15
MySQL & NoSQL – best of both worlds Andrew Morgan 16:20 16:40

MySQL & Friends Community Dinner

My dear colleagues,  Liz van DijkDimitri VanoverbekeKenny Gryp, also known as the “Party Team” are organizing the “Fosdem MySQL & Friends Devroom Community Dinner” !

Like last year, we’ll be renting a private space to allow for easy socializing. However, in light of this year’s 20th Anniversary of MySQL in May, as well as MariaDB’s 5th Anniversary in February, we want to take things to the next level, and give the night a true community feel. Our new location is available to us until 2AM, and is part of the ICAB buildings, closer to the ULB (more detailed directions on the eventbrite page).

As such, prepare for an evening of food prepared for the Community, by the Community. That’s right, your hosts will be firing up the pizza ovens and serve you all with the best pizzas Belgium has to offer.

The listed ticket price includes all-you-can-eat pizza (or until we run out… go ahead, we dare you), as well as a great selection of Belgian specialty beers and other beverages. We’ll make sure that vegetarians have plenty of options, but anyone intending to join us with special dietary requirements, please let us know ahead of time!

As you stuff yourselves with glorious amounts of pizza, be sure to leave some room for dessert, as there will be a special birthday surprise in celebration of MySQL’s 20th and MariaDB’s 5th anniversaries.

In the interest of transparency: The price we’ve set is based on an assumption of a certain amount of people attending, based on last year’s attendance. If the amount of people ends lower than our target, and we end up having a surplus, any remaining funds will be donated to the Fosdem organization like last year.

The reason we charge money up front is two-fold:

1) We need to be able to give ourselves a rough estimate of the amount of attendees ahead of time, so we can make sure we buy/prepare enough ingredients for everyone to enjoy. Free signups tend to make that number a bit less reliable. We want to make sure there is enough food to go around for everyone attending!

2) Stress-free financials on the night of the dinner! We all know the effects of Belgian Beer on arithmetic skills. Flash your ticket, get your food.

We’re looking forward to meeting you all again at Fosdem and the Community Dinner. See you then!

Please register on Eventbrite_Logo_Small

We also want to say a big thank you to the sponsors of that main event:
oracleclrrgb

mariadb

percona

and to ICAB Brussels – Business and Technology Incubator

FOSDEM 2015 MySQL & Friends Devroom Schedule

The devroom’s schedule is now published on Fosdem’s website.

As you can see, it will be a heavy day full of good content. You can also notice that there won’t be any lunch-time break.

We advise you to then bring your lunch (like a sandwich) with you in the room and eat it between talks or prepare in advance when you will take your break during a talk you don’t want to attend (is it even possible ?).

Event Speakers Start End

Sunday

Welcome to MySQL & Friends Devroom Frédéric Descamps 09:00 09:15
ProxySQL : High Availability and High Performance Proxy for MySQL René Cannaò 09:15 09:35
Web mapping with MySQL
An introduction to MySQL GIS
Norvald H. Ryeng 09:40 10:00
Using MySQL Global Transaction IDs in Production Stephane Combaudon 10:05 10:25
Pseudo GTID and easy replication management Shlomi Noach 10:30 10:50
Zooming in on the New MySQL Group Replication Plugin Luis Soares 10:55 11:15
Docker and MySQL
Fun and bad practice
Erkan Yanar 11:20 11:40
Understanding & using authentication plugins Colin Charles 11:45 12:05
Moving to the NoSQL side: MySQL JSON functions Sveta Smirnova 12:10 12:30
Undelete rows from the binary log
a hacking session
Frédéric Descamps 12:35 12:55
Multi-threaded replication in MySQL 5.6 and 5.7 Stephane Combaudon 13:00 13:20
The New MySQL Replication Features in MySQL 5.7 and Beyond Luis Soares 13:25 13:45
Materialized Views for MySQL
Using Flexviews for MySQL
Justin Swanhart 13:50 14:10
Character encoding: breaking and unbreaking your data Maciej Dobrzanski 14:15 14:35
gdb tips and tricks for MySQL DBAs
How gdb can help you to solve MySQL problems
Valerii Kravchuk 14:40 15:00
Visualizing benchmark data with R and gpplot2 Peter Boros 15:05 15:25
Capacity metrics in daily MySQL checks Vlad Fedorkov 15:30 15:50
Performance Schema for MySQL Troubleshooting Sveta Smirnova 15:55 16:15
ENOMEM: Will databases ever stop asking for more memory Raghavendra Prabhu 16:20 16:40

You can download the ical here.

Note: this schedule can still change as some Visa processes are still open…

Fosdem 2015 MySQL Devroom – Submissions and ranking

Hi all,

Thank you for having submitted your talk proposal for this edition of Fosdem MySQL & Friends Devroom.

This is the list of talks ordered by rating. The first 18th were selected. Two talks from the top 18 were not chosen because the speakers (Luis Soares & Stéphane Combaudon) were already giving two talks.

Thank you to the Committee to have read and rated all the submissions.

The schedule will be published as soon as all speakers confirmed their venue.

Title Speaker
gdb tips and tricks for MySQL DBAs How gdb can help you to solve MySQL problems Valerii Kravchuk Y
Performance Schema for MySQL Troubleshooting Sveta Smirnova Y
Visualizing benchmark data with R and gpplot2 Peter Boros Y
Moving to the NoSQL side: MySQL JSON functions Sveta Smirnova Y
Zooming in on the New MySQL Group Replication Plugin Luis Soares Y
Using MySQL Global Transaction IDs in Production Stéphane Combaudon Y
ProxySQL : High Availability and High Performance Proxy for MySQL René Cannaò Y
Docker and MySQL Fun and bad practice Erkan Yanar Y
Undelete rows from the binary log a hacking session Frédéric Descamps Y
Character encoding: breaking and unbreaking your data Maciej Dobrzanski Y
Materialized Views for MySQL Using Flexviews for MySQL Justin Swanhart Y
The New MySQL Replication Features in MySQL 5.7 and Beyond Luis Soares Y
Web mapping with MySQL An introduction to MySQL GIS Norvald H. Ryeng Y
Dependable Data Stores: MySQL Replication and Friends to the Rescue Luis Soares X
Multi-threaded replication in MySQL 5.6 and 5.7 Stéphane Combaudon Y
Pseudo GTID and easy replication management Shlomi Noach Y
XtraBackup Recipes Stéphane Combaudon X
ENOMEM: Will databases ever stop asking for more memory Raghavendra Prabhu Y
Understanding & using authentication plugins Colin Charles Y
Capacity metrics in daily MySQL checks Vlad Fedorkov Y
Galera with Docker How Synchronous Replication and Linux Containers mesh together Raghavendra Prabhu
Introduction to MySQL Binlog Events Neha
MySQL & NoSQL – best of both worlds Andrew Morgan
New Features in Galera Cluster 4.0 Oli Sennhauser
Replicate to anything with FlexCDC plugins Using FlexCDC and plugins to process row change events Justin Swanhart
Simple MySQL automation with Ansible Guillaume Lefranc
Virtually lockless MySQL backups Backing up busy servers using the backup locks feature in Percona Server 5.6 Alexey Kopytov
Achieving MySQL Teleportation Jervin Real
Moving MySQL read load to Sphinx Vlad Fedorkov
MySQL 5.7 new features Oli Sennhauser
Tales of the MYSQL DBA Common pitfalls in using MySQL Dimitri Vanoverbeke
Troubleshooting and monitoring best practices Sveta Smirnova
8 things you can do with MariaDB that you wished you could do with MySQL. Colin Charles
Archiving data from a Galera Cluster Frédéric Descamps
Innodb Fragmentation Tips and Tricks Deep dive into InnoDB fragmentation Joffrey Michaie
Finding coffee at FOSDEM: New MySQL 5.7 features by example Jaime Crespo
Query Optimization in the Real World: From 2 hours to 0.00 seconds Jaime Crespo
pt-stalk – as a life simplification tool – highlights about pt-stalk Michael Rikmas
Introduction to MySQL Workbench Marcin Szałowicz
MyEnv 1.2 what users have requested Oli Sennhauser
Packagers’ Choices: Cherry-Picking Patches and Conventions, Taking MySQL + Galera as an Example Jörg Brühe
Securing databases with systemd for containers and services Raghavendra Prabhu