Category Archives: MySQL

FOSDEM’17 MySQL & Friends Devroom, the schedule

This year, the MySQL & Friends Devroom will be held on Saturday 4th February 2017.

After having received a lot of submission (the highest amount ever!), with MySQL Community Team, we decided to organize and extra MySQL day that will take place at ICAB Incubator, 4 Rue des Pères Blancs in Brussels (same location as the MySQL Community Dinner). More to come on this day in a future blog post.

So back to the MySQL & Friends Devroom, the Committee high rated the following talks:

Event Speakers Start End

Saturday

MySQL & Friends Devroom
Welcome
Frédéric Descamps 10:00 10:30
Optimizing MySQL without SQL or touching my.cnf Maxim Bublis 10:30 10:50
Applying profilers to MySQL
From PMP to perf, and why performance_schema is not a replacement in all cases
Valerii Kravchuk 11:00 11:20
Instrumenting plugins for Performance Schema markleith 11:30 11:50
sysbench 1.0: teaching an old dog new tricks Alexey Kopytov 12:05 12:25
Introducing gh-ost: GitHub’s triggerless, painless schema migrations for MySQL Shlomi Noach 12:35 12:55
Autopsy of an automation disaster Jean-François Gagné 13:05 13:25
Honeypot your database
And easy method to detect if you’ve been hacked
Georgi Kodinov (Joro) 13:35 13:55
The Proxy Wars – MySQL Router, ProxySQL, MariaDB MaxScale Colin Charles 14:05 14:25
Painless MySQL HA, Scalability and Flexibility with Ansible, MHA and ProxySQL Miklos Mukka Szel 14:35 14:55
Inexpensive Datamasking for MySQL with ProxySQL
data anonymization for developers
Frédéric Descamps, René Cannaò 15:05 15:25
Speeding Up Analytical Queries in MariaDB
CTE’s and Window Functions Highlight
Vicențiu Ciorbaru 15:35 15:55
Data Analytics with MySQL, Apache Spark and Apache Drill Alexander Rubin 16:05 16:25
Group Replication: A Journey to the Group Communication Core Alfranio 16:35 16:55
Fine tuning Group Replication for performance Vitor Oliveira 17:05 17:25
Mix ‘n’ Match Async and Group Replication for Advanced Replication Setups Pedro Gomes 17:35 17:55
MyRocks: the RocksDB storage engine for MySQL Mark Callaghan 18:05 18:25
MyRocks in production at Facebook Yoshinori Matsunobu 18:30 18:50

 

Update: After each talk, you have 5 mins for questions and we have a 5 mins buffer to swap speaker and video recording.

Fosdem 2017’s MySQL & Friends Devroom Call for Papers is now open !

Hi all MySQL & Friends fans,

I’ve the pleasure to announce you that the CfP for MySQL & Friends Devroom for Fosdem 2017 is now open.

FOSDEM 2017 edition will be held February 4 and 5 in Brussels like every year since 2000.

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

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 6th (St Nicolas)!

The submission can be done using https://fosdem.org/submit.

If you don’t have an account yet, you must create one entering your personal details like email that we will use to contact you.

Then, after login, you can create an Event and don’t forget to select “MySQL and Friends devroom” or your submission will be lost maybe for ever.

selection_239

The duration for the talks are only 20 minutes ! (don’t forget to select it)

selection_240

And finally don’t forget to add an abstract:

selection_241

For people that doesn’t know it yet, MySQL & Friends Devroom is not the usual conference . Sales and Marketing talks are not welcome. Creativity and hard-code sessions are what we expect. If you have created tools or hacked MySQL, MariaDB or Percona Server, your history interests us and all the attendees as well.

Don’t hesitate to spread the word, we would like to receive even more submission than last year, we have a record to break !

You can find the names of the Committee members that will rate your talks on this page.

lefred.

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