Tutorial Day - Tuesday 28 May 2019

Tuesday 9:30AM - 12:30PM

@ Hill Country A

Kenny Gryp - Oracle, Frédéric Descamps - Oracle

During this tutorial, attendees will get their hands on virtual machines and migrate standard Master-Slave architectures to the new MySQL InnoDB Cluster (native Group Replication) with minimal downtime. 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 and explain all the benefits of the new features we have introduced since 8.0.14 like the different data consistency models supported.

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

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.

We will highlight the new improvements made in MySQL 8.0 regarding Group Replication and InnoDB Cluster.


MySQL/MariaDB
 Experience: Beginner
MySQL

Tuesday 9:30AM - 12:30PM

@ Hill Country B

Avinash Vallarapu - Percona

This is the first part of a two-part tutorial session, morning and afternoon.

* This tutorial is focused on teaching PostgreSQL to professionals who are already experienced with Oracle or MySQL. As we discuss from the basics, even a beginner may adapt the concepts easily. Relational databases share a lot of similar concepts. You may find it easier if we help you relate the concepts of PostgreSQL with Oracle/MySQL. Thus, we will start with PostgreSQL Architecture for Oracle/MySQL DBAs.

* The approach we take with this tutorial is to present an overview of the PostgreSQL architecture and operation in view of MySQL's and Oracle's. We'll mix lecture with hands-on work, having the audience apply the concepts we present in practice in a lab format before covering new ones, starting with a simple and quick installation of PostgreSQL and going all the way to set up and maintain a stand by replica. By the end of the day, attendees shall walk away with a good understanding of how PostgreSQL works, and feel confident enough to try it themselves.

Here are the main points covered in this tutorial :

* Brief history of PostgreSQL and its features
* PostgreSQL Architecture for MySQL/Oracle DBAs and beginners.
* Installation of PostgreSQL
* Create/Start/Stop a PostgreSQL Cluster and the components of a Data Directory
* PostgreSQL parameters/settings you need to know
* PostgreSQL User Management
* MVCC in PostgreSQL
* VACUUM and Transaction ID Wraparound in PostgreSQL
* Types of Indexes
* EXPLAIN in PostgreSQL
* Logical and Physical Backups and PITR
* Streaming replication
* Failover
* Declarative Partitioning in PostgreSQL 10 and furthermore features in PostgreSQL 11.


PostgreSQL
 Experience: Beginner
PostgreSQL

Tuesday 9:30AM - 12:30PM

@ Hill Country C

Colin Charles - Galera Cluster

MariaDB Server 10.3 has been out for nearly a year, and MariaDB Server 10.4 is almost baked. It has many new features, some of which MySQL does not have, including system versioned tables, Oracle compatibility, a completely merged SPIDER storage engine for sharding and more. However it is also important to remember that previous releases have also gotten improvements, like having the MyRocks storage engine, DML only flashback to rollback tables/databases to an older snapshot, integrated Galera Cluster, threadpool, InnoDB defragmentation and a whole lot more.

Feature wise, it is important to know what MariaDB Server 10.3 (and 10.4 — system tables in the Aria storage engine, ability to reload SSL certificates without a restart and more!) have and what they also lack from MySQL 8.0 (group replication, the X Protocol, etc.).

Come to this tutorial to learn how MariaDB Server makes it better for the developer as well as the operations personnel, and all participants will leave more knowledgable on how to better manage, observe, and secure their MariaDB Servers. In addition, there will be a focus on High Availability as well as backups (covering Mariabackup) & disaster recovery.

Attendees will be able to:
* Upgrade their MySQL servers to MariaDB successfully.
* Learn the features that MariaDB offers beyond MySQL.
* Understand the compatibility between MariaDB and MySQL, including how applications will work and react to it.
* Learn how to harness all the new features MariaDB 10.3 comes with.
* Dive deep into the storage engines that exist and what they are used for
* Understand MariaDB Server replication options
* Develop more efficiently against features available in MariaDB Server

What will not be covered in this tutorial are: MariaDB ColumnStore, MariaDB MaxScale, and the new cloud offering.


MySQL/MariaDB
 Experience: Intermediate
