A common question we get is: can I add a node to my Galera Cluster without restarting the entire cluster? The simple answer is YES.

A lot worry about the fact that you do list servers that are part of the cluster within your my.cnf, and this file is not reloadable in a dynamic fashion. Fret not, though, because as long as your my.cnf has one active cluster member (the DONOR), you can have it be the JOINER.

If for example, you have 3 nodes: galera1: 159.223.105.21 galera2: 137.184.78.182 galera3: 137.184.65.171

The my.cnf line for wsrep_address should read as follows:

wsrep_cluster_address="gcomm://159.223.105.21,137.184.78.182,137.184.65.171"

It is then trivial for you to have your fourth server (say, galera4: 161.35.120.111), have a my.cnf that reads as follows:

wsrep_cluster_address="gcomm://159.223.105.21,137.184.78.182,137.184.65.171,161.35.120.111"

Now, …

While Galera Manager is ideal for deploying on Amazon AWS or DigitalOcean, or even on your own on-premise hosts, there is a third option that exists, that allows you to monitor an existing cluster that you already have installed. While we won’t go thru installing a Galera Cluster in this post, we will show you how to get Galera Manager to function for this purpose.

Obtain Galera Manager via filling in the form. Once you have the gm-installer on your Galera Manager host, remember to execute: chmod +x gm-installer. We recommend also …

In the event that you are not planning to deploy Galera Cluster using Galera Manager on your own on-premise hosts, it is worth noting that Galera Manager supports the ability to automatically deploy a 3-node Galera Cluster in Amazon Web Services (AWS) Elastic Compute Cloud (EC2) automatically, just by suppling your API key information. Naturally, we also made a video on a step-by-step video on how to install Galera Cluster in an Amazon EC2 using Galera Manager.

It is worth noting that you can use the free tier to deploy your Galera Cluster with Galera Manager for testing purposes.

Obtain Galera Manager via filling in the form. Logon to your AWS Console. Launch just one EC2 …

Our most favoured method of deploying Galera Clusters via Galera Manager happen to be the on-premise option, which is favoured by our customers and users. We have always been under the impression that the cloud deployments (AWS, DigitalOcean) would have more pull, but majority do prefer an on-premise installation. We have also made an appropriate video: A step-by-step video on how to install Galera Cluster on premises using Galera Manager.

So to start, we will deploy 3 hosts, running CentOS 7. These are just deployed with the base operating system (OS). And of course, you need another host to run your Galera Manager, so in total we have four (4) hosts. Obtain Galera Manager via filling in the form.

Once you have the …

We have produced two new step-by-step videos for installing Galera Clusters either on premise and at Amazon EC2 environments.

The videos can be replayed from links below.

A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager

A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager in 15 minutes. With Galera Manager you can manage and monitor your Galera Clusters in Amazon EC2. Galera Cluster in Amazon EC2 is more cost effective and comes with stronger high availability and control in comparison to using Amazon RDS.

WATCH THE VIDEO

A step-by-step video on how to install Galera Cluster on premise using Galera Manager

A step-by-step video on how to install Galera Cluster on premise, on user provided hosts using Galera …

A few things we have noticed recently when it comes to Galera Manager support requests, that we feel we should address in this blog post.

First and foremost, it is a requirement that you install Galera Manager on a clean host. This means you install the base operating system and nothing else: no Nginx, no Apache, no InfluxDB, etc. The Galera Manager installer (gm-installer) will pull all the requisite packages, set SELinux to permissive during the install, etc. The next release of the gm-installer aims to be less fragile when it comes to this, and will aggressively handle installs on machines that already have software installed on it.

The other common issue is the inability to access ports, generally blocked by a firewall (gm-installer should have fixed this as long as setup is going properly), or some other reason. What gm-installer cannot fix …

Codership is pleased to announce a new release of Galera Manager. This is version 1.6.2 of Galera Manager GUI. Users will notice many usability improvements, and multiple fixes for issues filed at the galera-manager-support issue tracker.

The biggest user facing feature is now being able to deploy Galera Manager managed nodes on DigitalOcean, in addition to Amazon Web Services (AWS) Elastic Compute Cloud (EC2). Now with an access token, one can fully deploy a managed cluster from within Galera Manager. 3 node fully managed Galera Clusters on Digital Ocean in under 10 minutes? This is the promise and delivery of the latest Galera Manager.

From a security standpoint, SSL …

As more people test, utilise and deploy Galera Manager, there is always room for support requests, and we see that at the Galera Manager Support Repository on Github. We encourage you to file requests, as they help with our roadmap as well!

We have had a feature request to run within a Docker container, and while we work on documentation and an official solution, we do have a temporary solution. Try it with Docker!

We have had a feature request to be able to support …

Codership is pleased to announce a new release of Galera Manager. This brings the installer to version 1.5 and the actual Galera Manager GUI to 1.4.0.

Users will notice some usability improvements like the cluster name being added to the authorized_keys generated file, while there are benefits around gmd generating a new key for the updated installation. There is also a port checker, so if ports are used and unavailable, the user will be informed and Galera Manager will refuse to install. In addition, on Debian/Ubuntu where apt/dpkg supports interactivity, we have now ensured that all steps will remain non-interactive.

  We now have native support to deploy MariaDB Server 10.6 From the Galera Manager GUI standpoint, we have ensured that job monitoring and charts have better performance. One user experience enhancement for monitored or self-hosted clusters? Galera Manager now checks to ensure it has access to …

This is a new era in deploying, managing and monitoring your Galera Cluster for MySQL, with the recently released Galera Manager, now Generally Available (GA). Galera Manager is a web-based graphical user interface (GUI) tool that allows you to fully manage clusters in Amazon Web Services, you can also deploy clusters on user provided hosts (on premise or in the cloud) and you can also fully monitor your existing clusters.

In this Webinar, we will cover:

• Deploying a fully managed cluster in AWS
• Deploying a cluster on user-provided hosts
• Monitoring an existing cluster
• How we have chosen to use CLONE SST for MySQL 8 deployments
• How you can successfully deploy all the various servers that we support
• Utilising the over 600 monitoring metrics to effectively manage your Galera Cluster

…