Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

MySQL on Docker: Running a MariaDB Galera Cluster without Container Orchestration Tools - Part 1

Container orchestration tools do not always play nicely with database clusters. In this blog post, we are going to look into how to run a MariaDB Galera Cluster on Docker containers using the standard Docker image on multiple Docker hosts without the help of orchestration tools like Swarm or Kubernetes.

How to Recover Galera Cluster or MySQL Replication from Split Brain Syndrome

Split brain syndrome is a state where a cluster of nodes is partitioned into smaller clusters of equal numbers of nodes, and each cluster believes it is the active cluster. This is a harmful state, as data is changed on a partition, without being replicated to the other. This blog post describes how to prevent a split brain from happening, and what can be done if it does happen.

Watch the Replay: How to Migrate to Galera Cluster for MySQL & MariaDB

Watch the replay of this webinar on how to migrate to Galera Cluster for MySQL & MariaDB. Severalnines Support Engineer Bart Oles walks us through what you need to know in order to migrate from standalone or a master-slave MySQL/MariaDB setup to Galera Cluster.

Deploying Cloud Databases with ClusterControl 1.6

ClusterControl 1.6 comes with tighter integration with AWS, Azure and Google Cloud, so it is now possible to launch new instances and deploy MySQL, MariaDB, MongoDB and PostgreSQL directly from the ClusterControl user interface. This blog post shows you how.

Comparing Oracle RAC HA Solution to Galera Cluster for MySQL or MariaDB

This blog provides a comparison of achieving high availability with Oracle RAC vs MySQL Galera Cluster.

Updated: Become a ClusterControl DBA - SSL Key Management and Encryption of MySQL Data in Transit

In this blog post, we’ll show you how to generate self-signed certificates using ClusterControl, and encrypt all data traffic e.g. within a Galera Cluster and between MySQL databases and its clients.

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.