• Track: MySQL Case Studies
    Luis Motta Campos
    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: MySQL in the Cloud
    Baron Schwartz
    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: High Availability
    Rares Mirica
    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: What's new in MySQL
    Sergei Golubchik
    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: High Availability
    Yoshinori Matsunobu, santosh banda
    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]
  • Seppo Jaakola
    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]
  • Track: Replication & Backup
    Abdel-Mawla Gharieb
    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.
  • Robert Hodges, Matthew Lang
    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: Replication & Backup
    Jean-François Gagné
    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: Programming
    Kenny Gryp
    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: Programming
    Andrew Hutchings
    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: MySQL and NoSQL
    Zburivsky Danil
    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: DevOps
    Ben Mildren
    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: MySQL Case Studies
    Grant Allen
    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
    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: What's new in MySQL
    Yoshinori Matsunobu
    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: Performance Optimization
    Dimitri KRAVTCHUK
    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: DevOps
    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 automation systems, and hear a few war stories.
  • Track: Replication & Backup
    Marcelo Altmann
    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]
  • Robert Hodges
    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.
  • Track: MySQL in the Cloud
    Colin Charles
    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: Performance Optimization
    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: What's new in MySQL
    Luis Soares, Andrew Morgan
    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: Performance Optimization
    Mark Leith
    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]
  • Tomas Ulin
    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
    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]
  • Track: Performance Optimization
    Tim Callaghan
    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]
  • Mark Filipi
    Mark Filipi, MySQL Team Lead at Pythian, 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... [read more]
  • Track: Security
    David Busby
    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: MySQL Case Studies
    Art van Scheppingen
    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]
  • Alexey Yurchenko
    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: Security
    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]
Subscribe to Proposed Sessions