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
MySQL Enterprise Monitor is dead, let us help you determine your next move! Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL/MariaDB Galera Cluster is a bit different. Galera requires you...
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...
Video: ClusterControl Developer Studio Introduction
The free ClusterControl Developer Studio provides you a set of monitoring and performance advisors to use and lets you create custom advisors to add security and stability to your MySQL, Galera, and MongoDB infrastructures. ClusterControl’s...
Video: The Difference Between MongoDB Sharding and a MongoDB ReplicaSet
In this video we will demonstrate the differences between deploying a MongoDB ReplicaSet versus deploying a MongoDB Sharded Cluster in ClusterControl. With the new version of ClusterControl 1.4, you can automatically and securely deploy...