Tutorials

Monday 8:00AM-9:00AM

@ Main Lobby

Registration in Main Lobby

Monday 9:00AM-12:00PM

@ Tutorial: Field Suite

Michael Coburn - Percona

This is a hands-on tutorial covering how to set up monitoring for MySQL database servers using the Percona Monitoring and Management (PMM) platform.

PMM is an open-source collection of tools for managing and monitoring MySQL and MongoDB performance. It provides thorough time-based analysis for database servers to ensure that they work as efficiently as possible.

You will learn about:
- The best practices on MySQL monitoring
- Metrics and time series
- Data collection, management and visualization tools
- Monitoring deployment
- How to use graphs to spot performance issues
- Query analytics
- Alerts
- Trending and capacity planning
- How to monitor HA

Please bring a laptop with the Virtualbox application.


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 9:00AM-12:00PM

@ Tutorial: Goldsmith 1

Rene Cannao - ProxySQL

ProxySQL is an open source proxy for MySQL that is able to provide HA and high performance with no changes in the application, using several built-in features and integration with clustering software. Those are only a few of the features you'll learn about in this hands on tutorial.


MySQL / MariaDBOpen Source Databases
 Experience: Intermediate
Developer, Operations

Monday 9:00AM-12:00PM

@ Tutorial: Goldsmith 2

Tim Vaillancourt - Percona

Are you a seasoned MySQL DBA that needs to add MongoDB to your skills? Are you used to managing a small environment that runs well, but want to know what you might not know yet?

MongoDB works well, but when it has issues, the number one question is "where should I go to solve a problem?" This tutorial will cover:

Understanding the MongoDB logs
Understanding the Server Status output, including various engine types
Using the "currentOp" command
Using operationProfiling (i.e.: the database profiler)
Troubleshooting a query plan
Recommended tools for parsing profiler and logs
Performance monitoring recommendations
Maintenance recommendations for replica sets
Maintenance recommendations for sharding
Picking the right shard key
Debugging shard balancing problems
Changes to the sharding system in MongoDB 3.4
Benchmark and load replaying tools
Choosing a storage engine
Choosing a backup method
Backup process best practices and tooling


MongoDB
 Experience: Percona
Developer, Operations

Monday 9:00AM-12:00PM

@ Tutorial: Goldsmith 3

Giuseppe Maxia - VMware

Running database operations in containers is a slightly different proposition than running other services. MySQL, being designed - as the majority of services - for running in a dedicated host, needs some adjusting to fit in a container. Thanks to its configurability, we can deploy MySQL containers to fit our purposes, with just the right amount of customization. However, customizing in Docker is done differently, and we will see it in detail. This tutorial will cover :
* Operations from scratch, starting with running a single container;
* Steps and pitfalls of customising containers;
* Data management for safety and performance;
* Making several containers work together in complex topologies;
* Using containers as software transporters: mixing MySQL versions and operating systems.

Attendees to this tutorial will learn the basics of using MySQL containers stand-alone, in regular and group replication.


MySQL / MariaDB
 Experience: Intermediate
Developer

Monday 9:00AM-12:00PM

@ Tutorial: Pearse Boardroom

Dimitri Vanoverbeke - Percona, Tom Decooman - Percona

Do you want to get more familiar with how to become a MySQL DBA?

Are you a developer familiar with writing applications that use MySQL, but feel a bit limited on how to manage a MySQL database?

This full day tutorial will be mainly hands-on. We'll show some slides on each of the various topics presented, but the goal is to have YOU the student work in a MySQL environment as much as possible.

What will we cover? Almost every aspect of being a MySQL DBA, based on MySQL 5.7:
- We will install MySQL and configure the right privileges for your system
- Once we have a database running, we need to better understand what our database is doing. We will explain and look at the different possible diagnostics and monitoring options in MySQL
- We will troubleshoot issues
- Not losing any data is an important goal for a MySQL DBA, so we will discuss and try some of the different backup options
- We will clarify replication options
- We will look at how you check consistency in between your servers


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 9:00AM-12:00PM

