• Tomas Ulin
    2015 is year of MySQL anniversaries. Not only does the world's most popular open source database turn 20, but Oracle has now been the steward of InnoDB and MySQL for respectively 10 and 5 years. Join Tomas Ulin, VP of MySQL Engineering at Oracle, to celebrate and learn what's new.
  • Track: MySQL in the Cloud
    Intermediate
    Amrith Kumar, Peter Boros
    This is a presentation that is aimed at a DevOps or Developer in an IT organization and presents an in depth exploration of transparent database scale out using the Tesora DVE (open source) framework for MySQL. This presentation addresses such concepts as “What is horizontal scalability”, “How does one achieve horizontal scalability with DVE”, “What are the performance characteristics of DVE... [read more]
  • Track: MySQL Case Studies
    Intermediate
    Maggie Zhou, Keyur Govande
    Etsy started with a monolithic postgres database and moved to a horizontally sharded mysql store with lookup table and master-master replication. Scaling your data store is never as easy as just adding more hardware though, even with sharding. In this talk, we'll go over the pains and perils of sharding databases and how we solved some of the problems in Etsy's second take on... [read more]
  • -
    Geoffrey Anderson
    A live, in-person meeting with some of the participants of bi-weekly virtual meetup to simply talk about anything database-related and solutions to common problems. Also be sure to check out http://dbhangops.github.io for previous recordings and discussions!
  • Justin Swanhart
    This talk will describe how Flexviews can be used with JSON UDF to create an indexed materialized view of data extracted from JSON documents. This can be used as an index to access the JSON documents quickly.
  • Track: DevOps
    Beginner
    Daniel Guzman Burgos
    Fast and easy deploy of MySQL-Related Nagios services using Ansible. Embrace the power of automation using Ansible to easy deploy all you need to setup a basic monitor for your database environment with Nagios. Walk through Nagios key concepts: host, hostgroups, commands and services Ansible playbooks explained: Task, Modules and Roles review What's necessary to deploy.
  • Patrik Sallner
    Application developers and IT managers face an ever richer choice of databases in the market, so deciding the right combination for any given use case is essential. MariaDB is designed to work flexibly in combination with most other databases, both SQL and NoSQL. A new proxy gateway, MaxScale, allows MariaDB to address a further range of exciting new scenarios.
  • Track: High Availability
    Intermediate
    Frederic Descamps
    During this presentation, I will show how to implement several stuff that will improve your day-to-day workload. The points will cover topics like Point in Time Recovery, WAN replication with group segments, Avoiding SST when adding new Percona XtraDB Cluster node, ... the tips will be briefly explained to the audience and then show how to implement them. The tips covered must be known by every... [read more]
  • Chris Merz
    In this talk, we’ll demo the creation of a 1TB MySQL replication slave at 300x faster than the traditional provisioning time. This is a technical demonstration that will show detailed operational procedures. The legacy process for creating a MySQL replication slave from a 1TB master takes between 6-12 hours, depending on environment and conditions. The demonstrated process will take closer to... [read more]
  • Beginner
    Martin Arrieta
    -
  • Track: Openstack
    Advanced
    Zoltan Arnold Nagy, Mark Korondi
    Ceph has become the de-facto standard for deploying a highly available, distributed storage system underneath OpenStack. While it's very easy to start using ceph, selecting the right hardware is always a challenge. What's the optimal SSD-to-HDD ratio? SATA, NL-SAS or SAS? How cheap is cheap if I still want to get reasonable performance?
  • Track: Performance Optimization
    Intermediate
    Ryan Lowe, John Cesario
    Application performance is a key aspect of ensuring a good experience for your end users. But finding and fixing performance bottlenecks is difficult in the complex systems that define today's web applications. Having a method and knowing how to use the tools available can significantly reduce the amount of time between problems manifesting and fixes being deployed. The purpose of... [read more]
  • Vishnu Rao
    Is MySQL an avatar of Apache Kafka ? Can it be Kafka ? Yes, it can. This talk takes a shot at modeling MySQL as Kafka. PS: it's unconventional, hence a WILD supposition :)
  • Nisha Talagala
    Fusion-io, now part of SanDisk, continues its leadership in enterprise flash hardware and software for accelerating workloads like MySQL™. Nisha Talagala, SanDisk’s Lead Architect for SanDisk Memory Solutions will discuss how SanDisk enterprise flash products dramatically scale MySQL™ performance and deliver new levels of technical and cost efficiencies. Nisha will be discussing the unique... [read more]
  • Track: High Availability
    Beginner
    Mark Riddoch, Massimiliano Pinto
    The definition of a proxy is a level of indirection between a client and the server to which it is connecting, in this presentation we hope to show that by adding knowledge of the traffic that is being sent, that a proxy is much more than a simple connection routing appliance. The particular proxy in question is the MaxScale project which provides a pluggable architecture and unique knowledge... [read more]
  • Track: Performance Optimization
    Intermediate
    Matt Griffin, Vinoth Kanna RS
    Getting started with MySQL is pretty easy for most. It’s one of the many reasons why usage of the database has grown significantly over the years. What is more difficult, though, is what happens after you deploy to production and the ongoing operations of the database. This talk will show how DBAs and even non-DBAs can excel at administering and operating MySQL databases.
  • Track: Performance Optimization
    Intermediate
    Alexander Rubin
    Tuning Queries and Schema/Indexes can significantly increase performance of your application and decrease response times. This year I will cover new MySQL 5.6 and 5.7 algorithms that has been designed to improve query performance and simply tuning. Topics: 1. Group by and order by optimizations 2. MySQL temporary tables and filesort 3. Using covered indexes to optimize your queries 4... [read more]
  • Track: Replication & Backup
    Intermediate
    Ernie Souhrada
    Have you ever thought that your SSD storage just doesn't seem anywhere near as fast as advertised? What if I told you that a couple of small changes to your Linux servers had the potential to more than double the amount of throughput your MySQL servers could handle while simultaneously reducing query response time by around 50 percent? It's not a dream, Neo. If you're still in... [read more]
  • Track: Openstack
    Beginner
    Matt Griffin, Amrith Kumar
    This presentation is aimed at a very broad audience including IT Manager, CxO, DevOps, and database users, and provides a high level introduction to Database as a Service, and focuses on DBaaS with OpenStack Trove. It helps answer such questions as, “What are some major problems faced by IT and database users in the organization”, “What are the benefits of DBaaS”, “What is OpenStack Trove... [read more]
  • Track: MySQL 101 for DBA
    Beginner
    Ben Mildren
    This beginner level session looks to give attendees a solid grounding in what it means to make MySQL Highly Available. We'll review the wide variety of options available, and look at what considerations you should make when assessing their suitability for your environment. Attendees should leave the session with an understanding of how different solutions compare and which solutions they... [read more]
  • Beginner
    Ben Mildren
    This beginner level session looks to give attendees a solid grounding in what it means to make MySQL Highly Available. We'll review the wide variety of options available, and look at what considerations you should make when assessing their suitability for your environment. Attendees should leave the session with an understanding of how different solutions compare and which solutions they... [read more]
  • Track: Performance Optimization
    Intermediate
    Sergei Petrunia
    MariaDB 10.1 adds support for ANALYZE for executable statements. EXPLAIN command provided query plans, now ANALYZE provides data about actual execution. This makes it much easier to diagnose query optimization problems. In this session, we will: - Describe of what "ANALYZE statement" command does, - Demonstrate how one can use its output to diagnose query optimizer issues, -... [read more]
  • Track: Programming
    Beginner
    Ike Walker
    There are many great tools in the MySQL ecosystem. As a DBA, how do you pick the right tools and get started using them? In this session, I will describe how we assembled our MySQL toolbox at Flite, and I will give you some tips for assembling your own MySQL toolbox based on your environment. The focus of the session will be on understanding, testing, and using some of the best community tools... [read more]
  • Track: DevOps
    Intermediate
    Sunny Gleason
    Docker is a linux container technology that is taking the world by storm. It has enabled a vibrant ecosystem of open-source and private container images, including dozens of data storage solutions. However, there are still many tricky cases to manage with Docker, such as upgrading containers smoothly, accessing volumes inside and outside the container and bridging network ports from container to... [read more]
  • Track: High Availability
    Intermediate
    Seppo Jaakola
    Big and long term transactions have traditionally not behaved well in Galera Cluster. Large replication data sets have resulted in symptoms like elevated conflict rate, increased memory consumption, even OOM kill may happen, flow control pausing, cluster freezing... To deal with these issues, Galera users have been adviced to split large transactions in "reasonable size". There is also... [read more]
  • Track: Replication & Backup
    Intermediate
    Jean-François Gagné
    At Booking.com, we are adding new components to our replication architecture: Binlog Servers. Those allow us to deploy remote site replication without needing Intermediate Masters (which is good as those cause problems in our environment). Moreover, Binlog Servers allow us to reach extreme number of slaves replicating from a single master (greater than 100 slaves and growing). In this session... [read more]
  • Track: MySQL Case Studies
    Intermediate
    Nicolai Plum
    Booking.com is one of the largest MySQL-powered businesses. This talk is about the evolution of our MySQL-based system architecture from small beginnings to large systems. There will be an overview of the system architecture and development. This will be followed by detailed dives into the design of several sub-systems to show how our design is successful, what went well, and what went badly to... [read more]
  • Track: MySQL in the Cloud
    Intermediate
    Josh Snyder
    Yelp’s automation for MySQL codifies our database infrastructure in the form of code. Our automation allows our DBAs to bootstrap new databases repeatably and seamlessly, and provides elasticity to both production and development environments. This session will offer a deep dive into our tooling, which marries a configuration management system with automated monitoring and load balancer... [read more]
  • Track: Replication & Backup
    Intermediate
    Jean-François Gagné
    TBD
  • Amrith Kumar
    The move to the cloud, both public and private, is driving the need for self-service provisioning and management for all computing resources. For databases, this means an increased demand for Database-as-a- Service (DBaaS). Databases are notoriously complicated to configure and have unique requirements for availability, durability and scalability. This makes offering new and existing database... [read more]
  • Track: Openstack
    Adam Johnson, Shacolby Jackson
    Network virtualization, especially the overlay network technology, is gaining momentum and has been widely accepted in IaaS cloud deployments. But is it a viable option for enterprise private clouds, given that each enterprise has its own unique requirements? Blue Jeans Networks began looking to broaden its market by offering more open cloud solutions besides VMware cloud for its Dev/Test... [read more]
  • Track: MySQL 101 for Developers
    Beginner
    Justin Swanhart
    This talk will introduce the concept of database character sets. It will explain where character sets may be specified, how they are used and briefly describe some of the problems caused by incorrect character set use.
  • S. Keith Moulsdale
    Discuss the best legal and practical ways for database consultants to minimize data security risks in the face of increasing data security threats and regulations.
  • Track: High Availability
    Intermediate
    Geoffrey Anderson
    "It looks like a database problem" This is a pretty common phrase that comes up when triaging a production issue if MySQL is in the critical path. Often enough, the problems can be tracked down to new query patterns, edge cases in our company's applications, or even bugs in MySQL. In this talk, I'll describe the tools built by the DBAs at Box to help proactively monitor... [read more]
  • Track: Openstack
    Intermediate
    Matthew Fischer, Clayton O'Neill
    Beginning in late 2013, a small team at Time Warner Cable has been designing, building, and operating an OpenStack cloud. Over the past 18 months, we’ve grown the team and tripled our original deployment as we’ve offered more capacity and services to internal customers. During this time we made some good decisions, but also some mistakes. We’d like to share the journey, good and bad, and show you... [read more]
  • Track: MySQL 101 for DBA
    Beginner
    Daniel Guzman Burgos, Robert Barabas
    We will do a walkthrough of the deployment of a simple MySQL environment using the Ansible platform. The goal is to show how a playbook can be used to spin up a test lab quickly and provide a foundation for other environments. Covered topics will be: - Review of Ansible (terminology, project layout, operation modes) - Basic Ansible commands (validate connectivity, gather facts) -... [read more]
  • Track: Openstack
    Beginner
    Pere Monclus
    The concept of High Availability (HA) in the hardware world is well understood by cloud operators and vendors for both compute and network layers. However, when a cloud operator deploys a large-scale OpenStack cloud, most of the key cloud components are supported in software. Consequently, the cloud operator needs to ensure that HA spans across all layers and components involved in the lifecycle... [read more]
  • Track: MySQL 101 for Developers
    Beginner
    Yves Trudeau
    When someone decides to write a web application that will use MySQL, the data will very likely be stored inside InnoDB tables since InnoDB is by far, the most popular storage engine for MySQL. Like all storage engines, InnoDB has some characteristics that are inherited from its architecture and because of that, a perfectly sane schema may end up under performing. This talk will show you how to... [read more]
  • Track: MySQL and NoSQL
    Intermediate
    Peng Tian, Tian Xia
    At Facebook, we have built infrastructure and expertise for running MySQL at scale. However, there are some costs to using MySQL as a storage solution when viewed from a developer perspective. MySQL requires rigidly defining the schema of your data, which is a cost to developers, especially early in a product cycle when one is unlikely to know what the schema should be. DocStore aim to give... [read more]
  • Track: Performance Optimization
    Intermediate
    Thomas Hazel
    Every IT trend is driving exponential amounts of data, causing row explosion. The challenges when moving along the scaling journey can be huge when balancing MySQL performance, scale and architecture. So how can we effectively address these levels of scale and keep performance levels high as we move from millions to billions to trillions of rows? This session will compare storage engine... [read more]

Pages

Subscribe to Proposed Sessions