Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Experiences using gh-ost in a multi-tier topology

Sponsor Percona Live Open Source Database Conference

Experiences using gh-ost in a multi-tier topology

 26 April - 5:00 PM - 5:25 PM @ Ballroom C
Experience level: 
Intermediate
Duration: 
25 minutes conference
Tracks:
Operations
Topics:
MySQL
Tools and Techniques

Description

In this session we will share our experiences using gh-ost for long-running schema changes in a multi-tier replication topology under high-volume traffic. This will include sharing how gh-ost can work with topologies using the Tungsten Replicator. We’ll share the ideal combination of commands to use in this setup, and discuss reasons we chose gh-ost over our old friend pt-online-schema-change. Operational controls are important with long-running changes, so we’ll show how we used those as well.

Speakers

Valerie Parham-Thompson's picture

Valerie Parham-Thompson

Lead Database Consultant, Pythian

Biography:

With experience as an open-source DBA and developer for software-as-a-service environments, Valerie has expertise in web-scale data storage and data delivery.

Ivan Groenewold's picture

Ivan Groenewold

Lead Database Consultant, Pythian

Biography:

Ivan is a database professional with 10+ years supporting mission-critical environments with a strong sysadmin background. Starting as an Oracle Administrator, he eventually became involved with MySQL and MongoDB as well, having co-developed the DBaaS platform for the biggest e-commerce site of Latin America. He currently works as a Lead MySQL Consultant for Pythian.

Share this talk