@ Tutorial: Sky Suite

Abbas Ahmed - Rentalcars.com

We at Rentalcars.com have been using Couchabase since 2013. In this tutorial, I will show how it works and how you can perform various administrative operations without any downtime.

The tutorial will be a hands on lab, carried out in a VirtualBox environment, sources for which will be provided at the beginning of the tutorial. Attendees will be expected to be equipped with a laptop that is running a 64-bit OS.

The session will be laid out like this:
1. Concept of an Engagement Database
2. Couchbase Architecture Overview
3. Planning a new cluster
4. Installing a new Cluster.
5. Expanding an existing Cluster
6. Multi-Dimensional Scaling
7. Designating specific roles to nodes.
8. Data Modelling & Working with Data
9. Creating Map-Reduce Views
10. Working with N1QL, the SQL super-set for Couchbase
11. Troubleshooting Exercises


Open Source Databases
 Experience: Beginner
Business / Case Studies, Operations

Monday 9:00AM-12:00PM

@ Tutorial: Swift Suite

Tibor Korocz - Percona, Alex Poritskiy - Percona

Never used Percona XtraDB Cluster before? Come join this half-day tutorial where we will introduce you to the concepts of a fully functional Percona XtraDB Cluster.

In this tutorial we are going to show you how can you install Percona XtraDB Cluster with ProxySQL and monitor it with PMM.

We will also cover topics like bootstrap, IST, SST, Certification, common-failure situations and online schema changes.

This entire tutorial is extremely hands on. We will supply instances for you to work with on your own laptop. You will be executing all the commands along with your instructors to gain first-hand experience.


MySQL / MariaDB
 Experience: Beginner
Developer, Operations

Monday 12:00PM-1:30PM

Lunch

Monday 1:30PM-4:30PM

@ Tutorial: Field Suite

Philipp Krenn - Elastic

How to use the Elastic Stack (previously called ELK Stack) to monitor logs is widely known. But it can also give you a complete picture of your MongoDB installation:

* System metrics: Keep track of network traffic and system load.
* Logs: Collect and parse MongoDB logs.
* MongoDB metrics: Gather the most relevant attributes with the dedicated Metricbeat module.
* Queries: Monitor your queries on the wire with Packetbeat.

And we will do all of that together since it is so easy and quick to set up.


MongoDB
 Experience: Intermediate
Developer, Operations

Monday 1:30PM-4:30PM

@ Tutorial: Goldsmith 1

Shlomi Noach - GitHub

Orchestrator is a MySQL topology manager and a failover solution, used in production on many large MySQL installments. It allows for detecting, querying and refactoring complex replication topologies, and provides reliable failure detection and intelligent recovery & promotion.

This tutorial walks through Orchestrator's setup, deployment and usage best practices. We will focus on major functionality points and share authoritative advice on practical production use.

Our cheat sheet covers:

- Detection: resolving, classification, pools, inspection.
- Topologies: Pseudo GTID, refactoring, querying for info.
- Failovers: configuration, promotion preferences, hooks, downtime, acknowledgements, planned failovers.
- Scripting: putting-it-all-together use case for automating failover tests.
- HA: Making orchestrator highly available, including recent consensus development.

This tutorial will be hands off, and open to discussion and examples by/for the attendees.


MySQL / MariaDB
 Experience: Intermediate
Developer

Monday 1:30PM-4:30PM

@ Tutorial: Goldsmith 2

Colin Charles - Percona, Ronald Bradford - Pythian

This tutorial provides a detailed roadmap for defining and implementing appropriate MySQL security for your data center and cloud environments. It will help you understand the options for and capabilities of authentication, encryption, key management and auditing in MySQL/Percona Server for MySQL/MariaDB/RDS and their variants.

This talk covers:

