Sessions

  • Track: Developing Applications
    Intermediate
    Peter Boros

    This talk is looking to fill some of the gap between the ability of reading explain output and the ability to optimize really large queries (imagine a 7 table join). I would like to discuss practical techniques through real-world practical examples, displaying common flaws, encountered throughout my work as a consultant. The talk will cover, but will not be limited to:

    - How do you start optimizing large queries.
    - Denormalization.
    - Early join, when can it help.
    - Effect of join order.
    - Range join optimization.
    - OR consitions in the query.

  • Track: Utilizing Hardware
    Intermediate
    Johan De Gelas

    Many administrators still feel that virtualizing your database is not a best practice. Tons of tips and tricks and white papers about the subject are available, but they only seem to add to the confusion.

  • Track: Best Practices for Businesses
    Intermediate
    Stephane Combaudon

    Building a robust and high-performance MySQL application is a combination of using the right techniques and avoiding the wrong ones. Learn in this presentation the most common traps that lead to bad performance, complicated architectures and waste of money when you are designing or running a MySQL application. You will then be able to scale and operate your database server.
    The following topics will be discussed: architecture, configuration, schema and indexes, queries, hardware, backup & recovery, instrumentation.

  • Track: Utilizing Hardware
    Intermediate
    Kenny Gryp

    In this session you'll learn how to choose hardware that helps MySQL execute queries the most quickly, while providing the best price-to-performance ratio. This includes choosing and configuring CPUs, RAM, network, and storage systems. We'll also discuss what performance you can expect from various Amazon EC2 instance sizes, including EBS volumes and Amazon's RDS service for MySQL.

  • Track: Tools
    Intermediate
    Shlomi Noach

    This session introduces the common_schema project: a self contained schema which includes a set of sophisticated views, routines and a specialized scripting language (QueryScript), simplifying MySQL server administration and analysis.

  • Track: Database Administration
    Intermediate
    Olivier Doucet

    This issue happened to me at work. A customer encountered max_user_connections repeatedly, and it was our duty to investigate what went wrong : if this is a problem with a query, find it and give advice to the customer, or if it's server related, fix it with minimal downtime.

    In this session, I'll explain my thoughts and my reasoning, step by step. This could give you (the audience) some ideas if you have to deal with similar issues, or just discover useful tools that would help you one day.

    Quick overview : that was (way) more difficult than just finding a sub-optimized SELECT :)

  • -
    Garry Turkington

    This presentation will describe the challenges encountered at Improve Digital as we migrate from a system based on -- and relying on -- data aggregates to one processing much larger volumes of ‘raw’ data.
    The architectural evolution we will discuss explains the changing role of the components of our system; MySQL, Postgres and Hadoop clusters and a new analytic data warehouse.
    At the design level we will explore how we partitioned data and workload across the various components and what strategies for data movement and high availability are utilised.

  • -
    Robert Hodges

    The pundits said MySQL was on the ropes after the Oracle acquisition in 2009. Far from it! Thanks to a burst of innovation and three popular builds, MySQL is an even safer bet to build 24x7 transaction processing systems. But how do you handle requirements to spread data across regions or add real-time analytics? How do you scale up to Big Data on cloud platforms? At Continuent we believe the answer is to embed off-the-shelf MySQL in "data fabrics" consisting of modular data services tied together by advanced replication.

  • Track: Replication and High Availability Strategies
    Intermediate
    Seppo Jaakola

    Galera is fundamentally new replication technology opening revolutionary possibilities for building application high availability stacks. This presentation will show how Galera can be used in various HA use cases, like synchronous master-slave or multi-master replication. And laying out deployment alternatives from running cluster in high speed LAN networks using UDP multicast, replicating over WAN network or in cloud environment.

  • Intermediate
    Grant Allen

    Google Cloud SQL is a MySQL database that lives in Google's cloud. It has all the capabilities and functionality of MySQL, with a few additional features and a few unsupported features. You'll learn how to expand your MySQL expertise to cover Google Cloud SQL, and use new features and design patterns to your advantage.

    We'll cover:

    - A diverse range of automatically managed replication options (and we mean "automatically managed"!)
    - The configuration options and settings that Google Cloud SQL manages for you, so you can stop worrying!

  • -
    Frank Terburg

    Rakuten, Inc. is one of the world’s leading Internet service companies and ranks among the top 10 Internet companies in the world. Rakuten provides a variety of consumer- and business-focused services including e-commerce, e-reading, travel, banking, securities, credit card, e-money, media and online marketing.

  • Track: Developing Applications
    Beginner
    Bill Karwin

    MySQL users commonly ask: Here's my table, what indexes do I need? Why aren't my indexes helping me? Don't indexes cause overhead? This talk gives you some practical answers, with a step by step method for finding the queries you need to optimize, and choosing the best indexes for them.

  • Track: Database Administration
    Intermediate
    Henrik Ingo

    If you are tired of managing your own cron jobs, email alerts and backup retention with a mess of various scripts then this talk is for you.

  • Track: New Features
    Beginner
    Sergei Golubchik

    MariaDB - a branch of MySQL with advanced features - is gaining popularity. It is in Linux distributions, more and more companies are using it instead of MySQL. But why should you consider MariaDB? What features does it have that makes it different from MySQL? And are these features worth the move?

  • Track: Replication and High Availability Strategies
    Intermediate
    Colin Charles

    In the third edition (2012) of High Performance MySQL, MHA usage is described as: "anyone other than Yoshinori who is using it in production, and we haven't used it ourselves." Little known to the authors, we've spent quite a lot of time working on MHA and figuring out its kinks. It has also been deployed in many a production environment.

    Learn:
    * how to get it running including files you'll have to customize
    * about virtual IP failover
    * integrating it with Pacemaker+Heartbeat+Corosync
    * getting it working on the Solaris (10 & greater) environments

  • Track: Developing Applications
    Beginner
    MC Brown

    NoSQL document databases require a different approach and direction when building your applications. The complexities of SQL and the rigid schema are replaced with flexible document design and a simpler direct data model. Building an application with NoSQL, and particularly migrating your existing SQL based application, require some changes, and not just to your application code. You need to learn to think differently about your application flow and, using the Map/Reduce built into Couchbase Server, learn the best way to query your database.

  • -
    Robert Hodges, Giuseppe Maxia

    Cross-site databases are the next challenge facing today's MySQL-based businesses. Continuent Tungsten provides multiple options for spreading data across sites, including primary/DR, multi-master, and system-of-record approaches. Learn how Continuent Tungsten enables replication, failover, and routing of transactions between sites.

    We cover the following topics:

    • Introduction to cross-site models: primary/DR, full multi-master, and system-of-record.
    • Which model is best for your applications?
    • How do you set up multiple site data management with Continuent Tungsten?

  • -
    Andrew Hutchings

    Whilst MySQL has its own connector the licensing behind this can be somewhat prohibiting. It may also not meet all the needs of the modern developer.

    This talk will go through all the MySQL compatible connectors in every language you can think of (and some you have probably never thought of). The pros/cons of each including licensing will be explained so you can pick the best one for your project.

  • Track: Database Administration
    Intermediate
    Giuseppe Maxia

    There are many recipes for achieving high availability with MySQL. One of the most powerful tools is Continuent Tungsten, which provides management and connectivity on top of asynchronous replication, giving users a transparent view of clusters. Tungsten clusters are self-healing (they can react to failure automatically and promote slaves to masters without manual input) and transparent: applications connecting to these clusters don’t need to know anything about their composition, and connection is routed to the active members in case of a failure. Tungsten clusters are also user-friendly.

  • Track: Developing Applications
    Intermediate
    Sergey Averin

    We've been using HandlerSocket in our infrastructure for 2 years here at Badoo. Badoo has extensive experience running HS in production. More and more teams in our company use HandlerSocket for their projects.

    We're currently using HandlerSocket as a Memcached replacement in some cases, as a search engine in some other cases and as a primary key-value storage for mobile & desktop applications. Our HS installation has more than 30 servers serving max. ~ 8000 RPS per server. I have written a custom HS client library for PHP including a couple of tricks and optimizations I'm going to show you.

  • Track: Database Administration
    -
    Peter Zaitsev

    MySQL's configuration file is often the focus of too much attention and too much tweaking of variables that make no difference -- or worse, have the potential to negatively impact performance. The sample default configuration files that come with MySQL are unfortunately not very helpful or good, either. You'll learn a practical approach to generate a sensible configuration file that sets what's needed and omits what isn't. The result will be a more stable and performant server that's resistant to many common problems.

  • Track: Replication and High Availability Strategies
    Intermediate
    Andrew Moore, Ben Mildren

    By now anyone running a MySQL server for something bigger then a brochure website will know that replication can afford them the ability to do some wonderful things. It's no silver bullet on it's own though. There's much to know about stock MySQL replication, from installation to security to troubleshooting it when it's not behaving itself.

  • Advanced
    Art van Scheppingen

    This session will explain how Spil Games implemented a global cross datacenter storage solution with MySQL as one of the key elements of its new architecture.

  • -
    Ivan Zoratti

    In September, SkySQL announced their very first product, the SkySQL Cloud Data Suite, or SCDS in short. This is part of a more global strategy aimed at simplifying operations with MySQL servers in terms of administration, integration and monitoring.

    Why is the SkySQL Data Suite relevant for you?
    The SkySQL Cloud Data Suite is free and open source, with commercial support on demand. Developers, DBAs and Architects can benefit from the use all or of part of the Data Suite to integrate its open source components in their own projects and applications.

  • Track: Tools
    Beginner
    Bill Karwin

    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.

  • -
    TBD

    -

  • -
    TBD

    -

  • -
    Henry Hwang

    Big Data applications overwhelm legacy database architectures. And because of that, a common assumption is that SQL doesn’t scale. The truth is, SQL isn’t the problem, it’s the legacy RDBMS’ that are.

  • Track: Database Administration
    Intermediate
    Ivan Zoratti

    The majority of the IT Managers, Systems and Database Administrators today are interested in public, private and hybrid clouds. Unfortunately, relational databases are not cloud-friendly and the deployment of MySQL in cloud infrastructures creates many new issues in terms of scalability, performance, security and integration with non-cloud infrastructures.

  • Track: Replication and High Availability Strategies
    Intermediate
    Henrik Ingo

    We will present results from benchmarking a MySQL Galera cluster under various workloads and also compare them to how other MySQL high-availability approaches perform. We will also go through the different ways you can setup Galera, some of its architectures are unique among MySQL clustering solutions.

    * MySQL Galera
    ** Synchronous multi-master clustering, what does it mean?
    ** Load balancing and other options
    ** WAN replication
    ** How split brain is handled
    ** How split brain is handled in WAN replication

    * How does it perform?
    ** In memory workload

  • Track: Best Practices for Businesses
    Intermediate
    Robert Hodges

    Integrating MySQL's reliable transaction processing with a capable data warehouse is a best practice that gives users timely and comprehensive insight into business data. In this talk we will explain how data warehouses work and why you need one. We will next survey the classes of data warehouse products that you can combine with MySQL, such as Oracle, Vertica, InfiniDB, Hadoop, and NoSQL databases like MongoDB. Finally, we will show a practical example of how to deliver transactions from MySQL to a data warehouse in real-time using Tungsten Replicator.

Subscribe to Proposed Sessions