Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Tips and Tricks - How to shard MySQL with ProxySQL in ClusterControl

Sharding can be a painful exercise. Databases need to be split on multiple servers, data migrated, and applications have to be tweaked to be aware of the shards. However, there are ways to make this less painful. This blog explains how to use ProxySQL to shard a table to another cluster in ClusterControl without changing your application.

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:

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.

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.

We’ve answered Eurofunk’s database SOS call

Announcing Eurofunk as our latest customer, who replaced Oracle with ClusterControl to deploy, monitor and manage the back-end MySQL Galera Cluster and associated database load balancers.

Posted in:

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:

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: