MySQL Day

pre-FOSDEM MySQL Day 2018: the schedule

Happy New Year everybody !
All your wishes should come true with 2018.0 !
As announced previously in this post, this year we will have the second edition of the MySQL Day just before FOSDEM.
All speakers confirmed their talk and I’ve the pleasure to share the announce the schedule !

Start
End
Event
Speaker
Company
Topic

Friday 2nd February

09:30
10:00
MySQL Community Team Welcome

10:00
10:40
Why we are excited about MySQL 8
Peter Zaitsev
Percona
MySQL 8.0

10:40
11:10
MySQL Document Store – where NoSQL and SQL meet
Frédéric Descamps
Oracle
MySQL 8.0 & DS

11:10
11:25
Coffee Break

11:25
12:05
MySQL 8.0 : Performance & Scalability
Dimitri Kravtchuk
Oracle
MySQL 8.0

12:05
12:40
Lightweight fibre-like framework for Storage Engine
Mateusz Rukowicz
Oracle
 Internals

12:40
13:30
Lunch Break

13:30
14:15
MySQL at Facebook
Yoshinori Matsunobu
Facebook
User Story

14:15
14:45
Observing and Operating MySQL Group Replication
Luís Soares
Oracle
Replication

14:45
15:25
New Data Dictionary & Storage Engines
Dmitry Lenev
 Oracle
 MySQL 8.0

15:25
15:40

Coffee Break

15:40
16:20
The Datacharmer’s surprise talk
Giuseppe Maxia
VMWare
???

16:20
16:55
Parallel Replication in MySQL 5.7 and 8.0 by Booking.com
JF Gagné & E Ortega
Booking.com
 Replication

16:55
17:25
Vastly Improved Replication Parallelization With Transaction Write Sets
 Vitor Oliveira
Oracle
 Replication

17:25
18:00
ProxySQL’s surprise talk

René Cannaò
ProxySQL
ProxySQL

As you can see, MySQL 8.0 and Replication will be targeted during this day, but not only ! We will have 2 surprise talks by two major MySQL Community members  ! Don’t miss them !
Places are limited and therefor, registration is mandatory (please register only if you can come). Registration is open until January 26th.
Just after the famous and popular MySQL Community dinner will take place at the same location !

pre-FOSDEM MySQL Day 2018

As last year, we will take advantage of the mass presence of our engineers during FOSDEM to organize a MySQL Day once again.
The Agenda is not yet known, but save the date and schedule your trip to Brussels keeping in mind that Friday February 2nd 2018, there will be a full day dedicated to MySQL !
More to come soon but don’t forget to register !
Please register here !

MySQL Day – Sessions review #9

Let’s finish these pre-FOSDEM MySQL Day Sessions reviews with Kenny Gryp‘s talk on MySQL Group Replication.
Kenny is working at Percona as MySQL Practice Manager.
Group Replication went Generally Available end of 2016, it introduces a (virtually) ‘synchronous’ active:active multi-master replication, in addition to asynchronous and semi-synchronous replication, the latter 2 being available in in MySQL for longtime.
As with any new feature, and especially with introducing active:active multi-master replication, it takes a while before companies are adopting the software in production database environment.
For example, even though MySQL 5.7 has been GA for more than a year, adoption is only starting to increase recently.
We can, and should, expect the same from Group Replication. As with every release, bugs will be found, and with new features, best practises still need to formed out of practical experience.
After giving a short introduction on what Group Replication is, Kenny will cover his experience so far in evaluating Group Replication.
Register for this main MySQL event and don’t forget the FOSDEM’s MySQL & Friends Devroom.
 

pre-FOSDEM MySQL Day – change in the schedule

One of the talk will replaced in the schedule by a panel discussion moderated by Morgan Tocker on MySQL Group Replication & MySQL 8.0.
The panel list will be composed of
Kenny GrypRené CannaòØystein GrøvlenMark LeithFrédéric Descamps 
 
 
 
These experts will answer questions from Morgan and from the audience.
Don’t miss this great opportunity to ask your questions and participate to this discussion about MySQL.
The schedule:
Start
End
Event
Speaker
Company
Topic

Friday 3rd February

