Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Percona Live 2017 | Schedule Sneak Peek - Day 1

Schedule Sneak Peek - Day 1
1130amto1220pm">

1130amto1220pm" type="button" class="timeslot_filter_btn clearfix" id="header_timeslot_group_1130amto1220pm" data-toggle="collapse">11:30am to 12:20pm

    1130amto1220pm">
  • 11:30am to 12:20pm
    Ballroom C
    • Developer
    Geir Høydalsvik
    In this session, I will describe the new features that have all ready been announced for MySQL 8.0. In addition to Data Dictionnary, CTEs and windows function the session is covering: * Move to utf8(mb4) as MySQL's default character set * Language specific case insensitive collation for 21 languages (utf8) * Invisible index * Descending indexes * Improve usability of UUID and IPV6
    MySQL Fundamentals
  • 11:30am to 12:20pm
    Room 204
    • Operations
    • Developer
    Kenny Gorman
    Apache Kafka has become very popular in the last few years. Kafka is a distributed pub/sub server for passing data in real-time. It's fault-tolerant, scalable, and extremely fast. In this talk I will discuss Kafka's core design, how it shares core architectural features of most modern databases, and how it can speed up certain workloads by amazing amounts.
    Other OSDB Optimization NoSQL
120pmto210pm">

120pmto210pm" type="button" class="timeslot_filter_btn clearfix" id="header_timeslot_group_120pmto210pm" data-toggle="collapse">1:20pm to 2:10pm

    120pmto210pm">
  • 1:20pm to 2:10pm
    Ballroom B
    • Business / Case Studies
    Andrea Ponzo, Rick Pizzi
    Even if InnoDB is universally recognized by DBAs as "the" engine to use for production data, there are use cases where InnoDB just does not fit. In this talk we will introduce the most popular engines available for MySQL to date, focusing on the limitations that plague InnoDB when it's about inserting rows at high rate and/or using a random primary key, like an UUID.
    MySQL Optimization Tools and Techniques
  • 1:20pm to 2:10pm
    Ballroom C
    • Operations
    • Developer
    Manyi Lu
    There are substantial improvements in the Optimizer in MySQL 8.0. Most noticeably, we have added support for advanced SQL features like common table expressions, windowing functions and grouping() function. We also made DBAs’ life easier with invisible index, and additional hints that can be used together with the query rewrite plugin.
    MySQL Optimization NoSQL
  • 1:20pm to 2:10pm
    Ballroom D
    • Operations
    Shlomi Noach
    Orchestrator is a MySQL topology manager and a failover solution, used in production on many large MySQL installments. It allows for detecting, querying and refactoring complex replication topologies, and provides reliable failure detection and intelligent recovery & promotion. This session walks through orchestrator setup, deployment and usage best practices.
    MySQL Tools and Techniques High Availability
  • 1:20pm to 2:10pm
    Ballroom G
    • Developer
    Antonios Giannopoulos, Grant Killian
    Sitecore is a very popular .Net CMS which relies on MongoDB for several key components. This presentation will review all Sitecore elements as they relate to MongoDB, and consider the broader lessons one can learn for any application with parallel types of usage.
    MongoDB Optimization Ecommerce
  • 1:20pm to 2:10pm
    Room 204
    • Developer
    Alexey Milovidov, Victor Tarnavsky
    Yandex team has built one of the best opensource databases for analytics.
    Other OSDB Optimization Business Intelligence
220pmto310pm">

220pmto310pm" type="button" class="timeslot_filter_btn clearfix" id="header_timeslot_group_220pmto310pm" data-toggle="collapse">2:20pm to 3:10pm

    220pmto310pm">
  • 2:20pm to 3:10pm
    Ballroom A
    • Business / Case Studies
    Ryan Lowe, John Cesario
    Capacity planning is hard. It’s even harder if you want to do it right. One of the industry’s dirty little secrets is that in today’s computing climate, there are few organizations for whom the benefits of formal and rigorous capacity planning outweigh the costs.
    Fundamentals Metrics Monitoring
  • 2:20pm to 3:10pm
    Ballroom C
    • Operations
    • Developer
    Sunny Bains
    The next version of MySQL will be a major release of new features and capabilities including a new data dictionary hosted in InnoDB. Learn all about the changes coming in the next version of InnoDB.
    MySQL Fundamentals
  • 2:20pm to 3:10pm
    Ballroom D
    • Operations
    Jonah Berquist
    gh-ost is a new tool by GitHub which changes the paradigm of MySQL online schema changes, designed to overcome today's limitations and difficulties in online migrations.
    MySQL Devops Tools and Techniques
350pmto440pm">

