Showing entries 1 to 10 of 12
2 Older Entries »
Displaying posts with tag: Galera Cluster for MySQL (reset)
Minor version upgrade of a Galera Cluster for MySQL

Recently we got a question about how one can perform a minor version upgrade of a Galera Cluster, and today we just want to say that it is reasonably straightforward. While upgrades are a feature of Galera Manager that we are most excited to see come soon, today, doing it manually on the command line is quite simple! In this post, we will go through upgrading a 9-node geographically spread cluster, from MySQL 8.0.23 to 8.0.26. We also have extensive documentation: Upgrading Galera Cluster.

We have 3 nodes each in Singapore, London and San Francisco, making the cluster comprise of a total of 9 nodes, as we can confirm by executing: show status like 'wsrep_cluster_size';.

Since we installed all this via the RPM package manager on CentOS 7 by adding the YUM repository to the …

[Read more]
Time to check Galera Cluster security?

There are plenty of articles on the Internet that tell you to setup a Galera Cluster by disabling an OS based firewall and also disabling SELinux. While we agree that this might be the fastest way to get your Galera Cluster setup, it is not necessarily good security hygiene, and we would prefer if you started 2022 with a bit more secure Galera Cluster!

What is SELinux? Is is Security-Enhanced Linux that allows administrators to allow who has more control over the system. It has permissive and enforcing mode, and is turned on by default in Red Hat Enterprise Linux and derivatives. It is important to remember that if you install Galera Cluster via a package that we provide, we have provided all the necessary contexts for it. You effectively do not have to disable SELinux to get started.

However, if you are using the rsync method for a …

[Read more]
Galera Manager Support on Github with solutions for Docker and Apache users

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 …

[Read more]
Galera Manager updated with usability improvements for self-hosted and monitored clusters

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 …

[Read more]
Webinar: Galera Manager is now GA with ability to launch clusters on premise and in the AWS cloud

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

[Read more]
Galera Cluster for MySQL training in September

Codership, the developers of Galera Cluster for MySQL, provides training sessions in September 2021 for EMEA and USA timezone.

The Advanced Database Administrator with Galera Cluster training course teaches you how to install and configure in real-time a Galera Cluster for your application use cases. You will participate in interactive hands-on labs. Our expert instructor will teach you how to design and maintain your Galera Cluster for MySQL high availability and scalability. If you are a DBA or been given a Galera Cluster to manage, this is the course for you, as you’ll learn how to run your Galera Cluster in an optimal fashion, from setup, performance tuning, monitoring, as well as backups and more.

For more information, please read the full CONTENT BRAKEDOWN  course.

Course Dates

 

EMEA: …

[Read more]
Galera Cluster for MySQL 5.7.34 and 8.0.25 released

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7 and 8.0, consisting of MySQL-wsrep 5.7.34 (release notes, download) and MySQL-wsrep 8.0.25 (release notes, download) with Galera replication library 3.34 (release notes, download) implementing wsrep API version 25 …

[Read more]
Galera Streaming Replication Feature Deep Dive Video and Blog

Just last week we had a Galera Cluster for MySQL streaming replication feature deep dive webinar, by the person that implemented it – Seppo Jaakola. In fact, if you haven’t already read the entire story, we encourage you to read: Galera Streaming Replication: Too Big A Bite Can Choke Your Cluster. We also have the 60 minute video recording for reference.

A huge number of Galera Cluster users have always complained about having issues with large transactions (where writes hang but reads are OK), and we are certain that the correct usage of streaming replication is what will ease that burden. What constitutes a large transaction? Typically when you make big number of …

[Read more]
Installing Galera 4 with MySQL 8 on Ubuntu 20.04

A question has cropped up recently: how does one install Galera Cluster 4 with MySQL 8 on Ubuntu 20.04 LTS (Focal Fossa)? This quick guide will get you started.

Install 3 Galera Cluster nodes with the base OS being Ubuntu 20.04. Remember to run apt update and apt upgrade.

Once this is done, edit: /etc/apt/sources.list.d/galera.list and add the following lines:

deb https://releases.galeracluster.com/galera-4/ubuntu focal main
deb https://releases.galeracluster.com/mysql-wsrep-8.0/ubuntu focal main

Once that is done, don’t forget to also pin the preference to the Galera Cluster repository. To do this, edit: /etc/apt/preferences.d/galera.pref and have it read:

# Prefer the Codership repository
Package: *
Pin: origin releases.galeracluster.com
Pin-Priority: 1001

Once you are done, run apt update yet again. Now you are ready to install Galera Cluster 4 with MySQL 8, just …

[Read more]
Galera Cluster for MySQL 5.6.50, 5.7.32, and 8.0.22 released

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.6, 5.7 and 8.0, consisting of MySQL-wsrep 5.6.50 (release notes, download), 5.7.32 (release notes, download) and 8.0.22 (release notes, download) with Galera replication library 3.32 ( …

[Read more]
Showing entries 1 to 10 of 12
2 Older Entries »