Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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:

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.

MySQL on Docker: Deploy a Homogeneous Galera Cluster with etcd

Our journey to make Galera Cluster run smoothly on Docker containers continues. Deploying Galera Cluster on Docker is tricky when using orchestration tools. With this blog, find out how to deploy a homogeneous Galera Cluster with etcd.

How to build a stable MySQL Replication environment

During this webinar, participants will learn how to build a production-ready environment with MySQL replication. From OS and DB configuration checklists to schema changes and disaster recovery, they’ll have the information needed to plan and prepare the best setup for their requirements.

Posted in:

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.

Top 9 Tips for building a production-ready MySQL Replication environment

Join our new webinar during which we’ll cover our 9 Top Tips on how to build a stable MySQL Replication environment. From OS and DB configuration checklists to schema changes and disaster recovery,  you’ll have the tips needed for a production-ready replication setup.

Posted in:

Announcing NinesControl: helping MongoDB and MySQL developers scale in AWS and DigitalOcean clouds

Today we’re announcing NinesControl, a database management cloud service, which enables developers to uniformly and transparently deploy and manage polyglot open source databases on any cloud, with no vendor lock-in.

Deploying and Monitoring MySQL and MongoDB clusters in the cloud with NinesControl

This blog shows you how to deploy and monitor MySQL Galera, MariaDB and MongoDB clusters on DigitalOcean and Amazon Web Services using NinesControl.

Posted in:

Join our live webinar on how to scale and shard MongoDB

Learn in this new webinar how to scale and shard your MongoDB setup; and how to leverage ClusterControl to help you with that.

Posted in: