Galera cluster best practices: zero downtime schema changes

Presented by Johan Andersson and Seppo Jaakola
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "Galera cluster best practices: zero downtime schema changes", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.

Galera Cluster is good at making your MySQL database HA, but what about schema changes? Is an ALTER TABLE statement something that requires a lot of advance scheduling? What is the impact on database uptime? Watch this webinar and learn how to do schema changes in your MySQL Galera cluster with maximum uptime and full data consistency.

Agenda

  • How to perform Zero Downtime Schema Changes
  • 2 main methods: TOI and RSU
  • Total Order Isolation: predictability and consistency
  • Rolling Schema Upgrades
  • pt-online-schema-change
  • Schema synchronization with re-joining nodes
  • Recommended procedures
  • Common pitfalls/user errors

Presenters

Johan Andersson

Johan Andersson, CTO, Severalnines - Johan's technical background and interest are in high performance computing as demonstrated by the work he did on main-memory clustered databases at Ericsson as well as his research on parallel Java Virtual Machines at Trinity College Dublin in Ireland. Prior to co-founding Severalnines, Johan was Principal Consultant and lead of the MySQL Clustering & High Availability consulting group at MySQL / Sun Microsystems / Oracle, where he designed and implemented large-scale MySQL systems for key customers. Johan is a regular speaker at MySQL User Conferences as well as other high profile community gatherings with popular talks and tutorials around architecting and tuning MySQL Clusters.

Seppo Jaakola

Seppo Jaakola, Founder of Codership, has over 20 years experience in software engineering. He started his professional career in Digisoft and Novo Group Oy working as a software engineer in various technical projects. He then worked for 10 years in Stonesoft Oy as a Project Manager in projects dealing with DBMS development, data security and firewall clustering. In 2003, Seppo Jaakola joined Continuent Oy, where he worked as team leader for MySQL clustering product. This position linked together his earlier experience in DBMS research and distributed computing. Now he’s applying his years of experience and administrative skills to steer Codership to a right course. Seppo Jaakola has MSc degree in Software Engineering from Helsinki University of Technology.

Comments & questions

Have any questions? Please, contact us.