09:30
10:00
Welcome !
10:00
10:25
MySQL 8.0: Server Defaults – An overview of what settings have changed or are under consideration
Morgan Tocker
Oracle
MySQL 8.0
10:30
10:55
MySQL 8.0: Unicode – What, why and how
Bernt Marius Johnsen
Oracle
MySQL 8.0
11:00
11:25
MySQL 8.0: Common Table Expressions (CTEs)
Øystein Grøvlen
Oracle
MySQL 8.0
11:30
11:55
Group Replication
Kenny Gryp
Percona
Group Replication
12:05
12:30
How Booking.com avoids and deals with replication lag
Jean-François Gagné
Booking.com
Replication
12:30
13:15
Lunch
13:15
14:10
Panel discussion on MySQL Group Replication & MySQL 8.0
MySQL 8.0 & GR
14:15
14:40
MySQL 8.0: Window functions – finally!
Dag H. Wanvik
Oracle
MySQL 8.0
14:45
15:00
Coffee Break
15:00
15:25
Using Optimizer Hints to Improve MySQL Query Performance
Øystein Grøvlen
Oracle
MySQL 8.0
15:30
15:45
Monitoring Booking.com without looking at MySQL
Jean-François Gagné
Booking.com
Fun, Sport, Not-MySQL
15:50
16:15
What you wanted to know about your MySQL Server instance, but could not find using internal instrumentation only
Sveta Smirnova
Percona
Troubleshooting
16:20
16:45
ProxySQL Use Case Scenarios
Alkin
Percona
ProxySQL
16:50
17:15
MySQL 8.0: GIS – Are you ready ?
Norvald H. Ryeng
Oracle
MysQL 8.0
Don’t forget to register on eventbrite.

MySQL Day – Sessions review #8

Let’s finish this pre-FOSDEM MySQL Day Sessions review week with Norvald Ryeng‘s talk on MySQL 8.0 and GIS.
As you know pre-FOSDEM MySQL Day will take place on Friday February 3rd in Brussels. During this day dedicated to MySQL and focusing on 8.0, Norvald will be on stage at 16.50 to check if you are ready for MySQL 8.0’s  GIS implementation.
Many great things are happening to GIS in MySQL 8.0. But in order to move forward, we also have to break legacy behavior. What will change? How? Why? And what can I do to avoid problems when I upgrade?
Join Norvald for a tour of changes and recommendations that you can start following today to make your data and applications ready for the future.
If you use GIS functionality in MySQL today, this is is a talk you shouldn’t miss! This talk is also for you if you’re interested in the future of GIS in MySQL, or just generally interested in how new functionality, legacy behavior, and upgrade problems are connected.
Norvald has been working as a software engineer on the MySQL Optimizer Team since 2011, working primarily with GIS. Also point of contact for package maintainers in Linux distributions.
During the pre-FOSDEM MySQL Day, a lot of MySQL Engineers will be present, on stage or in the audience, don’t hesitate to meet them and ask them all the questions you want. They will also be around during the MySQL and Friends Devroom at FOSDEM and at the amazing MySQL Community Dinner.

Register to this pre-FOSDEM MySQL Day !

MySQL Day – Sessions review #7

Today I will present the unique ProxySQL session of the pre-FOSDEM MySQL Day. Alkin Tezuysal will share with the audience ProxySQL Use Case Scenarios
Alkin is Senior Technical Manager at Percona and has extensive experience in enterprise relational databases working in various sectors for large corporations. With more then 20 years of industry experience he has acquired skills for managing large projects from ground up to production. For the past six years he’s been focusing on e-commerce, SaaS and MySQL technologies. He managed and architected database topologies for high volume site at eBay Intl. He has several years of experience on 24X7 support and operational tasks as well as improving database systems for major companies.
ProxySQL aims to be the most powerful proxy in the MySQL ecosystem. It is protocol aware and able to provide high availability (HA) and high performance with no changes in the application, using several built-in features and integration with clustering software.
During this session Alkin will quickly introduce its main features, so to better understand how it works. Then, he will describe multiple use case scenarios in which ProxySQL empowers large MySQL installations to provide HA with zero downtime, read/write split, query rewrite, sharding, query caching, and multiplexing using SSL across data centers.
Don’t miss this talk if High Availability is your concern ! Alkin will be on stage at 16.20 !
There will be 3 other sessions about ProxySQL during FOSDEM’s MySQL & Friends Devroom.
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 ProxySQLdata anonymization for developers
Frédéric Descamps, René Cannaò
15:05
15:25
Register for this main MySQL event and for the MySQL Community Dinner that will happen on Saturday, February 4th just after the FOSDEM’s MySQL & Friends Devroom.

MySQL Day – Sessions review #6

Let’s continue the review of the pre-FOSDEM MySQL Day‘s schedule. Today’s session is the one of Sveta Smirnova: What you wanted to know about your MySQL Server instance, but could not find using internal instrumentation only
Sveta Smirnova works as MySQL Support engineer since year 2006, she is also author of book “MySQL Troubleshooting” and author of JSON UDF functions for MySQL. In years 2006 – 2015 she worked in Bugs Analysis MySQL Support Group in MySQL AB, then Sun, then Oracle. In March 2015 Sveta joined Support Team in Percona. In years 2012-2015 she worked on bugs priority. She was also Support representative in MySQL Backup Development Team. She works on tricky support issues and MySQL software bugs on a daily basis. In years 2012-2015 she worked on MySQL Labs project “JSON UDFs for MySQL”. She is active participant in the open source community. Her main interests in recent years is solving DBA problems, finding ways to semi-automate this process and effective backup techniques.
As Sveta says, MySQL versions 5.6, 5.7 and 8.0 made life of DBA and MySQL Support engineers much easier. If even in version 5.5 we had to use operating system tools, debuggers and inject debugging code into our stored routines, with 5.7 this is not necessary. 8.0 did not provide us new instruments, but revolutionary new data dictionary implied huge improvements in existent instrumentation, so it became safe to use even in large production environments.
In this session Sveta will not discuss existent instrumentation, already well presented, but she will cover areas which are still not properly instrumented. She will mention what can and cannot do MySQL DBA to troubleshoot issues, falling in these areas.
I’m curious to see what Sveta will show us and certainly provide us valuable feedback where we could improve MySQL instrumentation even more.
This session will start at 15.50.
Don’t forget to register for this main MySQL event and for the MySQL Community Dinner that will happen on Saturday, February 4th just after the FOSDEM’s MySQL & Friends Devroom.
 

