Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
194 blog posts in 13 categories

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:

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.

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:

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.

Schema changes in Galera cluster for MySQL and MariaDB - how to avoid RSU locks

This post shows you how to avoid locking existing queries when performing rolling schema upgrades in Galera Cluster for MySQL and MariaDB.

Database Cluster Management - Manual vs Automation via ClusterControl

Database Cluster management tasks include restart/recovery of services that fail, topology changes, reconfiguration, rolling upgrades, backups and performing security procedures. Since the tasks usually involve multiple servers, these can be repetitive and error-prone. This blog looks at efficiency gains when using ClusterControl to manage a MySQL Galera cluster as compared to manual ways.

9 DevOps Tips for going in production with MySQL / MariaDB Galera Cluster: webinar replay

In this webinar, we will guide you through 9 key tips to consider before taking Galera Cluster for MySQL / MariaDB into production.

Watch the replay: MySQL Query Tuning Part 2 - Indexing and EXPLAIN

This is the replay of Part 2 of our webinar trilogy on MySQL Query Tuning. This session covered Indexing and EXPLAIN, one of the most important tools in the DBA’s arsenal.

Two Database Sharding Tools for MySQL

This blog post will introduce you to three different tools which are designed to help users shard their MySQL databases.

Database Security - MySQL Upgrade Instructions for Zero-day Exploit

This blog shows you how to upgrade your MySQL and MariaDB databases, in order to address CVE-2016-6662 - a publicly disclosed vulnerability in MySQL.