Sessions

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.

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.

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 :)

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.

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!

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.

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?

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.

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.

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.

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.

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.

-

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.

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