MariaDB

Tuesday 9:30AM - 12:30PM

@ Hill Country D

René Cannaò - ProxySQL

There is a stigma attached to database proxies when it comes to MySQL. This tutorial hopes to blow away that stigma by showing you what can be done with a proxy designed from the ground up to be performant. That proxy is ProxySQL. In this tutorial we will not only explain how ProxySQL can make your databases (MariaDB, MySQL, Percona Server for MySQL) process more transactions than without a proxy, we will show you how you can leverage ProxySQL to pre-qualify upgrades, test the impact of schema changes, perform seamless failovers, rewrite offensive queries on the fly, and help you install and configure the proxy to manage queries.


MySQL/MariaDB
 Experience: Intermediate
MySQL

Tuesday 9:30AM - 12:30PM

@ Texas 1

Peter Zaitsev - Percona

InnoDB: What you didn't know about the storage engine that powers most of the web

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

In this tutorial, we will look at the InnoDB architecture, including new developments in MySQL 8.0 as well as Percona Server for MySQL. We will explain how InnoDB should be used to get the best performance from your application. We will provide specific advice on server configuration, schema design, application architecture, and hardware choices.


MySQL/MariaDBOpen Source Databases
 Experience: Beginner
MySQL

Tuesday 9:30AM - 12:30PM

@ Texas 5

Matthew Boehm - Percona

Percona XtraDB Cluster (PXC) is the leading HA solution for MySQL with its write-anywhere, synchronous replication capabilities. This half-day tutorial will introduce you to PXC, explain core concepts, discuss advanced techniques, cover common "gotchas", and utilize ProxySQL to create the most highly-available MySQL cluster solution currently available.


MySQL/MariaDBOpen Source Databases
 Experience: Intermediate
MySQL

Tuesday 9:30AM - 12:30PM

@ Texas 6

Tom De Cooman - Percona, Dimitri Vanoverbeke - 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,on MySQL 5.7:
- We will install MySQL and configure the right privileges for your system
- Once we have a database running, we will get a better understanding of what our database is doing and look at the different possible diagnostics and monitoring options in MySQL using PMM and other tools.
- We will troubleshoot issues
- We will discuss and try some of the different backup options, since not losing any data is an important goal for a MySQL DBA
- We will clarify and troubleshoot replication

This is the first part of a full day's tutorial. The second part is in the afternoon.


MySQL/MariaDBOpen Source Databases
 Experience: Beginner
MySQL

Tuesday 9:30AM - 12:30PM

@ Texas 7

Vinicius Grippa - Percona, Michael Coburn - Percona

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

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

You will learn about:

- MySQL, MongoDB, and PostgreSQL monitoring best practices
- Metrics and time series
- Data collection, management and visualization tools
- Monitoring deployment
- How to use graphs to spot performance issues
- Query analytics for MySQL and MongoDB
- Alerting using Grafana
- Trending and capacity planning
- How to monitor HA

Please bring a laptop with an ssh client as you will be connecting to a Cloud-provisioned instance on which you will deploy PMM.


PostgreSQLMySQL/MariaDBMongoDBOpen Source Databases
 Experience: Beginner
Observability & Monitoring

Tuesday 2:00PM - 5:00PM

@ Hill Country A

Kenny Gryp - Oracle, Frédéric Descamps - Oracle

During this tutorial, attendees will get their hands on virtual machines and migrate standard Master-Slave architectures to the new MySQL InnoDB Cluster (native Group Replication) with minimal downtime. 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 and explain all the benefits of the new features we have introduced since 8.0.14 like the different data consistency models supported.

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

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.

We will highlight the new improvements made in MySQL 8.0 regarding Group Replication and InnoDB Cluster.


MySQL/MariaDB
 Experience: Advanced
MySQL

Tuesday 2:00PM - 5:00PM

@ Hill Country B

Jim Mlodgenski - Amazon Web Services

When developing against a PostgreSQL database, many times you will use SQL from your applications, but sometimes you need more. You might need to run some of your logic on the database server for performance or you may want to just create some server-side functions to simplify your application development. There is an infinite number of reasons why you would want to write some code that runs on the PostgreSQL server and PostgreSQL has a rich set of options when you want to do that, but most times, you will use PL/pgSQL. The primary objective of this tutorial is to introduce you to the PostgreSQL PL/pgSQL programming language and to give you the practical skills to be a productive developer working with PostgreSQL databases.

