The always entertaining Lightning Talks are during the Thursday night, April 3, MySQL Community Networking Reception which begins immediately following the breakout sessions.

  • 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: High Availability
    Beginner
    Vishnu Rao
    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]
  • 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.
  • 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: Performance Optimization
    René Cannaò
    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]
  • 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: 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: 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]
  • 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: Performance Optimization
    Jaime Crespo
    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: 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: High Availability
  • Track: Replication & Backup
    Derek Downey
    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]
  • 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]
  • 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?
  • 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: 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]
  • Track: MySQL and NoSQL
    MC Brown, Robert Hodges
    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]
  • Ryan Taylor
    HGST (a Western Digital Company) invented the hard disk drive. Since 1956 the company has been leading the industry with innovative storage hardware, software and solutions. Today HGST is a leading provider of HDDs and SSDs in the industry. With a focus on scale-out architectures, HGST has developed new innovations in flash and software to address master/slave consolidation and is delivering... [read more]
  • Track: What's new in MySQL
    Yoshinori Matsunobu, Rongrong Zhong
    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.
  • 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 it... [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: High Availability
    Yoshinori Matsunobu
    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: Performance Optimization
    Bill Karwin
    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]
  • 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]
  • Earle Philhower
    Consolidate your MySQL master/slave pairs by up to half and go full-flash using HGST Virident Solutions. MySQL slave replicas are a wonderful way of preserving data and service availability, but they’re also incredibly wasteful and expensive. They double the initial cost of deployments, and they’re always on burning power and heating your datacentres. HGST has developed a unique way of... [read more]
  • Track: Replication & Backup
    Roman Vynar, Akshay Suryawanshi
    This is a hands-on tutorial 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 * Ensuring the replication consistency * Role of the delayed slaves * Binary backups with Percona XtraBackup and mylvmbackup * Logical backups with mysqldump and... [read more]
  • Track: MySQL Case Studies
    Miklos Szel, Alkin Tezuysal, Nikolaos Vyzas
    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
    Abdel-Mawla Gharieb
    My talk will be mainly about GTID replication, how to implement and troubleshoot it. I'll start by explaining what is GTID passing in brief about the GTID concept and what benefits are there when using GTID instead of the classic method.
  • 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: Replication & Backup
    Frederic Descamps
    During this presentation, I will show how to implement several stuff that will improve your day-to-day workload. The points will cover topics like Point in Time Recovery, WAN replication with group segments, Avoiding SST when adding new Percona XtraDB Cluster node, ... the tips will be briefly explained to the audience and then show how to implement them. The tips covered must be known by... [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 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: High Availability
    Frederic Descamps, Kenny Gryp, Liz van Dijk
    -- 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: 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: Performance Optimization
    Peter Zaitsev
    Successful applications often become limited by MySQL Performance. In this presentation we will look how to get great MySQL Performance while being Practical - spending time on what gives us best return. We will look into the main areas where improvement to MySQL Performance can come from Hardware, MySQL Configuration, Schema & Queries, and Application Architecture outlining the most... [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: 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: 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: 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.

Pages