The goal of this tutorial is to show you how to use multi-master to aggregate databases with the same name, but different data from different masters, on the same slave.

Example :

• master1 => a French subsidiary
• master2 => a British subsidiary

Both have the same database PRODUCTION but the data are totally different.

This screenshot is made from my own monitoring tool: PmaControl. You have to read 10.10.16.232 on master2 and not 10.10.16.235.
The fault of my admin system! :p)

We will start with three servers—2 masters and 1 slave—you can add more masters if needed. For this tutorial, I used Ubuntu 12.04. I’ll let you choose the right procedure for your distribution from Downloads.

Scenario

…

Use the opportunity to talk to Galera Cluster developers and experts. Visit Galera Cluster booth at Conrad Hotel, New York City February 26-27. We will be happy to answer your questions and verify your Galera deployment plans.

There are many Galera Cluster presentations at the conference.

Under the Hood: Galera Cluster

Seppo Jaakola, CEO Codership

Tuesday 27th, 8:40 am – 9:30 am

This session will provide attendees with common use cases for clustering, a comprehensive explanation of how clustering works with Galera and introduce new features and improvements available in Galera Cluster 4.

Global Data Replication with Galera for Ansell Guardian

Greg Henderson and Louis Zircher

Monday 26th, 4:00 pm – 4:50 pm

In early 2017, we seamlessly replaced the global geo-distributed data synchronization …

“We wanted a solution which was backward compatible with our frameworks, as we have used mainly MySQL, which was reliable and nearly 100% data consistent.  If our application were to execute a commit and receive a successful response, we needed a 100% guarantee that we have rows of data in our database — and for more than that one instance.”

There were many options E-CARD explored. “First, we tried MySQL NDB Cluster. That was a very frustrating experience. After that we tried a few other plugins and extensions of MySQL, but they weren’t complete solutions. At the end of this process, we found Galera with MySQL. It responded to our needs nearly 100% of the time.”

Read the full story

Bulgarian National Lottery chooses Galera Cluster

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.58, 5.6.38, 5.7.20 and new Galera 3.22 library, wsrep API version 25.

NEW FEATURES AND NOTABLE FIXES IN THE GALERA REPLICATION LIBRARY SINCE LAST BINARY RELEASE BY CODERSHIP (3.21):

New features and notable fixes in Galera replication since last binary release

* Reporting last committed write set fixed to respect commit ordering (MW-341)

* GComm socket level error handling improved to avoid backend thread exit
in case of unexpected input from ASIO IO service (GAL-518)

* Race condition fixed in GComm message sending codepath (GAL-520)

* Fix for EVS protocol stall due to exhausted send window setting. This
bug could stall cluster messaging until the next keepalive was sent by
some node, causing …

Since its creation, Galera Cluster has established itself as the most popular high availability solution for MySQL and MariaDB users worldwide.

ClusterControl is the go-to automation and management system for Galera Cluster users.

And together, we’re going to walk you through all the different aspects that make Galera Cluster such a popular high availability solution for MySQL and MariaDB and how to best manage it with ClusterControl.

We’ll hear about the latest features of Galera Cluster directly from Codership, the creators of Galera Cluster. And we’ll look at how to automate everything from deployment, monitoring (how about ASCII-art graphs?), backups, failover, recovery, rolling upgrades and scaling using the ClusterControl CLI (for a change, we also have a GUI of course).

AGENDA

Introduction
About Codership, the makers of Galera Cluster
About Severalnines, the makers of …

Since its creation, Galera Cluster has established itself as the most popular high availability solution for MySQL and MariaDB users worldwide.

ClusterControl is the go-to automation and management system for Galera Cluster users.

And together, we’re going to walk you through all the different aspects that make Galera Cluster such a popular high availability solution for MySQL and MariaDB and how to best manage it with ClusterControl.

We’ll hear about the latest features of Galera Cluster directly from Codership, the creators of Galera Cluster. And we’ll look at how to automate everything from deployment, monitoring (how about ASCII-art graphs?), backups, failover, recovery, rolling upgrades and scaling using the ClusterControl CLI (for a change, we also have a GUI of course).

AGENDA

Introduction
About Codership, the makers of Galera Cluster
About Severalnines, the makers of …

Join Galera Cluster team!  Both jobs are key positions at Codership. You will influence a great deal to Galera Cluster user experience.  We have thousands of users.

Galera Cluster QA Engineer

The QA Engineer/release manager will be responsible for working with the development team at Codership and create and execute tests, make builds of Galera Cluster and develop and extend test automation frameworks.

You will be also working closely with MariaDB development and quality assurance teams to prioritize software bug fixes.

Tasks

• Continuously refine the QA process to improve product quality
• Troubleshoot and work with the development team to isolate issues
• Create and maintain automated tests
• Make Galera software builds (our build pipeline uses python, Jenkins, Docker and Qemu)
• Assist customers with their …

Codership is pleased to announce a new release of Galera Cluster for MySQL
consisting of MySQL-wsrep 5.7.18, 5.6.36, 5.5.55 and Galera 3.21, wsrep API
version 25.

Changes to Repositories Structure

With the new release the repository structure is changed to allow for
existence of all of the wsrep-patched mysql versions currently supported:
5.5 through 5.7.

Thus the repository layout requires from the user to adjust his or her
repository configuration to accomodate those changes. In order to have the
MySQL-wsrep and Galera library installed, one would need to add the following
repositories:

1. Galera-3 repository for galera library:
e.g. http://releases.galeracluster.com/galera-3/DIST/

Here DIST is Linux distribution (ubuntu, centos, …).

The latest version of Galera for FreeBSD is available in FreeBSD Ports
…

The white paper shares lessons learned from a careful, component level analysis of China Mobile’s 1000-node OpenStack cloud. They uncovered three major issues in the course of this study, all addressed through OpenStack configuration changes. The result: a more stable and performant China Mobile OpenStack cloud and insights into scale bottlenecks and areas for future work.

Read the full story: Analyzing and Tuning China Mobile’s OpenStack Production Cloud white paper below

performance_analysis_and_tuning_in_china_mobiles_openstack_production_cloud_2

Codership QA Engineer

The QA Engineer/release manager will be responsible for working with the development team at Codership and create and execute tests, make builds of Galera Cluster and develop and extend test automation frameworks.

You will be also working closely with MariaDB development and quality assurance teams to prioritize software bug fixes.

Tasks

• Continuously refine the QA process to improve product qualitY
• Troubleshoot and work with the development team to isolate issues
• Create and maintain automated tests
• Make Galera software builds (our build pipeline uses python, Jenkins, Docker and Qemu)
• Assist customers with their questions and support tickets

Desired Skills and Experience

• 3 years of experience in QA on Linux
• Proven record of implementing test …