After a short hiatus, we hope to meet and see you at Percona Live Austin 2019 (28-30 May 2019), as we have sponsored the event and have a booth in the expo hall, in addition to having some talks.

Our CEO and co-founder Seppo Jaakola will have a talk titled Galera Cluster New Features, happening in room Texas 5, on Wednesday at 11.55AM – 12.45PM. It will be a very interesting talk as Galera Cluster 4 features have made there way into MariaDB Server 10.4, and you can expect to hear a little more about when Codership, the engineers and makers of Galera Cluster will provide a MySQL version.

If you happen to sign up for tutorials, do not miss …

Codership is pleased to announce a new Generally Available (GA) release of Galera Cluster for MySQL 5.6 and 5.7, consisting of MySQL-wsrep 5.6.43 and MySQL-wsrep 5.7.25 with a new Galera Replication library 3.26 (release notes, download), implementing wsrep API version 25. This release incorporates all changes to MySQL 5.6.43 (release notes, download) and 5.7.25 respectively (release notes, …

                In this blog post, I am going to explain an interesting issue which I faced in one of our client project . Few weeks back , I got an requirement from our support client to construct a new MariaDB Galera Cluster ( 10.2.21 ) and an async slave with GTID. The Complete requirement is as below.

• Need to construct the Galera cluster with 37 GB of data ( Using a given MySQL dump file )
• Have to configure an asynchronous slave under the 3 node Galera cluster
• The asynchronous slave was proposed with GTID to ease master node switchover.

So, as per the requirement the architecture will be, 

 Architecture  –

How to achieve this ?

A high level steps

• • Install MariaDB 10.2.21 server on all four nodes ( 3 Galera node with wsrep_on = ON & 1 async slave with …

The MySQL Server High Availability landscape provides with a slew of tools to help you ensure that your databases keep humming. Such tools are Galera Cluster, however, it is worth looking at semi-synchronous replication with failover tools, and also the usual leader-follower asynchronous replication. Today more workloads are moving to the cloud, and what failover options do you get with Amazon RDS for MySQL or even Aurora? What about the newfangled group replication and InnoDB Cluster? And let us not forget that Galera Cluster has spawned branches too!

Join Codership, the developers and experts of Galera Cluster,  as we discuss where Galera Cluster fits in and how to get best out of it.

EMEA webinar 9th April 10-11 AM CEST (Central European Time)
JOIN THE EMEA WEBINAR

USA webinar 9th April …

MariaDB OpenWorks happened February 25-27 2019 in New York City, and it was filled with a lot of activity.

The keynote by Michael Howard is an interesting watch, one with many quoted articles especially around “strip-mining open source technologies and companies,” and “abusing the license and privilege, and not giving back to the community.” Many articles were written about this topic, and it is clear that open source has arrived considering all the success around the IBM acquisition of Red Hat, the Elastic IPO, the Microsoft acquisition of GitHub, the SalesForce acquisition fo MuleSoft and the MongoDB IPO.

Seppo Jaakola talked about …

Recently MariaDB Galera Cluster 10.4.3 RC was announced – Galera MariaDB 10.4.3 RC

I would like to summarize overall reported issues related to Upgrade Tests from 10.3 version to 10.4.
In general we have 3 upgrade strategies:

* Provider upgrade – Upgrading only Galera
* Bulk upgrade – shut down all cluster and upgrade all nodes.
* Rolling Upgrade – Shut down nodes 1-by-1 and Upgrade sequentially.

There is great attention on smooth and safe Upgrade practices which is quite valid point for all users.
Let’s see what we have on Rolling Upgrade side.
Here is the list of FIXED issues:

https://jira.mariadb.org/browse/MDEV-18480 -> CLOSED
…

The much anticipated release of Galera 4 makes its way first in the latest release of MariaDB Server 10.4.3 Release Candidate which you can download now. Congratulations to MariaDB Corporation and MariaDB Foundation on this release candidate — please get testing Galera 4, and share your feedback with us via our Google Group discussion list! Do not forget that you can always reach us via email: mailto:info@galeracluster.com and via our contact us form.

The feature we are excited about the most, is a feature request from many users. This is none other than huge transaction …

Introduction –

Recently i worked on a production issue for one of our client under support .They have a architecture of a three node Galera cluster with one asynchronous slave .

• Node1 – 172.10.2.11
• Node2 – 172.10.2.12
• Node3 – 172.10.2.13
• Replica – 172.10.2.14

Architecture –

The slave(replica) was configured with node3 as replica master. Unfortunately the node 3 was crashed with an OOM killer ,also server has a low gcache size, so when i am trying to start the node 3 , it went to SST . Here the data size was around 2.6 TB , in general for completion of whole SST and joining the node back to cluster will take around  approximately 12 hours.

As i told earlier, the replication slave was under …

Codership is pleased to announce the release of Galera Replication library 3.25, implementing wsrep API version 25. The new release includes many bug fixes and fixes to all security issues mentioned in the Oracle Critical Patch Update Advisory – October 2018

As always, Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Red Hat, Debian, CentOS, OpenSUSE and SLES, as well as FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the easy deployment and upgrade of Galera Cluster nodes.

This release incorporates all changes up to MySQL 5.7.24, MySQL 5.6.42 and MySQL 5.5.62.

Galera Replication …

Let’s talk about MySQL high availability (HA) and synchronous replication once more.

It’s part of a longer series on some high availability reference architecture solutions over geographically distributed areas.

Part 1: Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?

Part 2: MySQL High Availability On-Premises: A Geographically Distributed Scenario

The Problem

A question I often get from customers is: How do I achieve high availability in case if I need to spread my data in different, distant locations? …