Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Schedule - Day 2 | Wednesday 26 April 2017

Sponsor Percona Live Open Source Database Conference

Filter by Topics

Filter by Tracks

Wednesday 26 April 2017
  • 9:00am to 9:20am
    None
    • Business / Case Studies
    Paul Dix (InfluxData)
    The traditional open source infrastructure business model relied on the backing company providing either support and professional services or closed source tools to provide additional functionality like production tooling, enhanced security and monitoring. For a time this model was good and it worked.
    Other OSDB Fundamentals Web Services
  • 9:25am to 9:45am
    None
    • Business / Case Studies
    Richard Hipp (SQLite.org), Baron Schwartz (VividCortex), MC Brown (Continuent), Peter Zaitsev (Percona)
    Join Percona and the Diamond sponsors of the conference, VividCortex & Continuent to talk database trends
    MySQL MongoDB Web Services
  • 9:50am to 10:10am
    None
    • Business / Case Studies
    Tomas Ulin (Oracle)
    Join Tomas Ulin, VP of MySQL Engineering at Oracle, to get the big picture overview of MySQL 8.0 development priorities, features that have already been delivered, and what is coming in upcoming releases.
    MySQL Business Intelligence
  • 10:15am to 10:40am
    None
    • Business / Case Studies
    Baron Schwartz (VividCortex)
    The world of technology is undergoing a rapid and permanent shift. We all know that we're moving to the cloud at an accelerating pace, but that's not the real news. The fundamental change that's taking place today is that our applications are far more distributed than they've ever been, in nearly invisible ways. And that's not good, because invisible means unmeasurable.
    Tools and Techniques Fundamentals

11:10am to 12:00pm

  • 11:10am to 12:00pm
    Ballroom A
    • Operations
    Giuseppe Maxia (VMware)
    Replication in the last years has been a game of marketing and bragging, where features have been presented as life-changing and highly innovative. Sometimes, these features are really good, and meet the users expectations.
    MySQL Replication
  • 11:10am to 12:00pm
    Ballroom B
    • Developer
    Rick James ((self))
    Indexing is a black art? Not really. But there are a lot of subtle issues and interactions to learn. This tutorial presents virtually everything there is to know about indexes. It takes the "cookbook" approach of saying "this SELECT begs for this INDEX", then deep dives into "why". This lecture moderately fast-paced.
    MySQL Optimization
  • 11:10am to 12:00pm
    Ballroom C
    • Operations
    • Developer
    Krunal Bauskar (Percona)
    Percona XtraDB Cluster 5.7 is our latest offering in the clustering space.
    MySQL High Availability Replication
  • 11:10am to 12:00pm
    Ballroom D
    • Operations
    Krzysztof Książek (Severalnines AB)
    Load balancing MySQL connections and queries using HAProxy has been popular in the past years. Recently however, we have seen the arrival of MaxScale, MySQL Router, ProxySQL and now also Nginx as a reverse proxy.
    MySQL Tools and Techniques High Availability
  • 11:10am to 12:00pm
    Ballroom E
    • Developer
    Colin Charles (Percona)
    The new MariaDB Server 10.2 release is out. It has some interesting new features, but beyond just a feature overview we need to look at how to use some of them. Learn about window functions, common table expressions, finer grained CREATE USER statements, and a lot more -- including getting mysqlbinlog up to parity with MySQL.
    MariaDB MySQL Tools and Techniques
  • 11:10am to 12:00pm
    Ballroom F
    • Business / Case Studies
    Mehul Shah (Amazon Web Services)
    AWS Glue is a fully managed ETL service that makes it easy to move data between your data stores. AWS Glue simplifies and automates the difficult and time consuming tasks of data discovery, conversion, mapping, and job scheduling.
    AWS Web Services
  • 11:10am to 12:00pm
    Ballroom G
    • Operations
    Igor Donchovski (Pythian)
    Redundancy and high availability are the basis for all production deployments. Database systems with large data sets or high throughput applications can challenge the capacity of a single server like CPU for high query rates or RAM for large working sets. Adding more CPU and RAM for vertical scaling is limited. Systems need horizontal scaling by distributing data across multiple servers.
    MongoDB High Availability Replication
  • 11:10am to 12:00pm
    Ballroom H
    • Developer
    • Wildcard
    Michael Benshoof (Percona), Alexander Rubin (Percona)
    The goal of the talk is to review the GIS improvements in MySQL 5.7 and new additions in MySQL 8.0 (new this year!), provide some general review of the functionality, as well as some working demos.
    MySQL MongoDB
  • 11:10am to 12:00pm
    Room 203
    • Business / Case Studies
    Scott Mansfield (Netflix)
    EVCache is an open source, fast, distributed cache. It is used at Netflix as a cache as well as a data store. EVCache powers user-facing applications, personalization algorithms or various micro-services. Until recently, EVCache stored multiple terabytes of data in RAM with multiple copies of the data for resiliency. With the continuing growth of data, this became a costly proposition.
    RocksDB Data as a Service Data in the Cloud
  • 11:10am to 12:00pm
    Room 204
    • Developer
    Christos Soulios (Pythian), Zburivsky Danil (Pythian)
    Data comes in different shapes. One of the these shapes is time series data. Time series is a very important abstraction since it can be used to describe multiple different processes. You can discover patterns in your website users behavior, capture sensor metrics from industrial equipment or track movement of celestial bodies using time series.
    Other OSDB Time Series NoSQL
  • 11:10am to 12:00pm
    Room 210
    • Operations
    • Business / Case Studies
    Alkin Tezuysal (Percona), René Cannaò (Dropbox / ProxySQL)
    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 we will quickly introduce its main features, so to better understand how it works.
    MySQL Optimization Tools and Techniques
  • 11:10am to 11:35am
    Room 209
    • Operations
    Rick Golba (Percona)
    Every good DBA wants to be a master of the shell for the DB. In this session we will help you understand how to structure commands, and discuss all the advanced functions and ways to chain command in the mongo shell. We will touch on CRUD functions, but much more time will be spent on the other areas as we have provide a dedicated session to master CRUD operations in MongoDB.
    MongoDB
  • 11:35am to 12:00pm
    Room 209
    • Operations
    Adamo Tonete (Percona)
    MongoDB has its own commands and structure of functions to ask the database to do work. In this talk we will discuss how the query, update, delete, and inserts work. However we will go beyond that talking about operators you should and shouldn’t use, and how this might actually drive your schema choices.
    MongoDB
  • 12:00pm to 1:00pm
    None

