80 blog posts in 13 categories
This blog provides a comparison of achieving high availability with Oracle RAC vs MySQL Galera Cluster.
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.
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.
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.
This is a step-by-step guide on how to migrate your database service from one network/cloud platform to another, without downtime.
This blog post features some ideas (with examples) on how to crash a MySQL server in a Linux environment.
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.
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.
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.
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.