Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Secure Galera Cluster - 8 Tips

As a distributed database system, Galera Cluster requires additional security measures as compared to a centralized database. Data is distributed across multiple servers or datacenters, with significant data communication across nodes. This blog post covers some important tips to secure your Galera Cluster installation.

ClusterControl Tips & Tricks: Securing your MySQL Installation (Updated)

During the life cycle of Database installation it is common that new user accounts are created. It is a good practice to once in a while verify that the security is up to standards. That is, there should at least not be any accounts with global access rights, or accounts without password. Using ClusterControl, you can at any time perform a security audit.

Zero Downtime Network Migration with MySQL Galera Cluster using Relay Node

This is a step-by-step guide on how to migrate your database service from one network/cloud platform to another, without downtime.

Several Ways to Intentionally Fail or Crash your MySQL Instances for Testing

This blog post features some ideas (with examples) on how to crash a MySQL server in a Linux environment.

How to Stop or Throttle SST Operation on a Galera Cluster

A full node resync, or SST, can be a heavy, long-running operation that impacts the performance and stability of a Galera Cluster. This blog post explains a trick on how to stop an ongoing SST operation in a clean manner.

How to Automate Galera Cluster Using the ClusterControl CLI

As sysadmins and developers, we spend a lot our time in a terminal. So we brought ClusterControl to the terminal with our command line interface tool called s9s. This blog post shows how to use s9s to automate management of a Galera Cluster and a master-slave replication setup.

Posted in:

ClusterControl in the Cloud - All Our Resources

You can deploy ClusterControl on premise or in the cloud. This blog describes some of the benefits of the cloud and provides some resources to help you get your databases up and running with ClusterControl.

Multiple Data Center Setups Using Galera Cluster for MySQL or MariaDB

Regardless of how redundant your database is, if everything is in a single data center, it might not be good enough. Losing network connectivity to the datacenter means your service will be unavailable. This blog provides insight into setting up Galera Cluster across multiple data centers.

A How-To Guide for Galera Cluster - Updated Tutorial

We have updated one of our most popular Tutorials to include new information and tips on how to deploy and manage Galera Cluster for MySQL.

Galera Cluster Comparison - Codership vs Percona vs MariaDB

The blog post compares the three Galera Cluster variants - MySQL Galera Cluster by Codership, Percona XtraDB Cluster by Percona and MariaDB 10.x by MariaDB.