In the course of this tutorial, you will be introduced to a variety of fundamental PL/pgSQL functions like:
* How to declare and use PL/SQL Variables
* How to create functions and procedures
* How to write triggers
* Handle run time errors

And much more...


PostgreSQLMySQL/MariaDBOpen Source Databases
 Experience: Beginner
Observability & Monitoring, MySQL

Tuesday 2:00PM - 5:00PM

@ Hill Country C

Sveta Smirnova - Percona, Alexander Rubin - VirtualHealth

Performance Schema is a powerful diagnostic instrument for:

- Query performance

- Complicated locking issues

- Memory leaks
- Resource usage
- Problematic behavior, caused by inappropriate settings
- More

It comes with hundreds of options which allow precisely tuning what to instrument. More than 100 consumers store collected data.

In this tutorial, we will try all the important instruments out. We will provide a test environment and a few typical problems which could be hardly solved without Performance Schema. You will not only learn how to collect and use this information but have experience with it.


MySQL/MariaDB
 Experience: Intermediate
MySQL, Observability & Monitoring

Tuesday 2:00PM - 5:00PM

@ Hill Country D

Matthew Boehm - Percona

Orchestrator is quickly becoming the defacto-standard for MySQL failover detection and recovery. In this 3-hour tutorial, learners will install and configure Orchestrator, covering the most common use-cases along with simulating master failover and understanding the promotion process.


MySQL/MariaDBOpen Source Databases
 Experience: Intermediate
MySQL

Tuesday 2:00PM - 5:00PM

@ Texas 1

Paul Agombin - ObjectRocket, Maythee Uthenpong - Rackspace

- Cluster Components
- Collection Sharding
- Query Routing
- Balancing
- Zones
- Use Cases
- Backups
- Troubleshooting


MongoDB
 Experience: Intermediate
MongoDB

Tuesday 2:00PM - 5:00PM

@ Texas 5

Alkin Tezuysal - Percona, Daniel Guzman Burgos - Percona, Tate McDaniel - Percona

In this tutorial, we'll walk through over ten scenarios where things can get complex with your Percona XtraDB Cluster (PXC)/Galera installation. We will break things in these scenarios and then you'll have a chance to diagnose and fix them. Learn some of the most complex troubleshooting techniques.
Scenarios:
- New node fails to join cluster
- Data sharing (Node catch up): SST, IST
- Cluster restart failures
- Data inconsistency
- Delayed purging of the gcache
- Network latency problems
- Blocking transactions


MySQL/MariaDB
 Experience: Advanced
MySQL

Tuesday 2:00PM - 5:00PM

@ Texas 6

Tom De Cooman - Percona, Dimitri Vanoverbeke - 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,on MySQL 5.7:
- We will install MySQL and configure the right privileges for your system
- Once we have a database running, we will get a better understanding of what our database is doing and look at the different possible diagnostics and monitoring options in MySQL using PMM and other tools.
- We will troubleshoot issues
- We will discuss and try some of the different backup options, since not losing any data is an important goal for a MySQL DBA
- We will clarify and troubleshoot replication

This is the second part of a full day's tutorial. Please be sure to reserve your place on part 1 in the morning if you would like to attend this afternoon event.


PostgreSQLMySQL/MariaDBOpen Source Databases
 Experience: Beginner
Observability & Monitoring, MySQL

Tuesday 5:00PM - 6:30PM

@ Exhibitor Area - Texas Ballroom Foyer

Join us after the tutorials for the welcome reception in the expo area. Here you will have the opportunity to meet with conference attendees, sponsors and play retro arcade games while enjoying light bites and a beer, a glass of wine or soft drink!

The passport program will run this year were you will be given a booklet to be stamped by all participating sponsors. When you visit their kiosk, your Percona Live passport will be stamped and once you have completed it, will be given the opportunity to win some amazing prizes!

Connect with Percona

Stay Connected on:

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