Global NoSQL and SQL Virtual Bootcamp

Charly Batista (Percona Senior Support Engineer) will hold a 3-day workshop “MySQL and Percona XtraDB Cluster (PXC)” on Global NoSQL and SQL Virtual Bootcamp from the Global Big Data Conference from September 1st to September 3d.

This training intends to introduce MySQL clustering using Percona XtraDB Cluster, how to install, configure and tune it, and troubleshooting techniques.

The program of workshop:

Day 1 – Introduction to PXC: Architecture, installation and configuration

• Architecture of PXC;

• Replication methodologies;

  • Sync Replications;

  • Async replication;

• Installation and configuration of PXC;

• MySQL log files;

• Operation of PXC cluster;

• Performance tuning and monitoring;

• Tunable parameters of PXC MySQL.

Day 2 – PXC administration: Backup, restore,

• Administration of PXC MySQL;

• MySQL Security;

• MySQL Access privileges;

• MySQL User account management;

• MySQL Server configurations;

• High Availability and scalability with PXC cluster.

Day 3 – Troubleshooting and best practices

• DDL and DML in standalone MySQL vs Galera/PXC;

• Backup and Recovery;

• Operations challenges and troubleshooting;

• Best practices.

If you want get prepared to the worksop, download these open source software in advance to have hands-on labs:

• Percona PXC;

• Percona Xtrabackup;

• Percona toolkit

• Percona Monitoring and Management v2.

About the event.

Global Big Data Conference is offering multiple days extensive bootcamp on NoSQL and SQL. This is a fast paced, vendor agnostic, advanced technical topics of the NoSQL and SQL landscape.  Prior technical knowledge is assumed. Attendees will gain hands-on experience.