350pmto440pm" type="button" class="timeslot_filter_btn clearfix" id="header_timeslot_group_350pmto440pm" data-toggle="collapse">3:50pm to 4:40pm

    350pmto440pm">
  • 3:50pm to 4:40pm
    Ballroom A
    • Developer
    Bill Karwin
    We all have tasks from time to time for bulk-loading external data into MySQL. What's the best way of doing this? That's the task I faced recently when I was asked to help benchmark a multi-terabyte database. We had to find the most efficient method to reload test data repeatedly without taking days to do it each time.
    MySQL
  • 3:50pm to 4:40pm
    Ballroom C
    • Developer
    Luis Soares
    The most popular High Availability (HA) techniques deployed are based on making services redundant, in particular by means of replication. This fits quite naturally in the MySQL universe as the MySQL server has provided a mature replication solution for over a decade now.
    High Availability Replication MySQL
  • 3:50pm to 4:40pm
    Ballroom D
    • Operations
    Susanne Lehmann
    How do you correctly direct traffic to your databases? How do you add new replicas or remove broken or retired replicas from the traffic flow? How do you scale elastically? Every company has their own way of how they solve the service discovery problem. Some use solely DNS, others use VIPs, Consul, …..etc.
    MySQL Tools and Techniques High Availability
450pmto515pm">

450pmto515pm" type="button" class="timeslot_filter_btn clearfix" id="header_timeslot_group_450pmto515pm" data-toggle="collapse">4:50pm to 5:15pm

    450pmto515pm">
  • 4:50pm to 5:15pm
    Ballroom B
    • Developer
    Mark Callaghan
    MyRocks is the RocksDB storage engine for MySQL. We have continued to make it better in the last 6 months. I will explain the new features and improvements to performance and efficiency. I will also explain the workloads for which it might be a great fit. Finally I will describe the differences between InnoDB and MyRocks.
    RocksDB MySQL Optimization
  • 4:50pm to 5:15pm
    Ballroom C
    • Operations
    Giuseppe Maxia
    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. Using roles is easy, once you have digested all the documentation.
    MySQL Fundamentals
  • 4:50pm to 5:15pm
    Ballroom D
    • Operations
    • Developer
    Guangzhou Zhang
    This session is to talk about how Alibaba built up Relational Database Service (RDS) for PostgreSQL and MySQL in its public cloud service, which has been serving thousands of users and still fast growing. The techniques used to achieve high availability and fulfill SLA will be detailed: database proxy, resource isolation, security, failover etc.
    Data in the Cloud High Availability Other OSDB
  • 4:50pm to 5:15pm
    Ballroom G
    • Operations
    Antonios Giannopoulos
    With MongoDB 3.2 WiredTiger is now the default storage engine. This presentation will go through the configuration parameters when using MongoDB with WiredTiger and demonstrate performance benchmarks against different configuration values.
    MongoDB Optimization
  • 4:50pm to 5:15pm
    Ballroom H
    • Operations
    David Murphy
    We will cover what new features are in both MongoDB Community 3.4 and Percona Server for MongoDB 3.4. We will talk about the new graph functions, parallel balancing, sharding improvements, MongoDB zones, and many more new or improved areas of MongoDB. This talk is to give the community a lay of the land on what is working, and what might be good to wait to use.
    MongoDB Fundamentals NoSQL
515pmto540pm">

515pmto540pm" type="button" class="timeslot_filter_btn clearfix" id="header_timeslot_group_515pmto540pm" data-toggle="collapse">5:15pm to 5:40pm

    515pmto540pm">
  • 5:15pm to 5:40pm
    Ballroom B
    • Business / Case Studies
    • Developer
    Herman Lee
    MyRocks is a Facebook project to integrate the RocksDB LSM storage engine into MySQL. In the past, we have covered basic functionality and performance benefits of MyRocks. In this talk, we'll cover new features of MyRocks necessary to meet our scaling requirements. We have reduced data load times for the storage engine and added better diagnostic capabilities.
    RocksDB MySQL Devops
  • 5:15pm to 5:40pm
    Ballroom C
    • Developer
    Mike Frank, Georgi Kodinov
    This session provides the developer centric view on MySQL 8.0 security. MySQL 8.0 is continuing in the direction set by MySQL 5.7: to be secure by default.
    MySQL Programming
  • 5:15pm to 5:40pm
    Ballroom G
    • Developer
    Jason Terpko
    This presentation will demonstrate how you can use the aggregation pipeline with MongoDB similar to how you would use GROUP BY in SQL and the new stage operators coming 3.4. MongoDB’s Aggregation Framework has many operators that give you the ability to get more value out of your data, discover usage patterns within your data, or use the Aggregation Framework to power your application.
    MongoDB