Categories
Products
Technologies
Top Rated docs

April 19, 2017

How to Deploy Asynchronous Replication Slave to MariaDB Galera Cluster 10.x

Combining Galera and asynchronous replication in the same MariaDB setup, aka Hybrid Replication, can be useful - e.g. as a live backup node in a remote datacenter or reporting/analytics server. We already blogged about this...

April 18, 2017

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. Although it was fairly straightforward to replicate from a standalone MySQL server...

April 17, 2017

Video: ClusterControl for Galera Cluster

This video walks you through the features that ClusterControl offers for Galera Cluster and how you can use them to deploy, manage, monitor and scale your open source database environments. ClusterControl and Galera Cluster ClusterControl...

April 14, 2017

Video: Managing Your Galera Cluster with ClusterControl

In this video Art van Scheppingen shows you how easy it is to add your Galera setups to ClusterControl. ClusterControl provides you with a single console to deploy, manage, monitor, and scale your Galera setups...

April 12, 2017

Online Schema Upgrade in MySQL Galera Cluster Using RSU Method

This post is a continuation of our previous post on Online Schema Upgrade in Galera using TOI method. We will now show you how to perform a schema upgrade using the Rolling Schema Upgrade (RSU)...

April 11, 2017

Full Restore of a MySQL or MariaDB Galera Cluster from Backup

Performing regular backups of your database cluster is imperative for high availability and disaster recovery. If for any reason you lost your entire cluster and had to do a full restore from backup, you would...

April 10, 2017

How to Bootstrap MySQL or MariaDB Galera Cluster – Updated

Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL/MariaDB Galera Cluster is a bit different. Galera requires you to start a node in a cluster as a reference point, before the...

April 7, 2017

Calculating the Total Cost of Ownership for MySQL Management

Cost analysis and cost effectiveness for databases are hardly ever performed, while it actually makes a lot of sense to perform such calculations. The easiest method of gaining insights into these is by performing a...

April 5, 2017

MySQL High Availability Tools – Comparing MHA, MRM and ClusterControl

We previously compared two high availability solutions for MySQL - MHA and MariaDB Replication Manager and looked into how they performed fail-over. In this blog post, we’ll see how ClusterControl stacks up against these solutions....

March 31, 2017

Webinar Replay: Load balancing MySQL & MariaDB with ProxySQL & ClusterControl

Thanks to everyone who participated in our recent webinar on how to load balance MySQL and MariaDB with ClusterControl and ProxySQL! This joint webinar with ProxySQL creator René Cannaò generated a lot of interest …...

March 27, 2017

Video: 9 Tips to Building a Stable MySQL Replication Environment

This video walks you through nine tips you should consider when deploying and managing a MySQL Replication environment and how utilizing ClusterControl can help make deploying, managing, monitoring, and scaling MySQL easy. Though MySQL replication...

March 23, 2017

MySQL Replication and GTID-Based Failover – A Deep Dive Into Errant Transactions

For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from...

Subscribe below to be notified of fresh posts