BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Pentabarf//Schedule 0.3//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALDESC;VALUE=TEXT:MySQL and Friends devroom X-WR-CALNAME;VALUE=TEXT:MySQL and Friends devroom X-WR-TIMEZONE;VALUE=TEXT:Europe/Brussels BEGIN:VEVENT METHOD:PUBLISH UID:7006@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T091000 DTEND:20180204T093500 SUMMARY:The MySQL Ecosystem - understanding it, not running away from it! DESCRIPTION:
MySQL is unique in many ways. It supports plugins. It supports storage engines. It is also owned by Oracle, thus birthing two branches of the popular opensource database: Percona Server and MariaDB. It also spawned a fork: Drizzle. You're a busy DBA having to maintain a mix of this. Or you're a CIO planning to choose one branch. How do you go about picking? Supporting multiple databases? Find out more in this talk.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql_ecosystem/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Colin Charles":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6506@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T094000 DTEND:20180204T100500 SUMMARY:Beyond WHERE and GROUP BY DESCRIPTION:We've been writing SQL queries with WHERE, GROUP BY, ORDER BY, HAVINGfor decades. But nobody is using DOS 3.2 or Windows 1.0 anymore - whylimit yourself to SQL:86? The latest versions of MariaDB support thefeatures of SQL:99 (common table expressions), SQL:2003 (windowfunctions), SQL:2011 (system-versioned tables), and SQL:2016 (JSON),which allows you to build more complex (for example, hierarchical)models data and write simpler and faster queries.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/beyond_where_groupby/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Sergei Golubchik":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:7056@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T101000 DTEND:20180204T103500 SUMMARY:MySQL 8.0 Performance: InnoDB Re-Design DESCRIPTION:MySQL 8.0 brings many fundamental changes in InnoDB design.This talk will cover several of them, including new REDO and CATS.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql8_innodb/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Dimitri Kravtchuk":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:5990@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T104000 DTEND:20180204T110500 SUMMARY:MySQL 8.0 Roles DESCRIPTION:MySQL 8.0 introduced roles: a new security and administrative feature that allows DBAs to simplify user management and increases security of multi-user environments. The syntax for roles requires some adaptation. This talk will guide users through the intricacies of the new feature.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql8_roles/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Giuseppe Maxia":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6976@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T111000 DTEND:20180204T113500 SUMMARY:Histogram support in MySQL 8.0 DESCRIPTION:In MySQL 8.0, you can create histograms over column values. Histograms will improve the selectivity estimates used by the query optimizer, especially for conditions on columns that are not indexed. This presentation will cover the types of histograms you can create, and discuss best practices for using histograms. The presentation will contain many practical examples of how histograms improve query execution plans.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql_histogram/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Øystein Grøvlen":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6844@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T114000 DTEND:20180204T120500 SUMMARY:Let's talk database optimizers DESCRIPTION:Whenever you write a SQL query, the database query optimizer tries to find the best possible plan to retrieve your data. The question is, what can it do and how does it do it? In this talk we will look at recent developments in query optimizers from the major database providers. With a focus on the MySQL world, we will be looking at ways to "help" the query optimizer to come up with better plans.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/db_optimizers/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Vicentiu Ciorbaru":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6090@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T121000 DTEND:20180204T123500 SUMMARY:TLS for MySQL at large scale DESCRIPTION:At the Wikimedia Foundation we aim for perfect privacy of our users. That means not only enforcing TLS (https) between our users and the datacenters but all intermediate steps, including database access.
When you are a top 5 website with hundreds of thousand of queries per second and billions of users but a very limited budget, that is not easy, specially for MySQL. This is a description of our experience, including operational and performance pain points, of rolling out encryption.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/tls_mysql/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Jaime Crespo":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6277@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T124000 DTEND:20180204T130500 SUMMARY:MySQL InnoDB Cluster DESCRIPTION:MySQL InnoDB Cluster provides a built-in High Availability solution for MySQL. It tightly integrates MySQL Server, Group Replication, MySQL Router and MySQL Shell providing an easy-to-use full stack solution for HA.
MySQL Shell main goal is to provide a natural interface for all 'DevOps' tasks related to MySQL, by supporting scripting with development and administration APIs. To allow an easy and straightforward configuration and administration of InnoDB Clusters, the Shell provides a scriptable API - the AdminAPI. This API hides the complexity associated with configuring, provisioning and managing everything without sacrificing power, flexibility or security.
Join this session to understand the key points of MySQL InnoDB Cluster and to learn how to use the Shell and the AdminAPI to configure and manage InnoDB Clusters.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql_innodb_cluster/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Miguel Araújo":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6822@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T131000 DTEND:20180204T133000 SUMMARY:AMENDMENT Why We’re excited about MySQL 8 DESCRIPTION:There are many great new features in MySQL 8, but how exactly can they help your application? This session takes a practical look at MySQL 8 features and discusses which limitations of previous MySQL versions are overcome by MySQL 8 and what you can do with MySQL 8 that could not have been done before.
Please note that this talk replaces one entitled "Experiences with testing dev MySQL versions and why it's good for you" that was due to have been given by Simon Mudd, who has sent his apologies but wasn't able to deliver it.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql8/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Peter Zaitsev":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6602@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T134000 DTEND:20180204T140500 SUMMARY:MySQL Test Framework for Support and Bugs Work DESCRIPTION:MySQL Test Framework (MTR) provides unit test suite for MySQL. Tests in the framework are written by MySQL Server developers and contributors and run to ensure build is working correctly.
I found this is not the only thing which can be done with MTR. I regularly use it in my Support job to help customers and verify bug reports.
With MySQL Test Framework I can:
Everything with single script which can be reused on any machine any time with any MySQL/Percona/MariaDB Server version.
In this session I will show my way of working with MySQL Test Framework and I hope you will love it as I do!
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql_test_framework/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Sveta Smirnova":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:7334@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T141000 DTEND:20180204T143500 SUMMARY:AMENDMENT ProxySQL - GTID Consistent Reads DESCRIPTION:This talks about the very new development of ProxySQL including GTID coordination ! Breaking News !!
Please note that this talk replaces one entitled "Instant ADD COLUMN for InnoDB in MariaDB 10.3+ " that was due to have been given by Valerii Kravchuk, who has sent his apologies but is now unable to attend.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/proxysql_gtid/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="René Cannaò":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6854@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T144000 DTEND:20180204T150500 SUMMARY:Turbocharging MySQL with Vitess DESCRIPTION:Vitess has been in development since 2010, and has recently started gaining traction in the community. In this session, we'll cover the three major problems it solves: protecting MySQL instances, moving to the Cloud, and scaling indefinitely.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql_vitess/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Sugu Sougoumarane":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6834@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T151000 DTEND:20180204T153500 SUMMARY:Orchestrator on Raft: internals, benefits and considerations DESCRIPTION:Orchestrator operates Raft consensus as of version 3.x. This setup improves the high availability of both the orchestrator service itself as well as that of the managed topologies, and allows for easier operations.
This session will briefly introduce Raft, and elaborate on orchestrator's use of Raft: from leader election, through high availability, cross DC deployments and DC fencing mitigation, and lightweight deployments with SQLite.
Of course, nothing comes for free, and we will discuss considerations to using Raft: expected impact, eventual consistency and time-based assumptions.
orchestrator/raft is running in production at GitHub, Wix and other large and busy deployments.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/orchestrator_raft/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Shlomi Noach":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:6306@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T154000 DTEND:20180204T160500 SUMMARY:MyRocks roadmaps and production deployment at Facebook DESCRIPTION:We recently finished migrating from InnoDB to MyRocks in our user database (UDB) at Facebook. We have been running MyRocks in production for a while and we have learned several lessons. In this talk, I will share several interesting lessons learned from production deployment and operations, and will introduce future MyRocks development roadmaps.
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/myrocks_roadmap/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Yoshinori Matsunobu":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:7052@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T161000 DTEND:20180204T163500 SUMMARY:ProxySQL's internal: implementation details to handle millions of connections and thousands of servers DESCRIPTION:ProxySQL is a MySQL protocol aware, reverse proxy for database servers using the MySQL protocol, ranging from standalone MySQL/MariaDB/Percona, to clustering solution like Galera/PXC and Group Replication, to cloud platforms like RDS and Aurora. It is designed to handle millions of distinct users, millions of connections, and thousands of servers.In this session we will cover the internals that allow to efficiently handle traffic of large scale-out MySQL deployments. Specifically we will cover:- threading model and connections handling- non-blocking, async network I/O- state machine related to session tracking and management- traffic routing- backends monitoring
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/proxysql_internal/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="René Cannaò":invalid:nomail END:VEVENT BEGIN:VEVENT METHOD:PUBLISH UID:5984@FOSDEM18@fosdem.org TZID:Europe-Brussels DTSTART:20180204T163500 DTEND:20180204T170000 SUMMARY:MySQL Point-in-time recovery like a rockstar! DESCRIPTION:Point-in-time recovery can be very long when a large amount of binary logs must be replayed.During this session I will show how this can be accelerated without using any special external tool and how we can benefit from MySQL replication improvements even on a stand-alone server
CLASS:PUBLIC STATUS:CONFIRMED CATEGORIES:MySQL and Friends URL:https:/fosdem.org/2018/schedule/2018/schedule/event/mysql_pointintime/ LOCATION:H.1308 (Rolin) ATTENDEE;ROLE=REQ-PARTICIPANT;CUTYPE=INDIVIDUAL;CN="Frédéric Descamps":invalid:nomail END:VEVENT END:VCALENDAR