Sessions

  • Lawrence Schwartz
    Come and see what happens when you pit a seasoned MySQL DBA against a MySQL newbie to perform replication in MySQL. Who will get the job done well, first and without issues? Think you know the answer? Come find out what happens when the “secret ingredient” is revealed.
  • Track: Best Practices for Businesses
    Beginner
    Bill Karwin
    "Don't bother me with DBA 'best practices,' we have real work to get done." So go the famous last words from overworked IT managers (we’ve all been there at one time or another). Best practices don't have to interrupt your work or make it harder. Ideally, they should make database operations more predictable and less fraught with emergencies or surprises. This... [read more]
  • Peter Zaitsev
    Are you up to speed on the latest MySQL trends in high availability, manageability, and the cloud? Peter Zaitsev will discuss the latest developing needs and solutions in these three key areas and what they mean for various types of MySQL users, from startups to large organizations. Peter will also make projections about the future of MySQL in these three areas and how you can prepare for the... [read more]
  • Ori Herrnstadt
    Ok, I'm exaggerating - it may take a couple of minutes, but Yes - the FoundationDB SQL Layer, built on top of the FoundationDB K/V store, brings SQL scale to a new level. Easy Scale means that adding capacity is as easy as spinning up nodes, and that replication and sharding become a thing of the past. In this presentation I will spin up a cluster, discuss the architecture, and walk through... [read more]
  • Track: Tools
    Intermediate
    Ryan Lowe, Marcos Albe
    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]
  • Track: Database Administration
    Intermediate
    Jeremy Glick, Andrew Moore
    Join Jeremy Glick and Andrew Moore whilst they share their experiences persuading MySQL to meet various regulatory compliance standards. Previous methods of logging for compliance included UDFs, triggers and other unreliable means to fill a gap in the core offering. However, given some of today's new requirements, they are no longer viable solutions. Did you know that MySQL has had a... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Raghavendra Prabhu
    ACIDic Clusters: Review of current relational databases with synchronous replication. ===================================================================== This talk reviews database clusters of our time which employ synchronous replication while being ACID compliant. ACID compliance implies ability to support transactions across nodes. As part of this talk, PXC (Percona XtraDB Cluster)/... [read more]
  • Beginner
    Vladimir Fedorkov, Andrew Aksyonoff
    When we're talking about implementing faceted search, auto completion, misspells correction, finding similar items and simply search across millions documents or goods on the website, MySQL built-in full-text indexes comes in mind. But as your data set grow up it may become a performance bottleneck on your website, which can be solved using Sphinx - search server optimized to run Full-Text... [read more]
  • Renjish Abraham
    Dropbox helps users store and share more than a billion files a day. MySQL is one of the critical components of our infrastructure stack. In this talk, we will talk about the overall architecture, some of the design decisions we took, war stories and lessons learnt.
  • Intermediate
    Peter Zaitsev
    So you're tasked with designing a new MySQL powered application, or with refining the architecture of the old one to meet new challenges. What process should you follow and what tools should you have in your toolbox? In this presentation we will look into the process that MySQL Architects should follow in order to design efficient and scalable MySQL powered applications. We will look... [read more]
  • Track: Database Administration
    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: Developing Applications
    Beginner
    Chip Turner
    Traditionally, querying MySQL has meant blocking while waiting to connect, blocking to send a query, and blocking to receive it. This works, to a point, but as systems begin to grow, waiting on each database sequentially ends up having a significant impact on overall system performance and latency. Facebook has tackled this issue by making a non-blocking (aka Asynchronous) MySQL client, which... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Colin Charles
    In the third edition (2012) of High Performance MySQL, MHA usage is described as: "anyone other than Yoshinori who is using it in production, and we haven't used it ourselves." Little known to the authors, we've spent quite a lot of time working on MHA and figuring out its kinks. It has also been deployed in many a production environment over the past year.
  • Track: Tools
    Jeff Mace, Neil Armitage
    Database environments are becoming increasingly complex with data being stored in many servers and datacenters.
  • Track: Cloud and Virtualization
    Beginner
    Neil Armitage
    Database deployments are getting increasingly complex spanning AWS, Openstack and on-premise datacenters. Before cloud solutions became available and reliable most deployments were carried out in private datacenters which had carefully configured hardware and network environments. In the cloud servers are deployed in minutes with very little consideration to where they are and how the networks... [read more]
  • Track: Database Administration
    Advanced
    Marco "The Grinch" Tusa, Aleksandr Kuzminsky
    Transform the nightmare of data loss to a success, implementing data recovery procedure and using the Percona data recovery tool. We will analyze and illustrate the procedure, tips and tricks to recover InnoDB data in case like: - data file corruption - incidental DROP TABLE, DELETE, TRUNCATE, or UPDATE - delete of a data file We will cover: 1) Scenario definition 2) What is Percona... [read more]
  • Intermediate
    Peter Boros, Kenny Gryp
    How do you ensure your database will scale as traffic increases? More importantly, how will you ensure your application will scale as traffic increases? What does "scale" even mean in today’s world? Why is testing important? Let’s discuss what factors you need to take into account when you talk scale and try to "future-proof" your application. We will discuss the tools... [read more]
  • Tara Bruckert
    This is a chance to discuss MySQL replication experiences, lessons learned, and tips and tricks.
  • Track: Tools
    Beginner
    Gavin Towey
    We present two open source tools developed at Box that are simple to use and very powerful: Anemometer is a query performance tracking tool which leverages Percona's pt-query-digest tool to help gather detailed query execution data, and them provides a drop-dead simple interface for analyzing and reporting on that data. It allows you to monitor performance across many individual database... [read more]
  • Track: MySQL & NoSQL
    Intermediate
    Zburivsky Danil
    Hadoop is gaining popularity as an integration point for various data sources inside a company. Hadoop's scalability properties and batch-oriented architecture also make it a great candidate for a data warehousing solution. In this session we will review a practical use case for building a Hadoop data warehouse and using MySQL as one of the data sources. There are many challenges... [read more]
  • Intermediate
    Art van Scheppingen
    More than two years ago Spil Games started building a global cross datacenter storage solution with MySQL as one its key components. This session will focus on our road to get there and share some of the best practices we got out of this. To give our users the best experience possible we needed to expand our datacenters globally and bring sharded data closer to our end users using a storage... [read more]
  • Track: Tools
    Beginner
    Sam Lambert
    Companies solve the problems of deployment, continuous integration and server provisioning with various tools under the banner of DevOps. In this talk I will explore how we do this at GitHub without anything labelled “DevOps”, just clear communication channels and a friendly robot named Hubot (http://hubot.github.com/). MySQL is the database of choice at GitHub and I will explain how we use... [read more]
  • Track: Tools
    Intermediate
    Shlomi Noach
    This session introduces the common_schema project: a self contained schema which leverages the DBA and the developer capabilities through a set of sophisticated views, routines and a specialized scripting language (QueryScript), simplifying MySQL server administration and analysis. common_schema is aimed to be imported onto any MySQL server, on any platform. Along with INFORMATION_SCHEMA and... [read more]
  • Track: Database Administration
    Intermediate
    George Lorch
    Percona Server now has several features that allow a server owner to limit the actions of a connected user (even root) and enhances the manageability of a hosted server instance. In this talk I will cover some of the new options and techniques used to manage a server instance within the cloud.
  • Track: Database Administration
    Intermediate
    Jay Edwards
    Continuous Delivery has become a best practice for automating and improving the process of software delivery. Automated testing, continuous integration and continuous deployment are mandatory skills for releasing software rapidly with minimal risk and optimal recoverability. The process of managing change in database environments has proven to be a challenge, causing lag in organizations'... [read more]
  • Track: Developing Applications
    Intermediate
    Alexander Rubin
    Geo enabled (or location enabled) applications are very common nowadays and many of them use MySQL. The common tasks for such applications are: * Find all point of interests (i.e. coffee shops) around (i.e. 10 miles radius) the given location (latitude and longitude). * Find a ZIP code (US Postal Address) for the given location or determine if this location is within the given area.
  • Track: Developing Applications
    Intermediate
    Nicolai Plum
    Booking.com is one of the largest hotel and accommodation reservation websites in the world. We have used new hardware, software, and MySQL features to build databases for our dynamic website that give 10x improvement over established database architectures. This talk will describe how Booking.com has implemented data materialisation techniques using MySQL to support a high-volume high-... [read more]
  • Track: Utilizing Hardware
    Doug Rollins
    You probably know SSDs can provide a great boost for mySQL applications, but maybe you’re hesitating because you’ve heard some worrisome stories about early wearout and failure. In reality, SSDs are a lot more predictable than hard drives, but operating an effective storage setup with Flash memory isn’t always just plug-and-play. Understanding how SSDs wear over time can help you avoid costly... [read more]
  • Track: Developing Applications
    Baron Schwartz
    Google's Go language is increasingly popular for systems programming. It's efficient and fun to program in Go, and it produces high-performance programs. Go is well suited for working with SQL databases, and has excellent MySQL drivers. In this talk Baron will show how to use Go's database/sql package with MySQL. He'll discuss idiomatic database/sql code, available drivers for... [read more]
  • Track: Replication and High Availability Strategies
    Beginner
    Bob Burgess
    Do you need to set up replication for MySQL? Afraid that it'll take hours or it's just not worth the trouble? Got it going but seeing weird errors? This presentation plainly describes MySQL replication in just enough depth then shows you how to get it running. Typical replication failures and fixes are discussed also. Replication can seem complicated if you haven't set it up... [read more]
  • Advanced
    Carl Olofson
    Relational database technology first emerged at a time when most databases served batch-oriented back-end applications such as accounting and sales management. As time has passed, the relational database management system (RDBMS) has been expected to provide online transaction support and data warehouse management, driving client/server applications on RISC systems and PCs. Moving first to the... [read more]
  • Track: Tools
    Varun Singh, Craig Thayer
    The MySQL community has led database innovation with scale out, but issues with downtime and performance still keep many MySQL environments below enterprise-grade status. This session focuses on new technologies to serve mission-critical applications – how to stay “live” during planned and unplanned outages and boost performance with deep SQL analytics.
  • Intermediate
    Tim Callaghan
    Are you running MySQL to the outer edge of it's performance capabilities or do you wish you were? - How did you do it? - Were there any trade-offs? - Lessons learned? Attendees of this BoF session should be willing to share their real-world experiences in getting the most out of their MySQL servers (inserts, updates, deletes, queries, replication performance, etc.). This isn't... [read more]
  • Intermediate
    Brian Biskeborn
    Many of Google's advertising services have historically been backed by MySQL. Over the last several years, we have migrated several of these systems to F1, a hybrid database that combines easy scaling with the strong consistency guarantees and usability of traditional SQL databases. F1 is built on the Spanner storage system, which provides synchronous wide-area replication and dynamic... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Sunny Gleason
    Fast failover is not just an option for building reliable systems in the cloud - it is a requirement. Unfortunately, it seems like every storage solution out there (whether it's SQL or NoSQL) has its own proprietary monitoring and failover mechanism. In this presentation, we explore ZooKeeper as a mechanism for fast, application-driven failover for both MySQL and Redis in the cloud. By using... [read more]
  • Track: New Features
    Intermediate
    Laurynas Biveinis
    This session will describe the fast incremental backup feature, that is available in Percona XtraBackup when used with Percona Server. Regular incremental backups necessitate full data file scans, constraining the backup frequency/scheduling. To support fast incremental backups, Percona Server has implemented a feature--redo log tracking--that writes out changed... [read more]
  • Track: New Features
    Dhananjoy Das
    Learn how the upcoming convergence of volatile and non-volatile memory infrastructure is creating software interfaces that dramatically improve the performance and reliability of applications. This session will focus on compression improvements in innodb/XtraDB optimized for flash using these native flash interfaces. Get the capacity benefits of compression, without incurring the performance... [read more]
  • Track: MySQL & NoSQL
    Intermediate
    MC Brown, Linas Virbalas
    Getting data into Hadoop is not difficult, but it is complex if what yo want to do is load 'live' or semi-live data into your Hadoop cluster from your MySQL databases. There are plenty of solutions available, from manually dumping and loading to the good and bad sides of using a tool like Sqoop. Neither are easy and both prone to the problems of lag between the moment you perform the... [read more]
  • Track: Replication and High Availability Strategies
    Beginner
    Seppo Jaakola
    Galera Cluster for MySQL is a revolutionary step forward in MySQL high-availability. It provides synchronous, multi-master, active-active clustering for InnoDB. No longer do you have to make tradeoffs between data integrity/durability and failover time, nor do you have to accept a performance hit because you need high-availability. Galera Cluster version 3 was released in November 2013 and... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Yves Trudeau
    Geographical disaster recovery (geo-DR), insuring the continuity of service after a large scale event like an earthquake or a hurricane has always been a challenge for databases and MySQL is not exception. This talk will explore how geo-DR can be achieved with technologies in the MySQL ecosystems like: - MySQL replication - Galera Replication - NDB cluster - Tungsten - DRBD or SAN... [read more]

Pages

Subscribe to Proposed Sessions