Galera Manager supports three modes for supporting your Percona XtraDB Clusters: deploying to either Amazon Web Services, deploying to your own on premises hosts, and also just monitoring your clusters. In this blog post, we will go thru houw you should deploying a 3-node Percona XtraDB Cluster via Galera Manager on Amazon Web Services Elastic Compute Cloud (AWS EC2). You will realise that this process happens with just a simple API key and instance selection, so effectively you can have a Galera Manager setup in under fifteen minutes!

On AWS EC2, it is worth noting that Galera Manager itself can be deployed on the free tier for testing purposes. However, in production environments, you might expect up to 100GB of logs on a monthly basis, so you should plan accordingly.

Obtain Galera Manager by …

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 …

The momentum around Galera Manager development has been amazing. You report bugs or feature requests, and we fix them!

The major reason to release this was to ensure that Galera Manager would accept the new signing keys of Galera Cluster (key ID: 8DA84635).

One will now also note that gm-installer reports a new version: gm-installer version 1.12.0 (linux/amd64). And when you install it, Galera Manager itself is now at version 1.8.3. One of the major fixes is that Ubuntu 22.04 support for self-provided hosts is now exposed in the UI. This fixes …

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 …

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 …

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 …

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 …

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
…

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.42 (release notes, download) and MySQL-wsrep 8.0.33 (release notes, download), with Galera replication library 4.15 (release notes, download) implementing wsrep API version …

We are sure you’ve probably already heard that MySQL 5.7 is going to reach End of Life (EOL) by October 2023. We are here to tell you that the migration from MySQL 5.7 need not be scary — MySQL 8.0 has been Generally Available for five years, and the Galera Cluster product for it, has been hardened for over three years, so it is truly time to get ready to migrate.

In our first session of the series, we are going to cover:
* the new features of Galera Cluster with MySQL 8 that you might benefit from, including what is available in Galera Cluster Enterprise Edition (EE)
* how to plan a migration from MySQL 5.7 or older to 8.0
* things to test for, before migrating
* common pitfalls of said migration
* how to ensure your Galera Cluster keeps humming along with no downtime

We also offer migration support to help you before and during your migration, after-which our regular support plan will cover …