Showing entries 1 to 10 of 37
10 Older Entries »
Displaying posts with tag: Galera Cluster for MySQL (reset)
Galera Cluster works on Oracle Linux

We recently had a customer request to run Galera Cluster on Oracle Linux. We are pleased to tell you that you can use the Red Hat Enterprise Linux 8 or Red Hat Enterprise Linux 9 repositories: for the latest Galera Cluster with MySQL 8 and the wsrep library.

It is worth noting that while it is difficult to find an Oracle Linux image in many cloud providers, there is Oracle Cloud that offers Oracle Linux as a default. However, remember that if you are using Oracle Cloud, you still have to configure the firewalls, etc. to ensure that Galera network traffic can still pass between the nodes.

If using Oracle Cloud, we picked this image: Oracle-Linux-8.9-2024.05.29-0.

uname -a
Linux instance-20240611-1345 5.15.0-206.153.7.el8uek.x86_64 #2 SMP …
[Read more]
Galera Cluster for MySQL 8.0.36-26.18 released

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36-26.18 (release notes, download). There is no change to the Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High Availability solutions.

This is a …

[Read more]
Galera Cluster for MySQL 8.0.36 released

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36 (release notes, download), with Galera replication library 4.18 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.36, adding a synchronous option for your MySQL High Availability solutions.

There have been some notable changes …

[Read more]
Webinar recording: Mastering Galera Cluster, Best Practices and New Features

This exclusive webinar is tailored for database administrators and IT professionals aiming to enhance their systems’ efficiency and reliability using Galera Cluster. This session focuses on practical best practices, showcases new features, and provides an extended platform for your queries.

What You Will Learn:

* Core Best Practices: Dive into essential practices, from employing primary keys and leveraging InnoDB to deciding if to optimise read/write splits and managing AUTO_INCREMENT settings.

* Advanced Configuration: Uncover advanced techniques for error monitoring, configuring Galera across networks, and fine-tuning the gcache for optimal performance. * Innovative Features: Stay ahead with insights on implementing Non-Blocking Operations for seamless schema changes, coordinating distributed …

[Read more]
Galera Cluster for Debian 12 “bookworm” is now available

A little over a week ago, we released Galera Cluster for MySQL 8.0.35. Today, we have also made available binaries for Debian 12 “bookworm”.

As always we have binary installation documentation available, and if you are just after a quick install, the following is what is in your /etc/apt/sources.list.d/galera.list:

deb https://releases.galeracluster.com/galera-4.17/debian bookworm main
deb https://releases.galeracluster.com/mysql-wsrep-8.0.35-26.16/debian bookworm main

Happy installing, and the next step is to ensure that Debian 12 is enabled on Galera …

[Read more]
Galera Cluster for MySQL 5.7.44 and MySQL 8.0.35 released

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

[Read more]
Webinar: Upgrade Ihres MySQL 5.7 Galera Clusters auf MySQL 8.0 ohne Ausfallzeiten

Sie haben sicher schon davon gehört, dass MySQL 5.7 im Oktober 2023 das End of Life (EOL) erreicht hat. In diesem Webinar zeigen wir Ihnen, dass die Migration von MySQL 5.7 Galera Cluster nicht schwierig ist. MySQL 8.0 ist seit 5 Jahren allgemein verfügbar, und das Galera Cluster für MySQL 8.0 hat sich seit über 3 Jahren im Markt bewährt. Es ist also wirklich an der Zeit, sich auf die Migration vorzubereiten.

Im ersten Webinar dieser Reihe werden wir uns mit den neuen Funktionen von Galera Cluster mit MySQL 8 befassen:

* Die neuen Funktionen von Galera Cluster für MySQL 8, von denen Sie profitieren können, einschliesslich der in der Galera Cluster Enterprise Edition (EE) verfügbaren Funktionen
* Wie man eine Migration von MySQL 5.7 auf MySQL 8.0 plant
* Dinge, die vor der Migration getestet werden sollten
* Häufige Fallstricke bei einer solchen Migration
* Wie Sie sicherstellen, dass Ihr Galera …

[Read more]
Recovering nodes in a Galera Cluster

In our lab environment, we received some emails from our provider, DigitalOcean saying a few nodes would be going down, because of issues with the physical nodes. Since we run a 9-node Galera Cluster in the lab, across 3 regions (San Francisco, London and Singapore), this posed an interesting problem!


Upon connecting to one of the nodes, we see:

mysql> show status like 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 7     |
+--------------------+-------+
1 row in set (0.02 sec)

So we know that 2 of the nodes are down. Presuming you do not have any monitoring setup (might we recommend …

[Read more]
Galera Cluster for MySQL 5.7.43 and MySQL 8.0.34 released

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

[Read more]
Galera Cluster 5.7 (or older) to MySQL 8.0 migration training

Course Dates

Public course: EMEA timezone 26th of September. USA timezone 27th of September.

Company dedicated training or consulting session, request for dates for your company via email to: sales@galeracluster.com

Course Duration

1 day.  The breakdown is 3 hours, with a half hour lunch break, and another 3 hours per day. There will be bio-breaks. The total contact time with the trainer is 6 hours over a span of 1 day.

Requirements

  • You need to be able to use Zoom the platform we will be using
  • You will need to have access to an SSH client. Being in a Microsoft Windows environment is OK, but you need to have SSH to access the remote servers that we provide you access to.
  • Some basic understanding of Linux (e.g. package management) as well as MySQL
[Read more]
Showing entries 1 to 10 of 37
10 Older Entries »