Ramp-up tutorial for MySQL Cluster - Scaling with continuous availability (Part 2)

Replication and High Availability Strategies
22 April 1:30pm - 4:30pm @ Ballroom C

This is a full day tutorial

- 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 Cluster on 3 virtual machines;
- Configuration of a basic system : upon describing the most important configuration parameters, Data/API/Management nodes will be configured and the Cluster launched;
- Loading data: the "world" schema will be imported into NDB using "in memory" and "disk based" storages; the attendees will experience how data changes are visible across API Nodes;
- Understand the NDB Storage Engine : internal implementation details will be explained, like synchronous replication, transaction coordinator, heartbeat, communication, failure detection and handling, checkpoint, etc;
- Query and schema design : attendees will understand the execution plan of queries with NDB, how SQL and Data Nodes communicate, how indexes and partitions are implemented, condition pushdown, join pushdown, query cache;
- Management and Administration: the attendees will test High Availability of NDB when a node become unavailable will learn how to read log file, how to stop/start any component of the Cluster to perform a rolling restart with no downtime, and how to handle a degraded setup;
- Backup and Recovery: attendees will be driven through the procedure of using NDB-native online backup and restore, and how this differs from mysqldump;
- Monitor and improve performance: attendee will learn how to boost performance tweaking variables according to hardware configuration and application workload


René Cannaò
MySQL SRE, Dropbox / ProxySQL
René has 15 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 10 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle, then Senior Operational DBA at Blackbird, (formerly PalominoDB), and finally MySQL SRE at Dropbox. In this period he built an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance. His main focus now is the development of ProxySQL.