The Percona Live Birds of a Feather (BOF) sessions are Wednesday night, April 2, from 6 to 7 pm.

  • Track: High Availability
  • None
  • Robert Hodges
    None
    MySQL is now a grown-up enterprise DBMS with grown-up enterprise problems. How is MySQL adapting to the world of corporate data centers with their requirements for seamless high availability, analytics, security, and integration with other DBMS types? We'll look at the big technology trends, see where MySQL fits in today, and make fearless predictions for the future.
  • Tomas Ulin
    None
    Join Oracle Vice President of MySQL Engineering Tomas Ulin to learn how MySQL just keeps getting better, representing an ideal platform for your next generation Web, cloud and embedded applications. Tomas will review the latest news for the MySQL Database, MySQL Cluster, MySQL Workbench… and more.
  • Peter Zaitsev
    None
    Peter Zaitsev, CEO of Percona, will discuss the latest trends in scalability, high availability, SSDs, and the cloud and how they will impact MySQL users. Peter will also discuss the growing complexity of hybrid environments such as on premise/cloud and MySQL/NoSQL deployments. He will also offer his thoughts on the future of MySQL and the opportunities likely to emerge as a result of the ever... [read more]
  • Alexey Yurchenko
    None
    What is synchronous replication? For many it is just the same as asynchronous, only safer and slower. But is it all that is to that? (At this point you're probably guessing "no?") In this talk Alex will ponder eternal questions: what is "synchronous"? is it "replication"? and how new MySQL server UUIDs are relevant to that?
  • Track: High Availability
    Rares Mirica
    Orchard 1
    In modern web application development, a lot of effort goes into isolating critical parts, getting rid of dependency and single points of failure and achieving the best load balancing. The scalability challenges surrounding this effort are non-trivial and we will touch on them as we describe the problems and solutions employed at Booking.com. The tools we’ve build enable our internal services... [read more]
  • Track: High Availability
    Yoshinori Matsunobu, santosh banda
    Orchard 1
    In this session, we will present about our enhancements and deployments for reducing MySQL server downtime dramatically at Facebook -- by fast master failover without data loss. There are a couple of well-known fast master failover solutions like mysqlfailover/MHA. In addition to that, we started using Semi-Synchronous replication to achieve failover without dataloss. To make failover work at... [read more]
  • Track: Programming
    Andrew Hutchings
    Orchard 1
    libAttachSQL is a new lightweight async C connector library for MySQL being developed from scratch by HP's Advanced Technology Group. It is Apache2 licensed and aims to make it easy for the general community to contribute to and use. The API for libAttachSQL has been designed to be clean and easy to use. It uses a polling based method of communicating instead of a blocking approach.
  • Track: DevOps
    Ben Mildren
    Orchard 1
    This talk will provide an overview of ansible, and how it can be used to automate and manage deployments. We will review how it compares to other software such as puppet, chef, and salt, and will discuss both the positives and negatives of the software. We will use a combination of Vagrant and Virtualbox (using a custom wrapper https://github.com/bmildren/vagrant_wrapper) to provide practical... [read more]
  • Track: DevOps
    Shlomo Priymak
    Orchard 1
    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 automation systems, and hear a few war stories.
  • Track: High Availability
    Frederic Descamps, Kenny Gryp
    Orchard 1
    -- This is a full day tutorial -- Percona XtraDB Cluster is a high availability and high scalability solution for MySQL clustering. Percona XtraDB Cluster integrates Percona Server with the Galera synchronous replication library in a single product package which enables you to create a cost-effective MySQL cluster. This tutorial will cover the following topics: - Migration from standard... [read more]
  • Track: High Availability
    Frederic Descamps, Kenny Gryp
    Orchard 1
    -- This is a full day tutorial -- Percona XtraDB Cluster is a high availability and high scalability solution for MySQL clustering. Percona XtraDB Cluster integrates Percona Server with the Galera synchronous replication library in a single product package which enables you to create a cost-effective MySQL cluster. This tutorial will cover the following topics: - Migration from standard... [read more]
  • Track: Performance Optimization
    Dimitri KRAVTCHUK
    Orchard 2
    This session will be interesting for anyone who cares about making MySQL fly. Published MySQL benchmark results always engender a lot of discussions and a lot of misunderstandings. Some benchmark workloads are helping understand and fix MySQL performance issues, but others, some of which are running MySQL, are not testing it at all. So the goal of this session is to clarify all these points,... [read more]
  • Track: Performance Optimization
    Bill Karwin
    Orchard 2
    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: Performance Optimization
    Mark Leith
    Orchard 2
    The Performance Schema feature is an amazing resource for runtime instrumentation within MySQL. A lot of information is available, but sometimes it is hard to distill. The new MySQL sys schema builds on both the performance_schema and INFORMATION_SCHEMA databases, exposing a set of views, functions, and procedures modelled directly for many day-to-day administrator tasks, using the wealth of... [read more]
  • Track: Performance Optimization
    Tim Callaghan
    Orchard 2
    Throughout my 25 year career I’ve been responsible for maintaining the performance of database applications and therefore created many benchmark “frameworks”. At Tokutek, an important part of my role is measuring the performance of our storage engine over time and versus competing solutions. There is nothing proprietary about what I’ve created, it can be used anywhere. The presentation covers... [read more]
  • Track: Performance Optimization
    Jaime Crespo
    Orchard 2
    Last year I presented some of the changes in the MySQL 5.6 Optimizer that made the latest version of MySQL faster for those developers that knew how to take advantage of them, and also reviewed some of the more traditional and basic techniques on how to improve the performance of your applications (http://www.percona.com/live/london-2013/sessions/query-optimization-mysql-56-old-and-new-tricks... [read more]
  • Track: Security
    David Busby
    Orchard 2
    Security isn’t deploying some overbearing big brother of a hardware or software solution; it’s not running scanning software which tells you you’re safe; because in reality in these type of setups you’re not. Security is akin to high availability you deploying multiple redundancies to ensure you can still operate, the same can and should be applied to security; identify the potential areas of... [read more]
  • Track: Performance Optimization
    René Cannaò
    Orchard 2
    It is essential to understand how your system performs at different workloads to measure the impacts of changes and growth and to understand how those impacts will manifest. Measuring the performance of current workloads is not trivial and the creation of a staging environment where different workloads need to be tested has it's own set of challenges. Performing capacity planning, exploring... [read more]
  • Track: Security
    Jeremy Glick, Andrew Moore
    Orchard 2
    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: MySQL and NoSQL
    MC Brown, Robert Hodges
    Sentosa 5-8
    There are many different choices available to you for your analytical database needs. Some of these you can use without moving from your existing environment. Others require some thought and technology to make it easy to move the data to where you need it. For example, you can use a separate MySQL server to act as a specialized interface to your data through replication, or you can load or... [read more]
  • Track: What's new in MySQL
    Sergei Golubchik
    Sentosa 5-8
    It's easy to understand that an SQL optimizer needs to know something about the data to be able to create a good query execution plan. But since the early days of MySQL history and up until MariaDB 10.0 all the optimizer could ever know about the content of your tables was the index cardinality, just one single number per index to describe all your rows. And it even knowing that little it... [read more]
  • Track: Replication & Backup
    Abdel-Mawla Gharieb
    Sentosa 5-8
    Dear MySQL Community, I proposed a talk to Percona Live London 2014 which will be mainly about GTID replication, how to implement and troubleshoot it.
  • Track: Replication & Backup
    Jean-François Gagné
    Sentosa 5-8
    At Booking.com, we are adding new components to our replication architecture: Binlog Servers. Those will allow us to reach extreme number of slaves replicating from a single master (greater than 100 slaves and growing). We think that people having more modest replication installations can also benefit from Binlog Server as they ease high availability deployment and simplify remote site... [read more]
  • Track: What's new in MySQL
    Yoshinori Matsunobu
    Sentosa 5-8
    Facebook has deployed MySQL 5.6 on all production environments and has continued to add features to bring improvements. This session explains 5.6 best practices at Facebook; lessons learned; and major feature enhancements such as faster full table scan and online defrag. It also presents an overview of Facebook’s recent move to WebScaleSQL and future plans for that project.
  • Track: Replication & Backup
    Marcelo Altmann
    Sentosa 5-8
    This talk is about the strategy we use to backup MySQL databases at IEDR. Every day we backup our database, distributing the backup to a different data center. Other part of the strategy is to verify that the backup taken is a good backup and can be used in case we need to restore. For faster restore, we archive a copy of the datadir (its faster then restore from MySQL dump). To continue the... [read more]
  • Track: High Availability
    Beginner
    sri vishnu chanderraju
    Sentosa 5-8
    MySQL Cluster is a technology providing shared-nothing clustering & auto-sharding for the MySQL database management system. This will be a hands on tutorial on the MySQL Cluster - its concepts and usage. In this tutorial, we will be covering the following aspects: 1) basic overview of the architecture 2) setup/ installation 3) Disaster scenarios 4) Some Application level tips /... [read more]
  • Track: What's new in MySQL
    Luis Soares, Andrew Morgan
    Sentosa 5-8
    Continuing in the footsteps of its predecessor, MySQL 5.7 is set be a groundbreaking release. In this session, the engineers behind the product provide insight into what is in the latest 5.7 development milestone release and also in the labs. The next generation of replication features covers several technical areas such as better semisynchronous replication, an enhanced multithreaded slave (per-... [read more]
  • Track: MySQL Case Studies
    Luis Motta Campos
    Cromwell 1 & 2
    The ebay Classifieds Group is a conglomerate of business units competing locally on the Online Classifieds Ads business in 23 countries around the world. We consider Online Classifieds to be a local business, and we strive to have business owners, developers, and site operations engineers in every country where we run business. Most of this businesses start too small to be able to afford... [read more]
  • Track: Replication & Backup
    Roman Vynar, Akshay Suryawanshi
    Cromwell 1 & 2
    This is a hands-on tutotial on setting up the different types of MySQL backups for your production systems and recovering from various disasters. Topics and tasks to be covered: * Planning, strategies and tools for MySQL backups * Replica as a backup and ensuring the replication consistency * Role of the delayed slaves * Binary backups with Percona XtraBackup and mylvmbackup * Logical... [read more]
  • Track: MySQL in the Cloud
    Baron Schwartz
    Cromwell 1 & 2
    Relational databases aren't very well suited to time-series data in some ways, but MySQL is powerful and flexible. At VividCortex, we have found that it's a good storage engine to support a large-scale, high-velocity time-series database in the AWS cloud. In this session we'll discuss our unique time-series data requirements. We'll explain how we built a solution using MySQL... [read more]
  • Track: Programming
    Kenny Gryp
    Cromwell 1 & 2
    This talk will give an overview of the different available Java MySQL connectors (Connector/J, MariaDB Java Connector) and connection pools (Commons-DBCP, C3P0, ...). One of the things with the default configuration of these solutions is that they are very chatty. This can have a noticeable impact on application performance and database load. I've seen many environments where over 50% of... [read more]
  • Track: MySQL Case Studies
    Grant Allen
    Cromwell 1 & 2
    There have been many approaches over the years to solving MySQL replication bottlenecks, all with their pro's and con's. With the release of MariaDB 10, we now have available the parallel replication option, allowing replication slaves to massively increase their throughput. But what are the costs? How far can you push group commit techniques before you start to question your data... [read more]
  • Track: MySQL Case Studies
    Walter Heck
    Cromwell 1 & 2
    The story of how we moved an environment from mariadb 5.3 with mmm to galera with pxc. The cluster uses haproxy as a load balancer, is fully puppetised and consists out of 4 powerful physical servers. In the session we outline the approach we designed and executed to move the whole cluster from mmm to pxc without downtime.
  • Track: MySQL in the Cloud
    Colin Charles
    Cromwell 1 & 2
    Today you can use hosted MySQL/MariaDB/Percona Server in several "cloud providers" in what is considered using it as a service, a database as a service (DBaaS). Learn the differences, the access methods, and the level of control you have for the various public cloud offerings: - Amazon RDS - Google Cloud SQL - HPCloud DBaaS - Rackspace OpenStack DBaaS The administration tools and... [read more]
  • Track: MySQL Case Studies
    Art van Scheppingen
    Cromwell 1 & 2
    At Spil Games we have been using Sphinx for over five years now. At first we used it to offload full text search queries to our MySQL databases, but one year ago we started to use it in a different way: we now serve out any page to any of our 26M daily active users dynamically. This means on every visitor for every pageview he/she makes we will make at least one invocation to Sphinx Search. This... [read more]
  • Track: Performance Optimization
    Chris Giard, John Cesario, Ryan Lowe
    Cromwell 1 & 2
    How do you go about tuning a database when you have lots of knobs to turn? How do you know when you've succeeded? We will take a large server with a relatively stock MySQL configuration and go through the steps to tune the hardware, OS, and MySQL, pointing out what types of tools you'll want, what order you should tackle things, and how to verify your results. We will also be deep... [read more]
  • Seppo Jaakola
    Cromwell 3 & 4
    Galera Cluster for MySQL is a revolutionary step forward in MySQL high availability. It provides synchronous, multimaster, active-active clustering for InnoDB. No longer do you have to make trade-offs 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]
  • Robert Hodges, Matthew Lang
    Cromwell 3 & 4
    Users seeking high availability, disaster recovery and zero downtime maintenance operation for business-critical MySQL applications face confusing choices. Is multi-master or master/slave clustering better? What about synchronous versus asynchronous replication? Using a plain vanilla, stock MySQL or a modified version of it?
  • Track: MySQL and NoSQL
    Zburivsky Danil
    Cromwell 3 & 4
    Low-latency SQL is the Holy Grail of Hadoop platforms, enabling new use cases and better insights. A number of open-source projects have sprung up to provide fast SQL querying; which one is best for your cluster? This session will present results of our in-depth research and benchmarks of Facebook Presto, Cloudera Impala and Databricks Shark. We look at performance across multiple storage... [read more]
  • Track: MySQL Case Studies
    René Cannaò, Miklos Szel, Alkin Tezuysal
    Cromwell 3 & 4
    In this hands on lab, the speakers will walk through evaluation of operational errors and issues in MySQL 5.6, and recovering from them. This will be a hands-on workshop where possible. Specific items that cannot easily be reproduced will be done via Amazon/EC2 and screencast. 1. Instance Crashes and Hangs - * Evaluating error logs and troubleshooting methodologies. * Determining issues (... [read more]
  • Track: Replication & Backup
    Derek Downey
    Cromwell 3 & 4
    For a long time, replication in MySQL was limited to only a single master. When MariaDB 10.0 became GA, the ability to allow multiple masters became a reality. This has opened up the door to previously impossible architectures. For instance, you can now have a single replica receive changes from any number of sources to use for analytics or as a one-stop backup of a sharded environment. In... [read more]
  • TBD
    Cromwell 3 & 4
  • TBD
    Cromwell 3 & 4