- A security primer
- The available ANSI and MySQL constructs
- The evolution of defaults in MySQL Versions
- Basic security hardening
- Reviewing authentication modules
- Better/Stronger/Harder passwords
- Encryption options for variants Percona Server for MySQL, MariaDB, MySQL Enterprise including LUKS, ezcrypt, gazzang
- Key management options
- Practical OS security (user accounts, sudo, iptables/ufw, SELinux/AppArmor)
- Why auditing is important
- Understanding the role of clouds, containers and compliance


MySQL / MariaDB
 Experience: Intermediate
Business / Case Studies, Operations

Monday 1:30PM-4:30PM

@ Tutorial: Goldsmith 3

Peter Zaitsev - Percona

InnoDB is the most commonly used storage engine for MySQL and Percona Server for MySQL. It is the focus of most of the storage engine development by the MySQL and Percona Server for MySQL development teams.

In this tutorial, we will look at the InnoDB architecture, including new feature developments for InnoDB in MySQL 5.7 and Percona Server for MySQL 5.7. We will explain how to use InnoDB in your database environment to get the best application performance and provide specific advice on server configuration, schema design, application architecture and hardware choices.

This tutorial has been updated from previous versions to cover new MySQL 5.7 and Percona Server for MySQL 5.7 InnoDB features.


MySQL / MariaDBOpen Source Databases
 Experience: Beginner
Operations

Monday 1:30PM-4:30PM

@ Tutorial: Pearse Boardroom

Dimitri Vanoverbeke - Percona, Tom Decooman - Percona

Do you want to get more familiar with how to become a MySQL DBA?

Are you a developer familiar with writing applications that use MySQL, but feel a bit limited on how to manage a MySQL database?

This full day tutorial will be mainly hands-on. We'll show some slides on each of the various topics presented, but the goal is to have YOU the student work in a MySQL environment as much as possible.

What will we cover? Almost every aspect of being a MySQL DBA, based on MySQL 5.7:
- We will install MySQL and configure the right privileges for your system
- Once we have a database running, we need to better understand what our database is doing. We will explain and look at the different possible diagnostics and monitoring options in MySQL
- We will troubleshoot issues
- Not losing any data is an important goal for a MySQL DBA, so we will discuss and try some of the different backup options
- We will clarify replication options
- We will look at how you check consistency in between your servers


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 1:30PM-4:30PM

@ Tutorial: Sky Suite

Jason Terpko - ObjectRocket, Antonios Giannopoulos - ObjectRocket

This tutorial will guide you through the many considerations when deploying a sharded cluster. We will cover the services that make up a sharded cluster, configuration recommendations for these services, shard key selection, use cases, and how data is managed within a sharded cluster. Maintaining a sharded cluster also has its challenges. We will review these challenges and how you can prevent them with proper design or ways to resolve them if they exist today. There will be lab sessions at the end of some chapters so please have your laptops with you.


MongoDB
 Experience: Intermediate
Developer, Operations

Monday 1:30PM-4:30PM

@ Tutorial: Swift Suite

Frederic Descamps - Oracle, Kenny Gryp - Percona

During this tutorial, attendees will get their hands on virtual machines and migrate standard Master - Slave architecture to the new MySQL InnoDB Cluster (native Group Replication) with minimal down time. After explaining what group replication is and how it works (the magic behind it), we will experiment with multiple use cases to understand MySQL Group Replication. We will also get the attendees more comfortable with this new technology.

During our experiments, we will try to:
- Cleanly stop a node
- Kill a node
- Re-join a node
- Produce conflicts and see how the cluster behaves
- Create data inconsistency
- Recover from full cluster outage

And finally, we will check how we can integrate MySQL InnoDB Cluster with external routing solutions like ProxySQL. We will also see how to use what the cluster exposes to performance_schema and sys schema to make the right choice.


MySQL / MariaDB
 Experience: Beginner
Operations

Monday 5:00PM-7:00PM

Welcome Reception

Percona Live

Percona Live Europe starts in:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA