Past Meetup

MYSQL operations in Docker, Introducing new SQL syntax and improving performance

This Meetup is past

40 people went

Location image of event venue

Details

We are very happy to let you know that we will have Giuseppe Maxia (https://www.linkedin.com/in/datacharmer) and Sveta Smirnova (https://www.linkedin.com/in/svetsmirnova) presenting in English at this meetup on September 13th, 2016. See you there!

Thanks Logmatic.io (http://logmatic.io/) for hosting & making sure we don't get too hungry!

Agenda:

18:00 – Doors Open / Registration / Networking / Grab a Drink

18.30 – START - MySQL Paris Meetup

Intro with Ioana Gramschi

18.40: Giuseppe Maxia from VMware (http://www.vmware.com/)

19.10: Networking break - Drinks & Food

19.30: Sveta Smirnova from Percona (https://www.percona.com/)

------------------------------------------------------------------------------------------

Giuseppe Maxia

Talk: MYSQL operations in Docker

Running database operations in containers is a slightly different proposition than running other services. MySQL, being designed - as the majority of services - for running in a dedicated host, needs some adjusting to fit in a container. Thanks to its configurability, we can deploy MySQL containers to fit our purposes, with just the right amount of customization. However, customizing in Docker is done differently, and we will see it in detail. This workshop will show a quick example of:

• Operations from scratch, starting with running a single container.

• Steps and pitfalls of customising containers.

• Data management for safety and performance (i.e. volumes!).

• Making several containers work together in replication.

Attendees who want to follow along can get "docker-replication" files from:

https://github.com/datacharmer/mysql-replication-samples

Biography:

Quality Assurance Architect at VMware. Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle. Then at Continuent, Inc and currently at VMware through a merge.

I am an active member of the MySQL community and long timer open source enthusiast. During the past decades, I have worked in various IT related fields, with focus on databases, development, system administration.

Fluent in Italian, English, Perl, Spanish, SQL, C, Bash, and good speaker of C , French, Python, Java. I work in cyberspace, with a virtual team.

------------------------------------------------------------------------------------------

Sveta Smirnova

Talk: Introducing new SQL syntax and improving performance with preparse Query Rewrite Plugins

Do you miss SQL commands which MySQL does not support ? Do you want MySQL to have the missed SQL standard features or introduce new fancy commands ? Maybe improve fix of https://bugs.mysql.com/bug.php?id=2 "Does not make Toast"? Or just replace badly written query with a more efficient one ? With new feature of the Audit Plugin interface: Query Rewrite Plugins you can do most of these.

In this session I will demonstrate how to create, install and use Query Rewrite plugins. We will introduce completely new SQL command and let MySQL execute it.

Links to the examples of plugins: https://github.com/svetasmirnova/mysqlbackup_plugin, https://github.com/svetasmirnova/mysqlbackup_plugin, https://github.com/svetasmirnova/custom_hint_plugin

Biography:

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[masked], 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.

Before starting at MySQL in 2006, she worked as web developer on several closed CRM systems. In years[masked] 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.

Sveta is author of the book "MySQL Troubleshooting" (http://shop.oreilly.com/product/0636920021964.do)