MySQL Day – Sessions review #5

On February 3rd, just before Fosdem and the MySQL & Friends Devroom, MySQL’s Community Team is organizing the pre-Fosdem MySQL Day.
Today we will review Dag H. Wanvik‘s session. Dag is spending most of his time implementing Windows Functions to MySQL.
Dag H. Wanvik is a senior MySQL developer for Oracle. Before he did Derby/Java DB development for Oracle/Apache Foundation and he is a Derby committer. He last co-authored JSON support for MySQL 5.7. In his previous existence Dag worked on several compilers and HA distributed data base systems.
The title of his session is MySQL 8.0: Window functions – finally!
Dag will share is current work on a much wanted feature to MYSQL: analytic SQL window functions. This presentation will give an introduction and quick overview of the feature set and example of interesting use cases, and also touch on implementation and optimization issues if time permits.
So as you can see yet another great feature planned for MySQL 8 !
If you want to attend this very special session and discuss with Dag, don’t forget to register for this main MySQL event. Dag will also attend the MySQL Community Dinner that will happen on Saturday, February 4th just after the FOSDEM’s MySQL & Friends Devroom.

MySQL Day – Sessions review #4

On February 3rd, just before Fosdem and the MySQL & Friends Devroom, MySQL’s Community Team is organizing the pre-Fosdem MySQL Day.
Today’s highlighted sessions are the one of Jean-Françcois Gagné, from Booking.com:
How Booking.com avoids and deals with replication lag at 12.05
Monitoring Booking.com without looking at MySQL at 15.30
Jean-François is working on growing the MySQL/MariaDB installations in Booking.com since he joined in 2013. His main task is focused on replication bottlenecks (and some other engineering problems too of course).  Jean-François works on improving Parallel Replication and deploys Binlog Servers.  He also has a good understanding of replication in general and a respectable understanding of InnoDB, Linux and TCP/IP.
In the fist talk, Jean-François doesn’t discuss about making replication faster, he will explain how to deal with the asynchronous nature of MySQL replication and therefore cover the (in-)famous lag.
During the session, he will start by quickly explaining the consequences of asynchronous replication and how/when lag
can happen. Then, Jean-François will present the solution used at Booking.com to avoid both creating lag and
minimize the consequence of stale reads on slaves (hint: this solution does not mean reading from the
master because this does not scale).
The second session is more different. I saw the first live presentation of it in Percona Live in Amsterdam and I really enjoy it. I don’t want to spoil it, so you will have to come to see Jean-François on stage sharing some “secrets” on how booking.com is monitored without looking at MySQL
Don’t forget to register for this main MySQL event and for the MySQL Community Dinner that will happen on Saturday, February 4th just after the FOSDEM’s MySQL & Friends Devroom,

MySQL Day – Sessions review #2

As written yesterday, on February 3rd, just before Fosdem and the MySQL & Friends Devroom, MySQL’s Community Team is organizing the pre-Fosdem MySQL Day.
The second talk of this series is the session of Bernt Marius Johnsen: MySQL 8.0 & Unicode – What, why and how ?
Bernt is Senior QA Engineer in the MySQL Server Team. He’s working with QA in general but he’s also specialized in character sets and security issues. He also in charge of the development of  test tools automation.
MySQL 8.0 introduces a whole new set of Unicode collations based on Unicode 9.0 for the MySQL utf8mb4 character set. This comes in addition to the existing plethora of character sets and collations
in MySQL 5.7. What are the benefits of the new collations, and why should they be used? (And by the way: What is a collation?)
The talk will give a quick overview of MySQL 5.7 collations and character sets and related Unicode terminology before presenting the new MySQL 8.0 collations.
The session will focus on issues related to upgrades from older character sets and collations covering topics like space and speed considerations, consequences for indexes and key lengths and InnoDB storage formats, etc.
So if you are juggling with character sets all day long or if never changed them in MySQL, I think this session is made for you !
Bernt will be on stage at 10.30am, don’t forget to register for this main MySQL 8.0 event
 

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569