Percona Live MySQL Conference & Expo 2015
2015-04-13..2015-04-16
Santa Clara, United States
as the organisers put it
Percona Live represents Percona’s flagship industry event and most visible platform for engaging customers, prospects, partners, and the open-source database community.
| title | author | length |
|---|---|---|
| MySQL replication setup, benefits, limitations | Rick Golba, Stephane Combaudon | 53m |
Covers concrete MySQL replication mechanics and tradeoffs: enable log_bin and unique server_id, create a replication user, run SHOW MASTER STATUS, use CHANGE… | ||
| Deploying MySQL HA with Ansible and Vagrant | Daniel Guzman Burgos, Robert Barabas | 41m |
A repeatable lab deploys a two‑node MySQL master/slave setup using Vagrant + VirtualBox and Ansible playbooks; inventory groups, roles and templated configs… | ||
| MySQL Indexing Best Practices | Peter Zaitsev | 47m |
Explains how MySQL uses B+tree-style indexes (point lookups, open/closed ranges, ORDER BY) and why InnoDB’s clustered primary key matters; shows when… | ||
| MySQL & InnoDB Fundamentals and Configuration | Justin Swanhart, Michael Coburn | 36m |
Compares MyISAM and InnoDB with concrete tuning: MyISAM uses table locks and OS file cache so use it only for noncritical read-mostly replicas; InnoDB is ACID… | ||
| Is Percona XtraDB Cluster Right for Any Application | Stephane Combaudon, Peter Boros | 38m |
Percona XtraDB Cluster uses Galera to provide synchronous replication and automatic provisioning; it requires InnoDB tables with primary keys and converts… | ||
| Running MySQL on AWS | Michael Coburn | 29m |
Compares running MySQL on EC2 versus RDS with concrete trade-offs: EC2 gives shell access, raw EBS block devices, full backup and recovery tools and use of… | ||
| Hardening MySQL: MySQL Security Basics - MySQL security Tutorial | David Busby | 20m |
Argues that compromise is inevitable and emphasizes damage limitation by isolating the DB, removing unnecessary packages (no Samba, BluetoothD), and fixing… | ||
| Writing High Performance SQL Statements | Tim Sharp | 21m |
Walkthrough of practical steps for faster MySQL queries: use EXPLAIN type/possible_keys/key/rows to see that adding an index turns a table scan of ~200 rows… | ||
| Overview of MySQL Connectors for PHP | Justin Swanhart | 16m |
Compares actual PHP MySQL runtime options and APIs, showing that mysqlnd vs libmysqlclient matters (mysqlnd becomes default in PHP 5.4; 5.3 can emit header… | ||
| Character set and collation basics | Justin Swanhart | 15m |
Explains that single-byte charsets cap at 256 characters and that MySQL’s historical utf8 is 3-byte (no CJK or emoji) while utf8mb4 uses 4 bytes, so… | ||
| Using MySQL asynchronous calls to increase performance and user experience | Alexander Rubin | 17m |
MySQL 5.6 still limits one query, one CPU core, so splitting heavy queries into parallel pieces using bash threads or PHP asynchronous calls runs many queries… | ||
| SQL injection - What is it and how do I prevent it? | Justin Swanhart | 24m |
Explains that SQL injection happens when user input like "1 OR 1=1" is interpolated into queries and demonstrates fixes: prepared statements and parameter… | ||
| MySQL and OpenStack | Peter Boros | 22m |
MySQL serves as the metadata store for Nova, Neutron, Keystone, Glance and Cinder and is commonly deployed as Percona XtraDB Cluster or MariaDB Galera to get… | ||
| Percona Server for MySQL Advantage | Michael Coburn, Christopher Jeffus | 24m |
Percona Server is an enhanced drop‑in MySQL replacement that claims measurable gains: changing the InnoDB redo log block from 512 to 4KB InnoDB log block… | ||
| Becoming a DBA for 5 minutes a day, the most important things to know for sysadmins and developers | Martin Arrieta | 28m |
Checklist of concrete fixes and diagnostics: update old MySQL versions, stop running with default configs, set innodb_buffer_pool_size correctly, disable query… | ||
| Using MySQL with Java | David Bennett | 34m |
JDBC is the standard Java-to-SQL interface and Connector/J exposes roughly 200 tunable parameters (he counts exactly 200) to tweak caching, debugging and… | ||
| MySQL Query tuning 101 | Sveta Smirnova, Alexander Rubin | 31m |
Download slides: https://www.percona.com/live/mysql-conference-2015/sessions/mysql-query-tuning-101
Join Sveta Smirnova Percona, Alexander Rubin Percona as… | ||
| Introduction to TokuDB storage engine for large data sets | Peter Zaitsev | 28m |
Percona reports TokuDB as a production-ready MySQL/MariaDB engine offering fractal tree compression that gives higher compression ratios with low CPU overhead… | ||
| How to create a useful MySQL bug report | Valerii Kravchuk | 27m |
Explains how to find prior reports on bugs.mysql.com and vendor trackers, what exact fields to include (OS and kernel, MySQL version, error log and stack… | ||
| Stay ahead of MySQL operational problems with Percona Toolkit and PMP plugins | Daniel Guzman Burgos | 28m |
Percona Toolkit version 2.2.14 bundles command-line tools that diagnose and prevent real operational failures: pt-stalk collects OS and MySQL samples and can… | ||
| Designing Effective Schema for Innodb | Yves Trudeau | 31m |
Practical, actionable rules for InnoDB schema: keep a large buffer pool and use file-per-table; store UUIDs as VARBINARY(36) not CHAR(36) (CHAR(36) with utf8… | ||
| Highly Efficient backups with Percona Xtrabackup | Nilnandan Joshi, Valerii Kravchuk | 31m |
Percona XtraBackup performs physical hot backups by copying InnoDB data files and redo logs and then requiring a prepare step to apply those logs for a… | ||
| MySQL backups strategy, tools, recovery scenarios | Akshay Suryawanshi, Roman Vynar | 45m |
Download slides: https://www.percona.com/live/mysql-conference-2015/sessions/mysql-backups-strategy-tools-recovery-scenarios
Join Akshay Suryawanshi and… | ||
| 7 or so deadly MySQL performance sins | Martin Arrieta | 33m |
Seven common MySQL mistakes with concrete fixes: over‑allocating per‑session buffers causes memory blowouts and the OOM killer, calculate RAM as… | ||
| nothing matches | ||