Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
179 blog posts in 1 category

Online schema change with gh-ost - throttling and changing configuration at runtime

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.

Posted in:

How to perform online schema changes on MySQL using gh-ost

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.

Posted in:

Planets9s - 2016’s most popular s9s resources

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.

Posted in:

How to Perform Efficient Backup for MySQL and MariaDB

There are a number of ways to backup MySQL and MariaDB, each comes with pros and cons. An effective backup strategy will depend on the requirements of the business, the environment you operate in, and the resources at your disposal.

Posted in:

Planets9s - Online schema change for MySQL & MariaDB, MySQL storage engine & backups … and more

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.

Posted in:

Online schema change for MySQL & MariaDB - comparing GitHub’s gh-ost vs pt-online-schema-change

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.

Posted in:

The choice of MySQL storage engine and its impact on backup procedures

MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM the most popular ones. This has an impact on how you design and run your backup procedures.

Posted in:

Planets9s - Download our new DevOps Guide to Database Backups for MariaDB & MySQL

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.

Posted in:

New whitepaper - the DevOps Guide to database backups for MySQL and MariaDB

Check out our free new whitepaper on database backups, which discusses in detail the two most popular backup utilities available for MySQL and MariaDB, namely mysqldump and Percona XtraBackup.

Planets9s - On stable MySQL Replication setups, running MySQL on Docker and cloud lockin

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.

Posted in:

Pages