Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
32 blog posts in 11 categories

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:

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:

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.

Posted in:

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.

Posted in:

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.

Posted in:

ClusterControl Tips & Tricks - Transparent Database Failover for your Applications

This blog shows you how to make database failure and failover transparent to your applications, by using HAProxy or MaxScale.

Become a PostgreSQL DBA - How to Setup Streaming Replication for High Availability

In this post, we will show you how to set up master-slave replication with Postgres.

MySQL Replication failover: MaxScale vs MHA (part 4)

This post is an addendum on the MariaDB Replication Manager covering the new improved features

Posted in:

How ProxySQL adds Failover and Query Control to your MySQL Replication Setup

An overview of ProxySQL in a MySQL replication environment, and how ProxySQL adds features like failover and query control to the setup.

Posted in:

Read-Write Splitting for Java Apps using Connector/J, MySQL Replication and HAProxy

In this blog post, we will play around with Java and MySQL Replication to perform read-write splitting for Java Apps using Connector/J.

Posted in:

Pages