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...
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)...
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...
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...
Calculating the Total Cost of Ownership for MySQL Management
Most organizations rarely conduct cost analysis for their databases, even though it can reveal valuable insights. A simple yet powerful way to understand database costs is through a Total Cost of Ownership (TCO) analysis. You...
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....
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 …...
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...
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...
Video: MySQL Replication & ClusterControl Product Demonstration
The video below details the features and functions that are available in ClusterControl for MySQL Replication. Included in the video are… How to Deploy Master-Slave Replication How to Deploy Multi-Master Replication MySQL Replication overview including...
How to Secure MySQL/MariaDB Servers
After attacks on MongoDB databases, we have recently also seen that MySQL servers are being targeted by ransomware. This should not come as a surprise, given the increasing adoption of public and private clouds....
MySQL Replication: All the Severalnines Resources
MySQL Replication has become an instrumental part of scale-out architectures in LAMP environments. MySQL offers plenty of solutions when there is a need to scale out, the most common being to add read replicas. Building...