Sessions

  • Beginner
    Will Gunty, Lisa Phillips, Tom Krouper, Chuck Sumner, Jonah Berquist
    Ever wonder how your tweets are managed and stored? The @TwitterDBA Team will give you some insight in this high level overview of MySQL usage at Twitter. We will talk about both the large scale and small scale clusters and some of the unique situations that we face. This short presentation will be followed by a Q&A Panel with a number of the Twitter DBA's.
  • Track: Database Administration
    Beginner
    Johan Andersson
    The MySQL Cluster 7.x series introduced a number of features to allow for fine-grained control over the real-time behaviour of the NDB storage engine. New threads have been introduced, and users are able to control placement of these threads, as well as locking the memory such that no swapping occurs. In an ideal runtime environment, CPUs handling data node threads will not execute other threads... [read more]
  • Track: Database Administration
    Intermediate
    Shlomi Noach
    This session exposes tools and techniques used at Outbrain to manage its MySQL servers, bridging the gaps between our Developers, DBAs and Ops. We will present how we: - Automate MySQL instance deployments - Get and use online info on our servers inventory & hardware - Deploy & propagate schema changes to our various environments - Ship logs (slow, audit) to central analysis tools... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Yves Trudeau
    Building a highly-available MySQL cluster with automatic failover based on replication has always been quite challenging but there are now a few solutions that can deal with task and Percona replication manager (PRM) is one of them. The first part of this talk will introduce the principle of operation of PRM and how it integrates with Pacemaker, the Linux-HA resource manager. Some more... [read more]
  • Track: Utilizing Hardware
    Intermediate
    Peter Boros, Bart Trojanowski
    Memory Channel Storage (MCS) is the fastest flash technology tested thus far. In this joint session with Diablo Technologies, we will discuss the performance characteristics of MCS and detail its underlying architecture. We will also discuss best practices for deployment with Percona Server and demonstrate that MCS eliminates the MySQL storage bottlenecks faced by pre-existing PCI-express based... [read more]
  • Track: Developing Applications
    Advanced
    Bill Karwin
    This is a step by step demonstration of methods of complex query development and optimization in MySQL 5.6. When presented with a complex problem, developers struggle to solve it in SQL. Let's face it, a declarative language is powerful, but it can be difficult to visualize the best solutions. Let's get into several common types of queries that developers struggle with, showing... [read more]
  • Track: Database Administration
    Intermediate
    Ernie Souhrada
    Unauthorized disclosure of sensitive data can translate into anything from a black eye in the press to millions of dollars in fines, lost revenue, and damage control, but far too often, database security is something of an afterthought. Too many people are content to firewall their database server from the Internet and, believing that the perimeter is secure, ignore some very real... [read more]
  • Track: Database Administration
    Beginner
    David Hunsinger
    Are you still running a huge monolithic 5.0 MySQL database in production? Afraid of upgrading? Intended for inexperienced DBAs, this talk will chart the path we took at LeadRocket to upgrade our production instances from Percona 5.0 to 5.5. In the process we had to deal with conversion of a near-terabyte 5.0 innodb database to file-per-table, we discovered the effect of non-deterministic queries... [read more]
  • Sean Chighizola
    Join Sean Chighizola, Senior Director of Database Administration at Big Fish Games as he talks about the value of private clouds and the challenges with cost, management and interoperability between private cloud and employer managed data centers.  Sean will share his unique perspective on how OpenStack was leveraged for server provisioning and trends in the private cloud space.
  • Track: Developing Applications
    Intermediate
    Roland Bouman
    MySQLv8Udfs provides a number of MySQL UDFs that integrate Google's v8 JavaScript engine into MySQL. With mysqlv8udfs you can run JavaScript directly in the database. MySQLv8udfs provides UDFs that are closely modeled on top of the MySQL's UDF interface. Features provided by the UDF interface are fully scriptable in JavaScript while the scripting layer provides considerable extra... [read more]
  • Beginner
    Ignacio Nin
    Your outsourced devolopers in Añata-Kubapay, Østër SSR sent in Жак Шит and your db didn't get it right? Did the description for this talk even get saved correctly?? Let's take a look at preparing your DB and application for weird input, collation and related issues.
  • Intermediate
    Przemysław Malkowski
    MySQL 5.6.10 was released as GA back in February, 2013. It means that by the time conference starts many users will have more than a year of real production use experience with this latest and greatest release in MySQL new history. During this BOF session I'd like to discuss specific use cases that demonstrate the impact of new MySQL 5.6 features in InnoDB, Replication and Optimizer, real... [read more]
  • Track: Database Administration
    Beginner
    David Turner, Ben Black
    Whether adding indexes, altering enums, changing datatypes or reorganizing tables - there are right and wrong ways when production is involved. In this session, we will go over common operations implemented in production, discuss their impacts, and appropriate strategies for minimizing downtime and customer impact to systems. * Fast operations including index adds and enum list changes (and... [read more]
  • Boris Renski
    Join Mirantis Co­Founder and Chief Marketing Officer as well as OpenStack Foundation Board Member Boris Renski as he reveals how organizations contributing to this great open source community are finding ways to both cooperate and compete. OpenStack users and contributing organizations will benefit from Boris shedding light on OpenStack co­opetition politics, sharing his views on the strategies... [read more]
  • Track: Cloud and Virtualization
    Beginner
    Vipul Sabhaya, Michael Basnight, Patrick Galbraith
    Trove is now an officially incubated Openstack Project. It has become the standard Openstack implementation for Database as a Service in the Cloud. Trove has become the approved API and implementation for provisioning and managing both relational and non-relational databases in Openstack deployments. Since the previous Percona conference, we've attracted many more contributors, added... [read more]
  • Track: Database Administration
    Intermediate
    Giuseppe Maxia
    Partitioning is a feature of MySQL that has been around since version 5.1. It is a method of improving database speed beyond the limits of indexes and available memory. When used appropriately, it can increase performance by several orders of magnitude. Amid some doubts, it was overshadowed by more flamboyant features in MYSQL 5.5.
  • Daniel Nichter
    Discuss Percona Cloud Tools (https://cloud.percona.com) with its development team.
  • Track: Best Practices for Businesses
    Beginner
    Laurynas Biveinis
    Percona Server 5.6 has now been GA for over six months and it has proven to be a real game changer for us. The release of Percona Server 5.6 (our enhanced, drop-in replacement for MySQL) not only provides stability and performance but also provides key features only available in Oracle’s MySQL 5.6 Enterprise Edition.
  • Alexey Kopytov, Laurynas Biveinis
    Discuss all topics related to Percona Server and Percona XtraBackup with members of the development team.
  • Track: Tools
    Advanced
    Ashwin Nellore, Xiang Rao
    At Yahoo, we deal with managing a massive number of MySQL databases. In order to identify and respond to performance issues with databases, we rely on an extremely lightweight and robust web based tool to look at our entire database infrastructure setup to proactively monitor our systems. It continuously gathers most important MySQL performance metrics and provides powerful visualization tools... [read more]
  • Track: Database Administration
    Intermediate
    Yoshinori Matsunobu
    If you have thousands or tens of thousands of MySQL instances, performance monitoring becomes more difficult. You need to determine meaningful performance indicators and monitor them properly. In this session, the speaker will describe how he monitors performance at Facebook. At least the following topics will be covered. * what kinds of metrics are meaningful and what are not * read/... [read more]
  • Track: Database Administration
    Intermediate
    Patrick Coffre, Robert Morris
    Most modern ETL tools have the same basic parts. They all contain ways to manage data sources and formats, and they all allow you to define data flows. One important difference is how different tools perform the final, most critical part: reliable execution of those data flows, in both test and production environments. Some ETL tools are engine based, where information about the data flow is... [read more]
  • Track: Utilizing Hardware
    Beginner
    Peter Boros
    This session will be about benchmarking MySQL and disk IO subsystems with sysbench and interpreting the results. In our consulting practice, I helped a reasonable number of customers with sysbench, so this way I know the common caveats more people run into. The talk will cover benchmarking IO subsystems with the fileio test, as well as benchmarking MySQL.
  • Ian Gulliver
    Revelations from the Snowden files about the NSA’s interception of long-haul fiber traffic[1] were met by some with stunned disbelief and by others with blasé “I told you so”. Google responded publicly by encrypting inter-datacenter traffic[2], deploying additional user-facing encryption[3] and encouraging others to do so[4]. MySQL at Google hasn’t escaped our push for better protection of our... [read more]
  • Track: Best Practices for Businesses
    Intermediate
    Matthew Lang
    For either compliance, ethical reasons, or both, businesses are required to protect confidential data in their mysql databases. At Modernizing Medicine, we are obsessive about protecting patient data. With respect to MySQL, this session will address how we encrypt data at rest with filesystem based encryption, data in transit using the latest version of Continuent Tungsten Enterprise, which... [read more]
  • Track: Tools
    Intermediate
    René Cannaò
    There are excellent Enterprise softwares that are able to scale out and boost performances of a cluster, but none open source. ProxySQL is a new proxy (currently under development) that aims to become the first open source proxy in the MySQL ecosystem able to provide HA and high performance with no changes in the application, using several built-in features and integration with clustering... [read more]
  • Track: Tools
    Intermediate
    Ryan Lowe, Randy Wigginton
    MySQL DBAs often hold the keys to the kingdom in terms of being able to accurately mine business data in order to produce actionable intelligence. Many MySQL DBAs, however, lack the tools to generate graphs, charts, and other visually compelling evidence based on the data mined. The purpose of this presentation is to give the attendees that tool. R is a software environment for statistical... [read more]
  • Tomas Ulin
    Join Oracle Vice President of MySQL Engineering Tomas Ulin to learn about the latest news and developments. You will find out how Oracle keeps raising the bar for MySQL, delivering constant innovations and enhancements to the community.
  • Track: Cloud and Virtualization
    Intermediate
    Laine Campbell
    Amazon's RDS is a useful tool for numerous use-cases. It offers ease of management, the chance to avoid "rolling your own" MySQL infrastructure and already built-in HA. For seasoned DBAs, there are numerous ways in which one might expect these systems to behave and yet, do not. As with any system, one must know the details in order to successfully leverage its value. In this... [read more]
  • Beginner
    In the world of replication, The Binlog is every ones favorite. But what about the Relay log, Don't you feel it can do more ? Yes, It can. How about, if it can serve the purpose of the GTID feature without GTID.
  • Track: Developing Applications
    Intermediate
    Rick James
    A fast-paced list of one-liners -- MySQL Tips, RoTs, Hints, and Best Practice. These are distilled from watching MySQL users -- from newbies to experts -- successfully (or unsuccessfully) tune, create schemas, write queries, and try to optimize. Some you already know; some you have been wondering about; and some will surprise you. Topics covered: PXC Gotchas, SELECTs-do's & don... [read more]
  • Michael Basnight, Amrith Kumar
    Tired of producing yet another database server/cluster for your customer? This BOF session will focus on Trove, OpenStack Database as a Service, and its related components. Do you have questions, about Trove? Bring them along. This session will cover topics such as installation/operation, the future vision for Trove, and how you can help guide the future roadmap. Talk to people who are running... [read more]
  • Track: Best Practices for Businesses
    Intermediate
    Calvin Sun, Inaam Rana, Liang Guo
    MySQL is the data storage technology behind most Twitter data: the social graph, timelines, users, direct messages, as well as tweets themselves. With more than 200 million monthly active users and 500 million tweets per day, Twitter pushes MySQL and InnoDB a lot further than most companies. This talk will cover the data storage architecture at Twitter and how the architecture has evolved to meet... [read more]
  • Advanced
    Rick James
    Performance sags in when the data gets large. This lightning talk discusses 3 classic use cases that suffer this way, then discusses how adding a carefully designed table can take you from meltdown to smooth sailing.
  • Track: Database Administration
    Intermediate
    David Busby
    Covering why selective grants are important to protect against certain attack vectors. Why user passwords need to be complex. Deploying SELinux in targeted enforcing mode; and how to not be afraid of it. Performance implications of deploying selinux. Why it's important to deploy and properly configure selinux. 1) Why rigid grants are important. 2) Why password complexity is... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Mats Kindahl
    MySQL Fabric is an open-source solution released by the MySQL Engineering team at Oracle. It make management of farms of MySQL servers easy and available for both applications with small and large number of servers. In order to provide resilience to failures, MySQL Fabric organizes the servers in groups and deploys high-availability solutions within each group. The concept is independent... [read more]
  • Beginner
    Domas Mituzas
    While lots of industry are obsessed about Big Data - analysis of vast amounts of records, there's no less interesting effort to actually build systems that power transaction processing for huge scale systems. Managing small data at scale involves careful thinking about algorithms, efficiency and performance - a system that is too fast may be also too expensive, a system that is too slow... [read more]
  • Track: Cloud and Virtualization
    Intermediate
    Andrew Shieh
    SmugMug spent six years split between its data centers and Amazon Web Services, using the data centers to host Percona MySQL DBs. Find out how and why SmugMug went 100% AWS, migrating 30TB of databases, hundreds of front ends, load balancing, and caches, across the US in one night with zero downtime. I'll show you specific techniques that made our large-scale database migration a... [read more]
  • Track: Tools
    Beginner
    Daniel Nichter
    Percona Toolkit is a collection of more then 30 command-line tools for MySQL that automate a variety of MySQL and system tasks. With so many choices, it can be difficult knowing where to start: is pt-archiver safe? what is the relationship between pt-table-checksum and pt-table-sync? how does pt-online-schema-change work? etc. This session will survey 9 of the most popular tools in Percona... [read more]
  • Intermediate
    Art van Scheppingen
    Slave prefetchers can speed up replication but only work within very limited boundaries. As Domas described it two years ago: "Please don’t use mk-slave-prefetch on MySQL unless you are Facebook. Or at least don’t tell your friends, so they won’t use it." We are not Facebook, but we certainly like to stand in their shadow! Besides that we were suffering from slave lag on a slave that... [read more]

Pages

Subscribe to Proposed Sessions