Severalnines Blog
The automation and management blog for open source databases

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

Posted in:

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

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

Online schema changes are unavoidable, as any DBA will know. While there are tools such as Percona’s pt-online-schema-change to assist, it does not come without drawbacks. However, there is a new kid on the block: GitHub released an online schema change tool called gh-ost. This post by Krzysztof Ksiazek, Senior Support Engineer at Severalnines, looks at how gh-ost compares to pt-online-schema-change, and how it can be used to address some limitations.

Read the blog

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

As you will know, MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM being the most popular ones. And this has an impact on how you design and run your backup procedures. Since data is stored inside the storage engine, we need to understand how the storage engines work to determine the best backup tool. This post by Ashraf Sharif, System Support Engineer at Severalnines, provides the necessary insight into these topics and recommendations on how best to proceed.

Read the blog

Want an easy way to deploy & monitor Galera Cluster in the cloud?

If you haven’t see it yet, we’ve recently launched a new tool that allows you to easily deploy and monitor Galera Clusters onto the AWS and Digital Ocean clouds. NinesControl allows quick, easy, point-and-click deployment and monitoring of a standalone or a clustered SQL and NoSQL database. Each provisioned database is automatic, repeatable and completes in minutes. It also provides real-time monitoring, self-healing and automatic recovery features. Find out more and get started via the link below.

Check out NinesControl

That’s it for this week! Feel free to share these resources with your colleagues and follow us in our social media channels.

Have a good end of the week,

Jean-Jérôme Schmidt
Planets9s Editor
Severalnines AB

Related Post

MySQL on Docker: Composing the Stack

Docker 1.13 introduces a long-awaited feature called Compose-file support. Compose-file defines everything about an application - services, databases, volumes, networks, and dependencies can all be defined in one place.  In this blog, we’ll show you how to use Compose-file to simplify the Docker deployment of MySQL containers.

Posted in:

How to deploy and manage MySQL multi-master replication setups with ClusterControl 1.4

MySQL replication, while simple and popular, may come in different shapes and flavors. Master slave or master master topologies can be configured to suit your environment.  ClusterControl 1.4 brings a list of enhancements to deploy and manage different types of MySQL replication setups. This blog outlines the different topologies that can be deployed, the merits of each topology, and shows how each can be managed in a live environment.

Posted in:

Automatic failover of MySQL Replication - New in ClusterControl 1.4

MySQL replication setups are inevitably related to failovers - what do you do when your master fails and your applications are not able to write to the database anymore? Automated failover is required if you need to quickly recover an environment to keep your database up 24x7. This blog post discusses this new replication feature recently introduced in ClusterControl 1.4.

Posted in:

Automating MySQL Replication with ClusterControl 1.4.0 - what’s new

This blog post will go through new replication features in ClusterControl 1.4.0, including enhanced multi-master deployment, managing replication topology changes, automated failover and handling of replication errors.

Posted in: