How can you tell if queries in your application use good query plans? And if they don't, is there any way to force the query optimizer to use a good query plan?
This tutorial aims to give an all-around answer. We will:
show how to find queries which use expensive query plans, discuss possible reasons why the optimizer can make poor query plan choices, show how to determine what... [read more]Indexing is a black art? Not really. But there are a lot of subtle issues and interactions to learn.
This tutorial presents virtually everything there is to know about indexes. It takes the "cookbook" approach of saying "this SELECT begs for this INDEX", then deep dives into "why".
This lecture moderately fast-paced. The novice will learn the basics that demystify INDEX... [read more]
Like many things in MySQL, choosing a high-availability solution for MySQL has traditionally been an exercise in tradeoffs. There are many alternatives to choose from. Many good enough - none perfect?
(Or: how to get your bugs fixed really quickly and be loved by developers)
Getting started with search is very easy. Just how hard can a LIKE '%query%' be, right? Or better yet, a CREATE FULLTEXT INDEX and then MATCH AGAINST? And to extent, that works. But these days, it's surprisingly easy to grow beyond the point where that simplistic approach does not really work any more, and you find yourself struggling to scale the performance, tweak the matching, or improve... [read more]
InnoDB is the most commonly used Storage Engine for MySQL and Percona Server and is the focus for majority of storage engine development by MySQL and Percona Server teams.
In this Tutorial, we will look at InnoDB Architecture, including new developments in MySQL 5.6 as well as Percona Server. We will explain how it should be used to get the the best performance from your application.... [read more]
For the next three hours, Palomino is going to talk about our successes and failures across a number of different AWS hosted environments. We're going to show you how to build your MySQL environment in the cloud -- how to maintain it -- how to grow it -- and how to deal with failure. Some of the specific topics we'll cover are:
1. How to choose RDS or EC2?
2. Balancing performance... [read more]
The tutorial is meant for people to gain more experience in day to day tasks to manage a MySQL Infrastructure.
Several best practises, techniques, tools will be explained and tested during this full day Tutorial.
Topics:
- Monitoring (alerting & trending)
- Backups (strategy, XtraBackup, recovery)
- Performing Schema Changes
- Security
- Identify... [read more]
The tutorial will be mainly hands on. Virtualbox images will be provided at the start of the tutorial.
Prerequisites:
- Be familiar with MySQL's basic usage (starting, stopping, basic command line tools like 'mysql', 'mysqld', 'mysqldump')
- Have some familiarity with SQL
- Be used to working with unix shells and SSH
- Have a laptop with virtualbox installed and... [read more]
Vadim is main architect of Percona XtraBackup, In this tutorial he will cover every details of XtraBackup:
- Original idea behind product
- Internal design
- Comparison with other backup solutions for MySQL
- Work principles
- Purpose of files in package
- Basic usage
- Parallel backup
- Streaming backup -
More complex usage:
*... [read more]
This tutorial will utilize laptop-based VMs to guide attendees through the basics of setup and administration of XtraDB cluster. Covered topics will be:
Migration from standard mysql to xtradb cluster Configuration differences between standard mysql and xtradb cluster Monitoring cluster node states Adding nodes to the cluster and various SST methods Setting up load balancing for... [read more]This tutorial will utilize laptop-based VMs to guide attendees through the basics of setup and administration of XtraDB cluster. Covered topics will be:
Migration from standard mysql to xtradb cluster Configuration differences between standard mysql and xtradb cluster Monitoring cluster node states Adding nodes to the cluster and various SST methods Setting up load balancing for... [read more]During this tutorial the attendees will have a hands-on experience in the installation, configuration management and tuning of MySQL Cluster. To accomplish the best operational procedures and exploit all the power of NDB, the attendees will achieve deep knowledge of architecture, implementation and design that allow MySQL Cluster to scale out and provide 99.999% availability.
VirtualBox... [read more]
Agenda:
- MySQL Cluster Concepts and Architecture: we will review the principle of a fault-tolerant shared nothing architecture, and how this is implemented into NDB;
- MySQL Cluster processes : attendees will understand the various roles and interactions between Data Nodes, API Nodes and Management Nodes;
- Installation : we will install a minimal HA solution with MySQL... [read more]
During the tutorial we're going to review the process of installing a fresh TokuDB instance on a Linux VM and go through some example use cases. We will discuss the details for upgrading from an existing MySQL installation.
We will run several operations and benchmarks to explain the differences between TokuDB and the traditional MySQL engines.
While we will provide a stock VM... [read more]
In this session we will explore the possibilities that Tungsten Replicator can provide to solve complex replication problems. 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. We will cover
The Tungsten Replicator components. Replacing standard MySQL... [read more]
