Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Set Up Asynchronous Replication from Galera Cluster to Standalone MySQL server with GTID

Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier since GTID got introduced in MySQL 5.6. In this blog post, we will show you how to replicate a Galera Cluster to a MySQL server with GTID, and how to failover the replication in case the master node fails.

Posted in:

MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions

This blog post covers deployment of replication cluster using ClusterControl. It also discusses in-depth a concept of errant transactions, how to detect them and how to fix issues related to them.

MySQL slave promotion with- and without using GTID

Learn more about MySQL slave promotion in GTID and non-GTID-based MySQL Replication setups.

Posted in:

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:

MySQL Replication failover: Maxscale vs MHA (part 3)

This post describes how you can implement automated failover with MariaDB using Maxscale and MHA and compares the two with each other.

Posted in:

MySQL Replication failover: Maxscale vs MHA (part 2)

This post describes how you can implement automated failover with MariaDB using Maxscale and MariaDB Replication Manager.

Posted in:

MySQL Replication failover: Maxscale vs MHA (part 1)

This post describes how you can implement automated failover with MariaDB MHA.

Posted in:

Webinar Replay & Slides: Become a MySQL DBA - Replication Topology Changes for MySQL and MariaDB

Thanks to everyone who joined us for our recent live webinar on ‘Replication Topology Changes for MySQL and MariaDB’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online.

Posted in:

Become a MySQL DBA blog series - Common operations - Replication Topology Changes

This is the fifth installment in the ‘Become a MySQL DBA’ blog series, and discusses one of the most common operations a DBA has to handle - replication topology changes and planned failover. Our previous posts in the DBA series include Schema Changes, High Availability, Backup & Restore, Monitoring & Trending.

Resources for Highly Available Database Clusters: ClusterControl Release Webinar, Support for Postgres, New Website and More

Check Out Our Latest Technical Resources for MySQL, MariaDB, Postgres and MongoDB Clusters

Like every month, we have created new content and tools for you; here is a summary of what we’ve published. Please do check it out and let us know if you have any comments or feedback.

Posted in:

Pages