1:00pm to 1:50pm

  • 1:00pm to 1:50pm
    Ballroom A
    • Operations
    • Developer
    Evan Elias (Tumblr)
    Skeema (http://skeema.net) is a new open source CLI tool for managing MySQL schemas and migrations. It allows you to easily track your schemas in a repo, supporting a pull-request-based workflow for schema change submission, review, and execution. This session will introduce Skeema, walking through its functionality and usage.
    MySQL Devops Tools and Techniques
  • 1:00pm to 1:50pm
    Ballroom B
    • Operations
    Kenny Gryp (Percona), Tom De Cooman (Percona)
    Upgrading MySQL databases do not come without risk. There is no guarantee that no problems will happen if you move to a new major MySQL version. Should we just upgrade and rollback immediately if problems occur?
    MySQL Tools and Techniques Fundamentals
  • 1:00pm to 1:50pm
    Ballroom C
    • Operations
    Seppo Jaakola (Codership)
    Data inconsistency is the worst problem that can happen for synchronous database cluster. After data inconsistency has sneaked in the cluster, it will sooner or later appear during replication processing, simply because applying of replication events is not possible in some cluster node, due to missing rows, excessive rows or wrong values in the row columns.
    MySQL High Availability Replication
  • 1:00pm to 1:50pm
    Ballroom D
    • Operations
    • Business / Case Studies
    Sugu Sougoumarane (YouTube), Robert Navarro (StitchLabs, Inc.)
    We'll start off with an overview of Vitess and will drill down on its newer features: MySQL protocol, bulk statements, 2PC and Messaging. Following this, Robert Navarro from Stitch Labs will talk about their production experience with Vitess & Percona, how they migrated, what they like and what they'd like to see going forward.
    MySQL Data in the Cloud Sharding
  • 1:00pm to 1:50pm
    Ballroom E
    • Business / Case Studies
    Jean-François Gagné (Booking.com)
    In the last 24 months, MySQL/MariaDB replication speed has improved a lot, thanks to parallel replication. MySQL and MariaDB Server have different types of parallel replication; in this talk, I present the different implementations which will allow us to understand their limitations and tuning parameters.
    MariaDB MySQL Tools and Techniques
  • 1:00pm to 1:50pm
    Ballroom F
    • Business / Case Studies
    Sailesh Krishnamurthy (Amazon Web Services)
    Amazon Aurora is a fully managed relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It is purpose-built for the cloud using a new architectural model and distributed systems techniques to provide far higher performance, availability and durability than previously possible usi
    AWS
  • 1:00pm to 1:50pm
    Ballroom G
    • Operations
    • Wildcard
    Patrick King (Yelp)
    Abstract: Come on a journey with Patrick as he walks you through his transformation from a PostgreSQL DBA to a MySQL DBA. This talk will be a story of Patrick's journey where we'll walk through some of the major differences between PostgreSQL and MySQL and how we use both of them at Yelp.
    MySQL Devops Tools and Techniques
  • 1:00pm to 1:50pm
    Ballroom H
    • Developer
    Cihan Biyikoglu (Redis Labs)
    The talk details the new capabilities in Redis that extend the Redis data types with JSON. With the Modules, Redis provides native structures for modeling relational data. With the modules, Redis can be extended to embed new data types like JSON directly in its kernel.
    Other OSDB Programming NoSQL
  • 1:00pm to 1:50pm
    Room 203
    • Developer
    Konstantin Osipov (Tarantool.org)
    Tarantool 1.7 features a new storage engine for solid state and rotating disks: Vinyl. Vinyl implements log structured merge trees, just like Cassandra or RocksDB. In this talk, I will begin with discussing log structured merge trees, their architecture and implementation challenges.
    RocksDB Other OSDB Fundamentals
  • 1:00pm to 1:50pm
    Room 204
    • Developer
    Chris Larsen (Yahoo Inc.)
    This talk will cover the special case of time series data and the evolution of various schemas from RRD files to RDBMS schemas to NoSQL stores. Particularly we'll focus on why, as the amount of time series data grows and slicing the data by various dimensions becomes important, many users eschewed RDBMS for NoSQL or custom data layers.
    Other OSDB Time Series Metrics
  • 1:00pm to 1:50pm
    Room 210
    • Developer
    Matthew Lang (Continuent)
    The MySQL marketplace has quite a few High-Availability (HA) solutions such as Continuent Tungsten, Galera/XtraDB Cluster, various MySQL script/patch solutions, and RDS with multi-zone HA.
    Fundamentals Web Services
  • 1:00pm to 1:25pm
    Room 209
    • Operations
    Alexander Rubin (Percona)
    In this session we will explain what trade offs both MySQL and MongoDB make in their document models. We will look into what use cases will do better in which style and why. Leaving the talk you should have a good foundation to help weigh the technologies against each other based on what database features your application really needs.
    MongoDB
  • 1:30pm to 1:55pm
    Room 209
    • Operations
    Adamo Tonete (Percona)
    MongoDB has 12 index types. Do you know how each works, or when each should be used. This talk is about arming you with this knowledge as well as understanding how the index impact performance, storage, and even sharding of your data.
    MongoDB

2:00pm to 2:50pm

  • 2:00pm to 2:50pm
    Ballroom A
    • Operations
    Mark Filipi (SurveyMonkey), Brian Cain (Dropbox)
    Overview: Many MySQL shops have made the transition from MySQL 5.5 to 5.6 in the last few years, but GTID (global transaction identifier) implementation has often been considered too difficult or risky a change. MySQL 5.7 is making GTID implementation easier, but it may not yet be clear why to convert.
    MySQL Replication
  • 2:00pm to 2:50pm
    Ballroom B
    • Business / Case Studies
    Maxim Bublis (Dropbox), Peter Boros (Dropbox)
    At Dropbox, with 1000s of machines running MySQL, performance is important.
    MySQL Optimization
  • 2:00pm to 2:50pm
    Ballroom C
    • Developer
    dengcheng he (Alibaba), jiayi wang (Alibaba)
    MyRocks is a popular open source storage engine for MySQL, built on top of RocksDB storage library. For the past few years, Facebook spent plenty of time on it, to make it better and well-known, and claimed that MyRocks provides much better compression ratio and much smaller write amplification. rumor or truth?
    RocksDB MySQL Fundamentals
  • 2:00pm to 2:50pm
    Ballroom D
    • Operations
    Matthias Crauwels (Ghent University)
    Currently we are starting to roll out of a new MySQL database layer on our own private cloud. We are the 2nd largest university in Belgium and we have a wide variety of applications running on MySQL. Some are in-house development that we can control and some are external or closed source tools we just have to run.
    MySQL Devops Data as a Service
  • 2:00pm to 2:50pm
    Ballroom E
    • Developer
    Vicentiu-Marian Ciorbaru (MariaDB Foundation)
    MariaDB Server 10.2 has brought two new important querying features, Common Table Expressions (CTEs) and Window Functions.
    MariaDB MySQL Optimization
  • 2:00pm to 2:50pm
    Ballroom F
    • Business / Case Studies
    Eric Ferreira (Amazon)
    Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. How we got there and what features are most important to our customers is another example of the Amazon Flywheel.
    AWS
  • 2:00pm to 2:50pm
    Ballroom G
    • Business / Case Studies
    • Developer
    Álvaro Hernández (8Kdata)
    There are many valid reasons to want your MongoDB data to interact with the relational/SQL ecosystem: the humongous amount of tools available; the ability to use the SQL query language; or the need for really fast aggregate queries. However, this process is not easy: it requires designing the schema, which is ever changing; and a batch ETL process, which might require external tools. Enter T
    MongoDB Other OSDB Optimization
  • 2:00pm to 2:50pm
    Ballroom H
    • Operations
    Dharshan Rangegowda (ScaleGrid)
    Public clouds like AWS & Azure have become very popular platforms over the past few years. These public clouds provide a plethora of infrastructure features to help make your life easier - we will dig into the features/assets that you should be actively leveraging. On the flip side there are also a number of potential pitfalls that you need to be aware of and work around.
    MongoDB Devops
  • 2:00pm to 2:50pm
    Room 203
    • Developer
    Siying Dong (Facebook Inc)
    In the previous year, many RocksDB features were added. In this talk we explain the six most important ones: bulk loading, persistent cache, Lua compaction filter, blob storage, range delete and direct I/O. We also introduce features we expect to add in 2017.
    RocksDB Optimization
  • 2:00pm to 2:50pm
    Room 204
    • Business / Case Studies
    Michael J. Freedman (TimescaleDB)
    Today everything is instrumented, generating more and more time-series data streams that need to be monitored and analyzed. When it comes to storing this data, many developers often start with some well-trusted system like PostgreSQL, but when their data hits a certain scale, give up its query power and ecosystem by migrating to some NoSQL or other "modern" time-series architecture.
    Time Series
  • 2:00pm to 2:50pm
    Room 210
    • Developer
    Preetam Jinka (VividCortex)
    VividCortex monitors lots of production database servers, which means we get to see lots of different database problems. One specific type of problem that we like to focus on is database stalls. We define stalls as short periods of time, typically one second, when work isn’t getting done.
    MySQL
  • 2:00pm to 2:25pm
    Room 209
    • Operations
    Bimal Kharel (Percona)
    MongoDB Replication Tags, hidden notes, priority, votes and more are some of the least understood parts of MongoDB. We will talk about these how to consider using them or not using them, and even how this plays into your engine choices at times.
    MongoDB

3:30pm to 4:20pm

  • 3:30pm to 4:20pm
    Ballroom A
    • Developer
    Bogdan Munteanu (Dropbox)
    Edgestore is Dropbox’s distributed metadata store that is used by hundreds of products, services and features - both internal and external.
    Tools and Techniques Web Services NoSQL
  • 3:30pm to 4:20pm
    Ballroom B
    • Operations
    Andrew Moore (Percona), Jervin Real (Percona)
    Backups are crucial in a world where data is digital and uptime is revenue. Environments are no longer bound to traditional data centers, and span multiple cloud providers as well a plethora of heterogeneous environments. We need bulletproof backups and impeccable recovery processes.
    MySQL Tools and Techniques High Availability
  • 3:30pm to 4:20pm
    Ballroom C
    • Operations
    • Developer
    Yves Trudeau (Percona)
    Databases have always been heavy users for filesystems. They have strict durability requirements, they submit a high number of concurrent IO requests which are then required to complete in a timely manner. No wonder the choice of a filesystem has always been critical and workload dependent.
    MySQL Programming Data in the Cloud
  • 3:30pm to 4:20pm
    Ballroom D
    • Operations
    • Business / Case Studies
    Carmen Mason (VitalSource Technologies), Allan Mason (Advance Auto Parts, Inc)
    There are challenges in taking an existing infrastructure from a data center to Google Cloud. It is an understatement to say that there are plenty of differences between the two. For our in-house setup, VitalSource uses MHA with MHA-Helper managing the VIP for us. In GCE, we needed to separate the access management from the topology manager.
    MySQL Data in the Cloud High Availability
  • 3:30pm to 4:20pm
    Ballroom E
    • Developer
    Sergei Petrunia (MariaDB Corporation)
    MariaDB Server has had histograms since MariaDB 10.0, now, MySQL 8.0 will have them too.
    MariaDB MySQL Other OSDB
  • 3:30pm to 4:20pm
    Ballroom F
    • Business / Case Studies
    Eran Schitzer (Amazon Web Services)
    How AWS Database Migration Service enables database freedom Database freedom is a powerful thing. If you look at how companies have been locked into places with their database providers for a number of years, you can understand the trepidation. Those proprietary offerings are expensive with punitive licensing and auditing terms.
    AWS Web Services
  • 3:30pm to 4:20pm
    Ballroom G
    • Business / Case Studies
    Xixuan Xixuan (Alibaba Cloud)
    Replication is the significant data sync and consensus mechanism in MongoDB, and it’s only used for a single ReplicaSet deployment. Data between multi ReplicaSet or even cluster are separated and couldn’t being accessed each other. In some scenarios the entire data syncing among the cluster is required that we can access data at any Mongo instance.
    Web Services
  • 3:30pm to 4:20pm
    Ballroom H
    • Operations
    Jonathan Rudenberg (Flynn)
    Flynn is an open source platform as a service that automatically deploys and configures highly available database clusters with safe, automatic failover. This session will cover how Flynn automates the provisioning of MongoDB clusters, ensures that the replication topology is safe and available during failures, and provides useful administration features like backups.
    MongoDB Tools and Techniques High Availability
  • 3:30pm to 4:20pm
    Room 203
    • Business / Case Studies
    TBD
    Ignacio Iglesias (Percona)
    ---
    Data in the Cloud
  • 3:30pm to 4:20pm
    Room 204
    • Developer
    Paul Dix (InfluxData)
    Over the last year and a half we built an open source storage engine from scratch specifically for time series data. In this presentation I take a deep dive into the storage engine inside InfluxDB. More than just a single storage engine, InfluxDB is two engines in one: the first for time series data and the second, an index for metadata.
    Other OSDB Time Series Programming
  • 3:30pm to 4:20pm
    Room 210
    • Operations
    Johan Andersson (Severalnines)
    MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. It provides shared-nothing clustering and auto-sharding for MySQL, accessed via SQL and NoSQL interfaces. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.
    MySQL High Availability Sharding
  • 3:30pm to 3:55pm
    Room 209
    • Operations
    Sveta Smirnova (Percona)
    In MongoDB you normally have the choice of WiredTiger or MMAPv1, and with Percona Server we have added two more engines( MongoRocks and In Memory). How do you know which to use? How do you know which to tell developers to not use. How do these affect how you might design you data access functions and your schema?
    MongoDB
  • 4:00pm to 4:25pm
    Room 209
    • Operations
    David Murphy (Percona)
    Sharding is a large and complex topic but in this talk we will focus on helping you planning if you do shard, then what is a good attack plan for when you do want to shard. In understanding how you plan for sharding, you will learn what restrictions does this put on your data, what functions no longer work, what functions are bottlenecks when shard and more.
    MongoDB

4:30pm to 4:55pm

  • 4:30pm to 4:55pm
    Ballroom A
    • Operations
    • Business / Case Studies
    Nathan Northcutt (GoDaddy)
    For the last 2 decades, GoDaddy has expanded its core business from a simple DNS provider to a fully-fledged cloud hosting company for small businesses around the globe. Our customers daily experience is directly dependent on the millions of MySQL databases managed by our devops team.
    MySQL Devops Data as a Service
  • 4:30pm to 4:55pm
    Ballroom B
    • Developer
    Dmitry Andreev (Yandex)
    ClickHouse is more than just a great «House» for analytics. It can also be used as data storage for Graphite. So, I will explain to you why we decided to try ClickHouse as time-series storage for Graphite despite other existing options (Whisper, Ceres, etc.) And we loved it. Still ClickHouse couldn’t provide for all needs of Graphite (for example, metric search).
    Other OSDB Optimization Time Series
  • 4:30pm to 4:55pm
    Ballroom C
    • Developer
    Ming Chen (Tencent)
    Support for both high-availability and strong-consistency is a great challenge for MySQL cluster. Built on Paxos and with minimal modification to MySQL, PhxSQL provides full functionalities completely compatible with MySQL, zookeeper-level consistency, and semi-sync like performance when more than half of cluster nodes work.
    MySQL High Availability Replication
  • 4:30pm to 4:55pm
    Ballroom D
    • Operations
    Zhang Lu (AOL, Inc.), Jing Wu (AOL)
    Topic: MongoDB in AWS (MongoDB as a DBaaS ) The problem: How to automatically build self-healing mongo cluster specified by user on AWS. The solution: Using AWS CFN template and Service Catalog to deployment Mongo clusters to achieve: . Flexibility (specify nodes per shards and how many shards in cluster). . Auto-build MongoDB clusters. .
    MongoDB
  • 4:30pm to 4:55pm
    Ballroom E
    • Developer
    Kayoko GOTO (Spider Mroonga Storage Engine ), Kentoku SHIBA (Spiral Arms., Ltd)
    When your database is growing, you definitely need to think about other techniques like database sharding. SPIDER is a MariaDB Server / MySQL storage engine for database sharding. Using SPIDER, you can access your data efficiently across multiple database backends. In this time we will introduce the following things. 1. why SPIDER? what SPIDER can do for you? 2. when SPIDER is right for you?
    MySQL Tools and Techniques Sharding
  • 4:30pm to 4:55pm
    Ballroom F
    • Operations
    Brian Welcker (Amazon RDS)
    Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you to focus on your applications and business. This talk will provide guidance and tips for optimizing MySQL-compatible workloads on RDS.
    MySQL Optimization
  • 4:30pm to 4:55pm
    Ballroom G
    • Developer
    Mark Callaghan (Facebook)
    In late 2016 with MongoDB 3.2 there isn't an obvious winner between MongoRocks and WiredTiger when evaluating them for performance and efficiency on transaction processing workloads and in a few cases mmapv1 excels. In this talk I will share results for the three engines with MongoDB 3.4. My focus remains transaction processing.
    MongoDB
  • 4:30pm to 4:55pm
    Ballroom H
    • Operations
    • Business / Case Studies
    Jonathan Wage (Opensky), Rick Vasquez (Percona)
    As a TAM at Percona I have seen multiple environments with managed services of just MySQL, just MongoDB and with hybrid deployments of MongoDB and MySQL. I'd like to familiarize potential users of both open source databases to the best practices of having a hybrid environment.
    MySQL MongoDB Optimization
  • 4:30pm to 4:55pm
    Room 203
    • Developer
    Dhruba Borthakur (Rockset)
    RocksDB is used extensively by applications on the cloud. The stock RocksDB library does not provide for durability of data in the case of machine failures. This means that applications typically have to implement their own mechanisms for replicating data. On the other-hand, the AWS cloud environment provides services that allow elegant durability and replication of data.
    RocksDB NoSQL Data in the Cloud
  • 4:30pm to 4:55pm
    Room 209
    • Operations
    Bimal Kharel (Percona)
    Every good DBA needs data to make decisions, every good System Admin and DBA needs alerts to know when there are issues in the system. This session is for both groups, what metrics are important for each engine, and in general. Then what things are an indicator of something critically broken, vs something that should be graphed and reviewed?
    MongoDB
  • 4:30pm to 4:55pm
    Room 209
    • Developer
    Jon Tobin (Percona)
    Percona Server for MongoDB is fully compatible with MongoDB Community Edition, and has some cool extra features (some of which are available only in MongoDB's Enterprise Edition).
    RocksDB MongoDB
  • 4:30pm to 4:55pm
    Room 210
    • Business / Case Studies
    Qiumin Xu (Samsung)
    The storage subsystem has undergone tremendous innovation in order to keep up with the ever-increasing demand for throughput. Non Volatile Memory Express (NVMe) based solid state devices are the latest development in this domain, delivering unprecedented performance in terms of latency and peak bandwidth.
    NoSQL Metrics Monitoring

5:00pm to 5:25pm

  • 5:00pm to 5:25pm
    Ballroom A
    • Wildcard
    Alexey Kopytov (.)
    sysbench is a benchmark tool that is quite ubiquitous in the MySQL community. It is used by both beginners and huge corporations alike as a quick way to evaluate general system performance, a universal measuring tool to compare configuration or code changes, server releases or server flavors, or as a part of QA process.
    MySQL Optimization Tools and Techniques
  • 5:00pm to 5:25pm
    Ballroom C
    • Operations
    Valerie Parham-Thompson (Pythian), Ivan Groenewold (Pythian)
    In this session we will share our experiences using gh-ost for long-running schema changes in a multi-tier replication topology under high-volume traffic. This will include sharing how gh-ost can work with topologies using the Tungsten Replicator. We’ll share the ideal combination of commands to use in this setup, and discuss reasons we chose gh-ost over our old friend pt-online-schema-change.
    MySQL Tools and Techniques
  • 5:00pm to 5:25pm
    Ballroom D
    • Developer
    Niki Castle (---)
    CRM platform Appboy uses MongoDB for its storage, with a Redis caching layer used in a variety of ways to maximize performance for the real-time messaging and analytics we view as crucial to a communication platform.
    MongoDB Tools and Techniques
  • 5:00pm to 5:25pm
    Ballroom E
    • Developer
    Sang-Won Lee (Sungkyunkwan University)
    We are witnessing the advent of all-flash era. As pure read/write block device, flash SSD simply outperforms harddisk in terms of IOPS and cost-effectiveness. But this is not the whole story. As IO device, flash SSD has many different characteristics: to name a few, asymmetric read/write performance, abundant internal parallelism and an indirect address mapping layer, called FTL.
    MySQL Other OSDB
  • 5:00pm to 5:25pm
    Ballroom G
    • Operations
    David Murphy (Percona)
    This talk presents the updated information around current MongoDB backup options. We will discuss how MongoDB dumps work, different options to use for those dumps, binary backup options, the latest Percona Labs backup tool, new hot backup features, and how Mongo Ops Manager works.
    MongoDB Devops Tools and Techniques
  • 5:00pm to 5:25pm
    Ballroom H
    • Operations
    Steven Wang (TangoMe Inc)
    MongoDB database size will grow larger and larger. This talk will cover several ways to control MongoDB data size: 1 Use wiredTiger storage Engine 2 Expire Data from collections by Setting TTL 3 Manually purge data and rebuild Mongo databases 4 Automatically purge data
    MongoDB
  • 5:00pm to 5:25pm
    Room 203
    • Developer
    Ioannis Papapanagiotou (Netflix)
    Netflix created and open sourced Dynomite project to provide reusable distributed database infrastructure that turns single server data stores into scalable, distributed databases. Dynomite supports pluggable protocols and pluggable storage engines, which allows us to add sharding and replication to a variety of non-distributed data stores.
    RocksDB NoSQL High Availability
  • 5:00pm to 5:25pm
    Room 204
    • Business / Case Studies
    TBD
    Ignacio Iglesias (Percona)
    ---
    Devops
  • 5:00pm to 5:25pm
    Room 209
    • Operations
    Adamo Tonete (Percona)
    MongoDB Security is regularly in the news but what they don’t say is it’s all been avoidable. Simple mistakes add up to giant headaches and loss of management and customer confidence in you the DBA. We will cut through the marketing and hype and give your a real world playbook on what to do how to do it for securing your system.
    MongoDB
  • 5:00pm to 5:25pm
    Room 210
    • Business / Case Studies
    • Developer
    Alexander Yakovlev (Wamba)
    In my talk I will share with you our solution to the performance problem of MySQL. We were using MySQL and HandlerSocket over 5 years and at some point we decided to migrate from 5.6 to 5.7. The problem was that there was no HandlerSocket in 5.7.
    MySQL NoSQL