4 blog posts in 11 categories
When performing schema changes online, it is important to be able to control the performance impact on our running databases. This blog post discusses gh-ost’s throttling mechanism. We will also cover the runtime configuration changes that gh-ost allows.
This blog post shows you how to use GitHub’s gh-ost to perform an online schema change on a MySQL master-slave replication setup.
Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.
Online schema changes are a fact of life for any DBA. While there are tools to assist, for example, Percona’s pt-online-schema-change, it does not come without drawbacks. GitHub released a new online schema change tool called gh-ost. This post looks at how gh-ost compares to pt-online-schema-change, and how it can be used to address some limitations.