Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
57 blog posts in 1 category

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.

Posted in:

Ten Tips on How to Achieve MySQL and MariaDB Security

This blog gives you 10 suggestions on how to improve the security of your MySQL or MariaDB installations.

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.

Posted in:

The Galera Cluster & Severalnines Teams Present: How to Manage Galera Cluster with ClusterControl - The Replay

Introducing the replay of our joint webinar with the Galera Cluster Team in which we hear from Seppo Jaakola, CEO at Codership - the creators of Galera Cluster - on what the latest is on the most popular HA technology for MariaDB & MySQL and demonstrate how to manage it with ClusterControl.

HAProxy Connections vs MySQL Connections - What You Should Know

Max connections determines the maximum number of connections to the database server. This can be set on both the database server, or the proxy in front of it. In this blog post, we’ll dive into HAProxy and MySQL maximum connections variables, and see how to get the best of both worlds.

Posted in:

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.

Posted in:

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:

[Updated] Monitoring Galera Cluster for MySQL or MariaDB - Understanding metrics and their meaning

Read this blog to find out how ClusterControl combines the two most popular types of monitoring, and see how it presents needed information on Galera Cluster and how we should interpret it.

Posted in:

Manage and Automate Galera Cluster - Why ClusterControl

This blog describes why you should utilize ClusterControl for the management of your Galera Clusters.

Posted in:

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.

Posted in:

Pages