Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

Become a MongoDB DBA: MongoDB Sharding Ins & Outs - Part 2

In our previous post, we showed you how to shard your MongoDB databases and covered the theory behind it. But you are not done yet. How do you monitor the shards to make sure they are performing, and that data is distributed evenly between your shards? And how do you consistently backup your data across shards? This is our ninth post in the “Become a MongoDB DBA” blog series.

Become a MongoDB DBA: MongoDB Sharding Ins & Outs - Part 1

This is our eighth post in the “Become a MongoDB DBA” blog series: how to scale writes with MongoDB.

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.

Sharding MySQL with MySQL Fabric and ProxySQL

This blog post shows you how to set up a sharded MySQL setup based on MySQL Fabric and ProxySQL.

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 Sharding - How does it work?

Why do we shard? How does sharding work? What are the different ways to shard a database? This post goes through some of the theory behind sharding.

MySQL Query Tuning: Process & Tools - View the Replay & Slides

These are the replay details of the first part of our webinar trilogy on MySQL Query Tuning. In this session we discussed the process and tools required to tune MySQL queries.