Online Schema Change With gh-ost – Throttling and Changing Configuration at runtime
(this post was edited on 13/01/2017 after comments from Shlomi N.) In previous posts, we gave an overview of gh-ost and showed you how to test your schema changes before executing them. One important feature...
How to Perform Online Schema Changes on MySQL Using gh-ost
In the previous blog post, we discussed how gh-ost works internally and how it compares to Percona’s pt-online-schema-change. Today we’d like to focus on operations - how can we test a schema change with...
Online Schema Change for MySQL & MariaDB – Comparing GitHub’s gh-ost vs pt-online-schema-change
Database schema change is one of the most common activities that a MySQL DBA has to tackle. No matter if you use MySQL Replication or Galera Cluster, direct DDL’s are troublesome and, sometimes, not...
Common Database Management Operations – Schema Changes
Database schema changes are not popular among DBAs, not when you are operating production databases and cannot afford to switch off the service during a maintenance window. These are unfortunately frequent and necessary, especially when...
Online Schema Upgrade in MySQL Galera Cluster using TOI Method
As a follow-up to the Webinar on Zero Downtime Schema Changes in Galera Cluster, we’ll now walk you through the detailed steps on how to update your schema. The two methods (TOI and RSU) have both...
Webinar Replay: Galera Cluster Best Practices – Zero Downtime Schema Changes
Thanks to everyone who attended yesterday’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online. ...