Galera cluster best practices: zero downtime schema changes
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
Presenter
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.
Presenter
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.
Follow Us
