Whether you’re working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should always have a backup. As a Production DBA you’re the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way to recover should the worst happen and the database becomes irreparable. Failing to... [read more]
Track: Database AdministrationIntermediateBen Mildren, Andrew Moore
Track: Cloud and Virtualization-Simone Brunozzi
This session will focus on DynamoDB, a fast, scalable, durable NoSQL service by AWS.
We will explore the basic concepts of designing a Database on DynamoDB, and why its features are important for real world scenarios.
It will be a technical session, and some basic knowledge of NoSQL concepts is strongly recommended.
Some of the examples will be in Python language, but... [read more]
Track: Best Practices for Businesses-Torben Mathiasen
Nearly 20 years after MySQL entered the market, the legacy of open source systems it inspired, along with its LAMP counterparts, has finally taken hold. In recent years, more companies than ever are taking advantage of open source software and hardware – especially in hyperscale environments. Performance gains achieved through recent innovations have helped prove open source can beat closed,... [read more]
Track: Best Practices for BusinessesIntermediateRaj Bains, Ken Kwan
Businesses that can make superior decisions in real-time are going to beat their competition. This is the primary challenge and opportunity of analytics.
An example of this is in the online advertising market, where companies must choose and serve the best ads in milliseconds. This requires running analytics on the latest data in the primary database, while it's running transactions.... [read more]
Track: Database AdministrationIntermediateAlexander Rubin
Tuning Queries and Schema/Indexes can significantly increase performance of your application and decrease response times.
For example (assuming appropriate hardware and MySQL configuration):
1. Additional my.cnf tuning (after the initial tuning): 10% performance increase
2. Schema, indexes and query tuning: up to 1000% (or even more) response time increase
In this... [read more]
Track: Developing ApplicationsIntermediatePeter 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... [read more]
Track: Replication and High Availability Strategies-Sumeet Sheokand
An approach to maintaining 100% availability in the event of cloud or datacenter outages, through the use of multi-regional, master-master MySQL with automated healing. Talk will include technical overview of architecture, step-by-step guide to installation and configuration and live demonstration, followed by a question and answer session.
Track: Best Practices for Businesses-Ryan Huddleston
A reliable backup and recovery system can be the difference between a minor outage and the end of a business. But what if you don’t have the resources to adequately address this critical need? Join Ryan Huddleston, Percona’s Director of Remote DBA services, as he shares how Percona’s Remote DBA service is helping customers prevent disaster scenarios by performing reliable backups, in addition... [read more]
Track: Developing ApplicationsIntermediateIvan Zoratti
When we talk about Big Data, we usually think "Hadoop". Hadoop is in fact a great technology to handle Big Data, but MySQL can also be used to manage a vast amount of structured data - that is, "structured Big Data".
Track: Trends in Architecture and DesignBeginnerMatt Aslett
The popular understanding of Eric Brewer's CAP Theorem is that in distributed systems it is only possible to support two out of three desired properties: consistency, availability and partition tolerance. The 'two out of three' explanation of CAP Theorem has been used in recent years to explain and justify the emergence of NoSQL databases that relax consistency in favour of high availability.... [read more]
Track: Replication and High Availability StrategiesIntermediateCase Study: Designing a synchronous multi-master cluster for elastic scale-out and scale-in in the cloudMarco Tusa
In this talk we present a real customer case that included a challenging Architecture Design and Proof of Concept of using Synchronous Replication in AWS.
The customer had asked to investigate and design an upgrade to their MySQL based solution that supports an application serving retail shops around the globe.
The requirements were to build a highly available MySQL database using... [read more]
Track: Utilizing HardwareBeginnerKenny 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: Utilizing HardwareIntermediatePeter Zaitsev
In this session you'll learn about the three primary storage technologies commonly used for MySQL: RAID arrays of conventional disks, solid-state (flash) drives, and enterprise SAN/NAS storage. You'll learn the distinctive strengths and weaknesses of each for particular access paths such as random and sequential I/O or writes versus reads, and what types of workloads in MySQL demand high... [read more]
Track: ToolsIntermediateShlomi 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.
common_schema is aimed to be imported onto any MySQL server, on any platform. Along with INFORMATION_SCHEMA and PERFORMANCE_SCHEMA, common_schema becomes... [read more]
Track: ToolsIntermediateTim Callaghan
Throughout my career I’ve 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 all my... [read more]
Track: ToolsBeginnerJens Bollmann
Do you need a MySQL Server environment including High Availability for testing or QA or even for providing a test platform for your customer? You have to set up that kind of environment quite frequently because you cannot afford to have the hardware available all the time?
Cloud providers can help you to get the servers you need, even cost effective as you only pay for the time you use... [read more]
Track: Developing ApplicationsIntermediateJohn Goulah
There comes a point in your company’s lifetime when you’ve outgrown the ability to refresh your development database from production because you have accumulated so much data over time. At some point replicating that dataset becomes much too cumbersome and inconvenient to reproduce in your development environment. Either the dataset has become too large for the development setup or the... [read more]
Track: ToolsAdvancedAleksandr Kuzminsky
Three things are certain: death, taxes, and lost data.InnoDB files and formats Data recovery toolkit: new and old features Data-loss scenarios: first-aid actions... [read more]
Fortunately it's often possible to salvage the data after many kinds of accidents.
The session explains how data is organized in InnoDB and what actually happens in possible data-loss scenarios.
The agenda is:
Track: Replication and High Availability StrategiesIntermediateFrancisco Bordenave
Replication is a powerful feature of MySQL that makes it possible to bring up copies of a master database for different purposes: backups, high availability, scaling, and so on. One of the greatest benefits of MySQL Replication is simplicity. It is easy to set up and maintain, but why do so many DBAs out there struggle with replication errors, trying to fix data discrepancies between master... [read more]
Track: Replication and High Availability StrategiesIntermediateMassimiliano Pinto, Mark Riddoch
How can you create a template for deploying a Highly Available database in the Amazon EC2 Cloud? How can you get redundancy and automated failover, all based on standard Open Source components?
The solution describes how to use Pacemaker and Corosync for control, and how to use Elastic IP address, Elastic Block Storage and EC2 Linux instances in Amazon.
With the template, you... [read more]
Track: Cloud and Virtualization-Cashton Coleman
ClearDB operates its database-as-a-service in various cloud environments, and it’s also the technology that powers MySQL services in Microsoft’s Windows Azure. Cloud environments are highly dynamic by nature, and each cloud presents its own unique challenges to achieving and maintaining MySQL high availability. Cashton Coleman, founder and CEO of ClearDB, will outline key considerations for... [read more]
Track: Replication and High Availability StrategiesIntermediateRyan Lowe, Fernando Ipar, Marcos Albe, Randy Wigginton
Distributed transaction support is one of the most interesting, yet underutilized, aspects of MySQL. This session will begin with a discussion of the nature of distributed transactions as well as their failure points and cover some common roll-your-own solutions. We'll finish by implementing a distributed money-transfer system using MySQL XA. Attendees of this talk will be able to identify... [read more]
Track: Utilizing HardwareBeginnerJustin Swanhart
Amazon EC2 and other cloud providers now provide large machines with SSD disks. But is one big server with lots of very fast storage the best option for queries that have to access large volumes of data (OLAP)? The large server is limited to 64GB and MySQL queries are single threaded. Perhaps spreading your data over eight 17.1GB servers might cost the same(or less) and perform significantly... [read more]
Track: Replication and High Availability StrategiesIntermediateGrant McAlister
The last thing as a DBA you want to see is a database failing to start or a query failing to complete due to corruption. In this session we will describe the differences between logical and physical corruption in MySQL and show how to best protect your MySQL database from both types of corruption. We will also cover how to detect if you have corruption in your database and how to recover from... [read more]
Track: ToolsAdvancedEsen Sagynov
If you ask companies who operate mission-critical services, they will tell:
1) that a relational database system is still the best choice for mission-critical data;
2) that service availability is more important than performance;
3) that high performance is good, but predictable performance is the king.
This is a fact, and we know it. At NHN we have over 30,000 Web... [read more]
Track: New FeaturesAdvancedIgor Babaev
The talk is devoted to the module that introduces engine independent
statistical tables into MariaDB and to the new perspectives that it
opens for the optimizer to improve query execution plans for different
engines. The module itself and the additions to the optimizer that allow
to use extended statistical data when looking for optimal query
execution plans are... [read more]
Track: Database AdministrationBeginnerRonald Bradford
Determining the Query Execution Plan (QEP) of an SQL statement is the primary analysis tool for DBAs. Understanding how to interpret the information from the EXPLAIN command and what additional commands and tools exist to add supplementary information are essential skills that will be used daily in production operations.
The MySQL EXPLAIN QEP is significantly different from an Oracle... [read more]
Track: Developing ApplicationsIntermediateBill Karwin
Designing an extensible, flexible schema that supports user customization is a common requirement, but it's easy to paint yourself into a corner.
Track: Replication and High Availability StrategiesIntermediateMassimo Brignoli, Henrik Ingo
Building a High-Availability database system is hard. It's not enough to just provide a pair of redundant servers, you also need to make the data redundant, while protecting data integrity. A long standing discussion item in this context is the difficulty of implementing the failover. Should you use automated failover or is it wiser to use manual failover? If you use an active-active cluster... [read more]
Track: ToolsIntermediateGeorge Lorch
Percona XtraBackup now has several features that allow for the parallel execution of data export, compression and encryption. I will explain the best ways to use the various XtraBackup features in order to get the ideal performance curve for your application.
Track: Best Practices for BusinessesIntermediateJohan Andersson, Ibrahim Hamouda
Sphinx Information Technologies Inc. is a global network solutions and hosting provider with presence and hosting facilities in Canada, the US and Egypt.
One of Sphinx’s clients is a global leader in providing Compliance Management Solutions to help customers streamline contractor and supplier management and supply chain processes. Their solutions automate the collection and monitoring... [read more]
Track: Replication and High Availability StrategiesBeginnerSeppo Jaakola
Galera Cluster for MySQL is a revolutionary step forward in MySQL high-availability. It provides synchronous, multi-maste, active-active clustering for InnoDB. No longer do you have to make tradeoffs between data integrity/durability and failover time, nor do you have to accept a performance hit because you need high-availability.
In this session we learn:What is synchronous multi-... [read more]
Track: Replication and High Availability StrategiesBeginnerNeil Armitage
Tungsten replicator (http://tungsten-replicator.org) is a high performance, open source, data replication engine for MySQL that is a drop in replacement for standard MySQL replication. It can provide many solutions for many different replication scenarios to solve todays increasingly complex replication problems. In this session we will coverWhat is it How does it differ from Native... [read more]
Track: Best Practices for BusinessesIntermediatePeter Zaitsev
Goal Driven Performance Optimization is a powerful method of performance analysis and optimization that focuses on delivering the results you need for maximum efficiency in application performance.
We will start with an introduction to performance metrics that correspond to the end user's take on system performance. We will look into what to measure and how to measure it.
Once... [read more]
Track: Trends in Architecture and DesignIntermediateKen Ashcraft
Google Cloud SQL is a MySQL database that lives in Google's cloud. It was released by Google a little over a year ago, and as you would expect, has been continuously improved and enhanced in that time. Learn the latest on Cloud SQL, and see a glimpse of its future
- The latest automatic replication options
- More on scalability and sharding
- New... [read more]
Track: Trends in Architecture and DesignIntermediateOri Herrnstadt
Google Spanner was mainly built because the most important system at Google, Google AdWords, had accumulated Terabytes of data on MySQL. It is a well known fact that Google has always trusted and relied on a relational database to power the system that generated more than 90% of Google’s revenue. When the amount of data grew, Google developed something called “schematized, semi-relational... [read more]
Track: Replication and High Availability StrategiesIntermediateMax Mether
Achieving High Availability with MySQL is a tricky thing; there are almost as many recipes as there are cooks out there. This talk will go through the most common solutions for achieving HA with MySQL and list the pros and cons for each of them. The solutions include standard replication (includinng new features in MySQL 5.6 and MariaDB 10), MHA, Continuent Tungsten, Galera based solutions,... [read more]
Track: Cloud and Virtualization-Edward Archibald
Amazon RDS provides a simple starting point for running MySQL in Amazon AWS. Ironically, because it is so simple RDS has limitations that make it a less than ideal choice for business critical applications.
Continuent’s Tungsten is database-as-a-service (DBaaS) solution that offers an open and transparent approach to providing a highly available and scalable database service.... [read more]
Track: Replication and High Availability StrategiesIntermediateDomas Mituzas
Facebook social graph persists in multiple datacenters - and replicating it all around has been a performance challenge and bottleneck.
This talk covers field experiences of having high throughput replication requirements while serving massive scale and load environment.
From various naive prefetching methods to:Faker & InnoDB Fake Changes Multi-instance replication... [read more]
Track: Developing ApplicationsBeginnerBill 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.