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.40 (release notes, download) and MySQL-wsrep 8.0.31 (release notes, download) with Galera replication library 4.14 (release notes, download) implementing wsrep API version 26. …[Read more]
10 Older Entries »
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 …[Read more]
Mobile World Congress (MWC), the world’s leading event is all set to unite the global mobile and telecoms industry in Barcelona, Spain from 27 February – 2 March 2023. In this framework, Codership is glad to announce that it has been selected by the European Innovation Council to join the EIC Pavilion. The 20 most promising EIC-funded SMEs, startups and scale ups have an unprecedented opportunity to impress the international audience with their game-changing innovations and establish business partnerships with like-minded counterparts.
The EIC Pavilion will feature a wide variety of extraordinary innovations in crucial sectors, such as Artificial Intelligence, Robotics, Machine Learning and IoT, among others. From interactive sessions and expert panel …[Read more]
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 …[Read more]
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 …[Read more]
We recently covered Upgrading your Galera Cluster from MySQL 5.7 to MySQL 8.0. We’ve also had questions on how the upgrade path from our usual Galera Cluster “community” edition to the Galera Cluster Enterprise Edition (EE), which includes many new features, like XA transaction support, arm64 support or GCache encryption.
First off, let’s start by installing a Galera Cluster on CentOS 7. The reason we have picked this distribution? Let’s edit the /etc/yum.repos.d/galera.repo and add:
[galera4] name = Galera baseurl = https://releases.galeracluster.com/galera-4/centos/7/x86_64 gpgkey = https://releases.galeracluster.com/GPG-KEY-galeracluster.com gpgcheck = 1 [mysql-wsrep8] name = MySQL-wsrep baseurl = https://releases.galeracluster.com/mysql-wsrep-8.0/centos/7/x86_64 gpgkey = …
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.30 (release notes, download) with Galera replication library 4.13 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.30, adding a synchronous option for your MySQL High Availability solutions.
For the Galera replication library 4.13, we now complete the I/O for the client handshake before starting an asynchronous read to fix …[Read more]
Recently we had a question on getting your Galera Cluster upgraded from MySQL 5.7 to MySQL 8.0. While we have plenty of extensive documentation on Upgrading Galera Cluster, this blog covers the Linux example for a rolling major upgrade (the procedure is documented, but this is more extensive). So we will describe going from MySQL 5.7.23 to MySQL 8.0.28 on one node. We did this on CentOS 7.
Firstly, let’s start by disabling SELinux by executing setenforce 0.
We need to install the appropriate MySQL 5.7 binaries, so we can grab them from releases.galeracluster.com. Since we have decided on MySQL 5.7.23, we should get the packages from …[Read more]
Continuing on from Setting up Galera Load Balancer (GLB), wouldn’t it be nice to ensure that Galera Load Balancer (GLB) handles failover, seamlessly?
Router: ------------------------------------------------------ Address : weight usage map conns 188.8.131.52:3306 : 1.000 0.500 N/A 1 184.108.40.206:3306 : 1.000 0.500 N/A 1 220.127.116.11:3306 : 1.000 0.000 N/A 0 ------------------------------------------------------ Destinations: 3, total connections: 2 of 493 max Pool: connections per thread: 1 1 0 0 0 0
Here is an example of a Galera Load Balancer (GLB) handling 3 backend MySQL servers, and it currently has 2 connections, evenly distributed between 2 hosts.
We can verify this by doing: select @@hostname; which shows:…[Read more]
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.38 (release notes, download). This release incorporates all changes to MySQL 5.7.39, adding a synchronous option for your MySQL High Availability solutions.
We have backported the InnoDB wsrep applier lock wait timeout from 8.0 which introduces the variable innodb-wsrep-applier-lock-wait-timeout to improve the reliability in resolving …[Read more]
10 Older Entries »