Sessions

  • Nisha Talagala
    As a non volatile memory, flash is revolutionizing data center architectures, improving application performance by bridging the gap between DRAM and disk. Future non volatile memories promise performance even closer to DRAM. While flash adoption first established a foothold as a disk replacement, data center architectures are now evolving to take advantage of flash as a new memory tier in both... [read more]
  • Intermediate
    Doron Levari
    There are several options to address MySQL performance and scalability issues. Doing it yourself, with “homegrown” sharding is typically labor intensive and often requires multiple application changes. Accordingly, this is neither CAPEX effective nor OPEX efficient. Upgrading the hardware (SSDs/CPU/memory) is a short term fix and will only buy time - not solving the actual problem. Moving to... [read more]
  • Track: MySQL & NoSQL
    Intermediate
    Tamar Bercovici
    Over the past several years, NoSQL databases have become a fundamental component of modern web architecture. These stripped-down simplified data-stores built for web-scale from the ground up have proven to be extremely useful, and are successfully deployed at virtually all of today's leading web companies. Many in the web community have heralded the arrival of NoSQL as the death of... [read more]
  • Track: Database Administration
    Beginner
    Geoffrey Anderson
    "We're hiring!" How many times have you heard this phrase at a conference? Every database-driven company is hiring and that makes for pretty stiff competition when trying to get a new DBA. Instead of searching for the perfect database administrator from a conference or Linkedin, why not look internally at your organization for system administrators or engineers who may be an... [read more]
  • Beginner
    David Stokes
    'Truncating Sub Optimal DBA Verbal Responses Vectors' or 'things a DBA should not say' is a guide to help DBAs squelch their first 'gut' response to common user inquiries. For instance a coworker may initiate a dialog with a simple simple statement to ascertain or test knowledge such as 'Is the database up?' wherein they are attempting to understand the... [read more]
  • Track: Database Administration
    Intermediate
    Shlomo Priymak
    Facebook has one of the largest MySQL database clusters in the world, comprising thousands of servers across multiple data centers. Operating a cluster of this size requires automating most of what a conventional MySQL Database Administrator (DBA) might do, so that the cluster can almost run itself. Learn about the design and architecture of our robo-DBA, written in Python, plus a few war stories...
  • Intermediate
    Rick James
    You are combining your logs to find out how many _different_ users have connected. This, itself, is somewhat I/O intensive. But then add to that the desire to rollup daily "uniques", into "weekly" uniques. But you find that SUM(), etc, won't work. I will outline a way to store data at less than one bit per unique user, and do rollups.
  • Track: MySQL & NoSQL
    Intermediate
    Robert Hodges, Tim Callaghan
    Cassandra is a widely used NoSQL DBMS that offers advanced replication, built-in HA, and column-family organization. At first glance it seems radically different. Is Cassandra a replacement for MySQL or is it something entirely new? Tim and Robert will set out to prove that even though Cassandra looks very different on top, underneath it depends on many principles you already know from MySQL.... [read more]
  • Track: MySQL & NoSQL
    Intermediate
    Tim Callaghan, Robert Hodges
    MongoDB is a popular NoSQL DBMS that shares the ease-of-use and quick setup that made MySQL famous. But is MongoDB really up to the job? Is it right for your applications? If you understand MySQL well, you know how database systems work. In this talk we will demonstrate how to lean on your knowledge of topics like schema design, query optimization, indexing, sharding, and high availability to... [read more]
  • Track: Cloud and Virtualization
    Intermediate
    Laine Campbell
    Laine will explain the options for running MySQL at high volumes at Amazon Web Services, exploring options around database as a service, hosted instances/storages and all appropriate availability, performance and provisioning considerations using real-world examples from Call of Duty, Obama for America and many more. Laine will show how to build highly available, manageable and performant MySQL... [read more]
  • Track: Tools
    Beginner
    Daniel Nichter
    Do you have MySQL slaves? Are all slaves' data in sync with the master? How can you check? -- "Yes", "I think so", and "I don't know" are very common responses to these questions. MySQL has no intrinsic way to verify that slaves have the same data as the master. This is a problem because it is very common for slaves to become out of sync with the master.
  • Track: Replication and High Availability Strategies
    Advanced
    Robert Hodges
    MySQL high availability in the cloud is not your father's HA problem. Compute instances come and go like will-o-the-wisps, and Amazon in particular has a proven potential for massive failures that take down entire regions. In this talk we'll walk through the HA challenges of Amazon Web Services and OpenStack, then evaluate the current state of popular MySQL solutions to handle them.... [read more]
  • Track: Database Administration
    Intermediate
    Tim Goodaire, Tim Chadwick
    “There’s something wrong with the database” is the phrase that is sure to strike some combination of fear, panic, and doubt into the heart of any DBA. This usually triggers a flurry of squinting at graphs, grepping through log files, and arguing with developers and managers about whether the problem is even in the database. One way or another, we make it through another performance... [read more]
  • Jeremy Cole, Calvin Sun, Davi Arnaut, Steaphan Greene, Ian Gulliver
    Formed as a collaboration among engineers facing similar challenges in running MySQL at scale, WebScaleSQL was born out of a desire to achieve greater performance from a database technology tailored to their specific needs. It aims to enable the scale-oriented members of the MySQL community to work more closely together in order to prioritize the aspects that are most important to us. In the last... [read more]
  • Peter Zaitsev, Terry Erisman
    Peter Zaitsev, CEO and Co-founder of Percona, welcomes attendees to the Percona Live MySQL Conference & Expo. Peter will highlight the speakers, topics, sponsors, events, and attendees that will make the 2014 version of the conference the best yet.
  • Gillian Gunson
    This talk is going to be a list of anecdotes of bad instructions and requests that MySQL DBAs have received from developers, managers, and users. Some of these come from personal experience, and others are stories I've heard in the industry. This is a lighthearted look at some of the difficult instructions that DBAs get, with an aim of being educational as well. Each listed request will... [read more]
  • Track: Tools
    Beginner
    Neil Armitage
    We are increasingly seeing larger and larger deployments of both MySQL and application servers to support complex cloud deployments. The days of being able to install, configure and manage individual servers has gone and home brew configuration scripts build using bash, perl and ruby no longer scale to cover 100’s of nodes One of the leading configuration management solutions is Puppet and... [read more]
  • Track: New Features
    Intermediate
    Dipti Joshi
    A windowing function as defined in ANSI SQL11 performs a calculation across a set of table rows that are somehow related to the current row. The windowing functions simplify complex analytics tasks for computing cumulative, moving, centered or reporting aggregates without requiring doing sub-queries or writing stored procedures. Existing MySQL storage engines do not support this windowing... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Seppo Jaakola
    Galera Cluster is synchronous multi-master cluster, which allows clients to read and write to any cluster node, without any limitations. When two or several clients happen to write to same data element at the same time, the cluster must decide how to resolve the conflcit - the bottom line is that only one write can be accepted. Galera will resolve this by letting the first committting... [read more]
  • Track: New Features
    Advanced
    Laurynas Biveinis, Alexey Stroganov
    We will describe the inner workings of XtraDB 5.6 from the performance point of view. We will focus on the new-in-XtraDB algorithms developed by Percona for performance, supported by experimental data. We will also discuss our motivation for making these and not other changes. Thus, we will talk about the XtraDB priority locking framework, InnoDB 5.6 flushing... [read more]
  • Advanced
    prasad mani
    A familiar issue for Database Administrators is how to migrate their 24/7 mission critical application databases to new servers without any database downtime. By using the Federated storage engine and MySQL Replication techniques, it is possible to migrate large databases from one server instance to other server instance without any downtime.
  • Track: Database Administration
    Beginner
    Yves Trudeau
    These days, on Linux, MySQL typically runs on either xfs or ext4. These filesystems are great performance wise but performance is not the only requirement. For example, backups can generate a high load and take a long time to run. The ZFS filesystem offers an interesting alternative and, although ZFS was available on many OS, ZFS for Linux was only released as GA at the spring of 2013. The... [read more]

Pages

Subscribe to Proposed Sessions