multi-master

Bulgarian National Lottery chooses Galera Cluster

“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

Announcing Galera Cluster for MySQL 5.5.58, 5.6.38, 5.7.20 with Galera 3.22.

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 intermittent pauses in write set replication. (GAL-521)
* Code changes to avoid name collisions with FreeBSD system headers (GAL-523)
Read the full release notes (how to install, repository structure) 
 
 
NOTABLE BUG FIXES IN MYSQL-WSREP:
 
Version MySQL-wsrep 5.7.20 and Galera 3.22, wsrep API version 25.
* Preserve –wsrep-recover log for future reference when starting the server.
The preserved log is stored in a file under MySQL data directory,
either in wsrep_recovery.ok or wsrep_recovery.fail depending on recovery
success. (MW-318)
* Avoid returning outdated values for wsrep_ready status variable (MW-384)
* A bug which caused stored procedure with an error handler to commit
a statement even in case of certification error was fixed. (MW-388)
* Crash during LOAD DATA for partition engine was fixed (MW-394)
* Fixed a crash caused by a dangling reference to wsrep status variables
array. (MW-399)
* Fixes to processing of foreign key cascades. (MW-402)
* ACL checks are now enforced before replication for all DDL operations
(MW-416)
* ALTER EVENT statement failure on slave was fixed (MW-417)
Read the full release notes  (known issues, how to install, repository structure) 
 
 
Version MySQL-wsrep 5.6.38 and Galera 3.22, wsrep API version 25
* Preserve –wsrep-recover log for future reference when starting the server.
The preserved log is stored in a file under MySQL data directory,
either in wsrep_recovery.ok or wsrep_recovery.fail depending on recovery
success. (MW-318)
* Avoid returning outdated values for wsrep_ready status variable (MW-384)
* A bug which caused stored procedure with an error handler to commit
a statement even in case of certification error was fixed. (MW-388)
* Crash during LOAD DATA for partition engine was fixed (MW-394)
* Fixed a crash caused by a dangling reference to wsrep status variables
array. (MW-399)
* Fixes to processing of foreign key cascades. (MW-402)
* ACL checks are now enforced before replication for all DDL operations
(MW-416)
Read the full release notes (known issues, how to install, repository structure)

 
 
Version MySQL-wsrep 5.5.58 and Galera 3.22, wsrep API version 25
Notable bug fixes in MySQL-wsrep:
* Avoid returning outdated values for wsrep_ready status variable (MW-384)
* Crash during LOAD DATA for partition engine was fixed (MW-394)
* Fixes to processing of foreign key cascades. (MW-402)
* ACL checks are now enforced before replication for all DDL operations
(MW-416)
Read the full release notes (known issues, how to install, repository structure)
 

Joint Webinar with Severalnines: How to manage Galera Cluster using ClusterControl

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 ClusterControl
What’s new with Galera Cluster
Core feature set overview
What’s coming up
ClusterControl for Galera Cluster
Deployment
Monitoring
Management
Scaling
Live Demo
Q&A
 
Join EMEA timezone webinar Tue November 14, 10 AM CET
 
Join USA timezone webinar Tue November 14, 9 AM PST
 
Presenting:
Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.
Seppo Jaakola, Codership CEO

Joint Webinar with Severalnines: How to manage Galera Cluster using ClusterControl

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 ClusterControl
What’s new with Galera Cluster
Core feature set overview
What’s coming up
ClusterControl for Galera Cluster
Deployment
Monitoring
Management
Scaling
Live Demo
Q&A
 
Join EMEA timezone webinar Tue November 14, 10 AM CET
 
Join USA timezone webinar Tue November 14, 9 AM PST
 
Presenting:
Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.
Seppo Jaakola, Codership CEO
 

Galera Cluster is looking for Quality Assurance Engineer and C++ Software Developer

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 questions and support tickets

Desired Skills and Experience

3 years of experience in QA on Linux
Proven record of implementing test automation in a scalable, sustainable manner
Experience in designing, documenting, and analyzing test cases
Familiarity with RDBMS problematics (MySQL in particular)
Familiarity with C/C++ languages and ability to interpret gdb dumps
Fluent English

 
The position also offers an opportunity to take on other roles within the company, such as giving conference presentations and webinars, writing documentation content and blog posts.
 
Senior Software Developer
We are looking for someone with 3-5 years of C++ programming experience (linux) and preferably distributed computing experience as well. A solid understand of SQL databases and replication technology is a must and a good understanding of MySQL and InnoDB is an advantage.
Beyond those technical skills you really ought to be confident with all other aspects software development and testing.

Good English is required as all communication is done remotely so you must be able to understand what we require and vice versa.
We work remotely with face-to-face meetings 2-3 times per year.

 
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.
 
SEND YOUR APPLICATIONS AND CV TO JOBS@GALERACLUSTER.COM

Announcing Galera Cluster 5.7.18, 5.6.36 and 5.5.55 with Galera 3.21. Improvements to IPv6 Support, Bug Fixes and Changes to Repositories Structure

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
Collection. Go to https://www.freebsd.org/cgi/ports.cgi?query=Galera&stype=all
2. Corresponding MySQL-wsrep repository:
e.g. http://releases.galeracluster.com/mysql-wsrep-MVERSION/DIST
Here DIST is Linux or BSD distribution (ubuntu, centos, …) and MVERSION is
MySQL version, i.e. 5.5, 5.6, 5.7
How To Install
Repositories contain dummy or meta packages, called mysql-wsrep-MVERSION
which are convenience packages for installation of the corresponding version
of WSREP. One can install the whole suite by running, for example:
`apt-get install mysql-wsrep-5.6 galera-3`
Quirks for Ubuntu Xenial and 5.6
Due to the peculiarities of how apt resolves packages and presence of 5.7
libraries in Xenial repositories the command above might require additional
steps/changes in order to succeed.
One would need to either configure apt pinning for codership repositories for
them to have priority over upstream packages or to specify mysql-common package
version explicitly as the one located in the WSREP repositories in order to get
things installed.
For more detailed installation instructions, please refer to documentation
in http://galeracluster.com/documentation-webpages/.
 
NEW FEATURES AND NOTABLE FIXES IN THE GALERA REPLICATION LIBRARY SINCE LAST BINARY RELEASE BY CODERSHIP (3.21):
* Galera now considers umask when creating gcache files
(GAL-505, codership/galera#449)
* Clean abort is ensured when core piping is used (GAL-505)
* Node state is marked unsafe when slave executes TOI (GAL-504)
* A bug in send monitor that could cause the node to stop replicating under
heavy write load has been fixed. (GAL-495)
* URI parsing has been improved for IPv6 addresses. Now Galera accepts addresses in IPv6 notation
(GAL-501, GAL-338, codership/galera#338)
* GCache recovery fixes (GAL-494, GAL-500)
* IST progress is reported in the log (GAL-491)
* Improved build time checks for ASIO version (GAL-510)
 
NOTABLE BUG FIXES IN MYSQL-WSREP:
Version 5.7.18-25.12:
* Fix for thread leak when changing the value of wsrep_slave_threads
(MW-336)
* The issue of DROP TABLE containing temporary tables resulting in binlog
divergence has been fixed (MW-360)
* RESET MASTER is now rejected if the wsrep provider is enabled and
gtid_mode is ON (MW-362)
* InnoDB buffer pool is not dumped anymore at server shutdown when
–wsrep-recover option is given (MW-365)
* Improved IPv6 support. Now MySQL-wsrep accepts addresses in IPv6 notation (MW-366)
* Fixes for certfication key generation in the presence of foreign key
constraints (MW-369)
* Fix to debug assertion MW-379
* SHOW STATUS will not block anymore with wsrep_sync_wait=1 (MW-86)
 
Version 5.6.36-25.20:
* CREATE TABLE AS SELECT fixes (MW-317, MW-322)
* Fix for thread leak when changing the value of wsrep_slave_threads
(MW-336)
* The issue of DROP TABLE containing temporary tables resulting in binlog
divergence has been fixed (MW-360)
* RESET MASTER is now rejected if the wsrep provider is enabled and
gtid_mode is ON (MW-362)
* InnoDB buffer pool is not dumped anymore at server shutdown when
–wsrep-recover option is given (MW-365)
* Improved IPv6 support. Now MySQL-wsrep accepts addresses in IPv6 notation (MW-366)
* Fixes for certfication key generation in the presence of foreign key
constraints (MW-369)
* SHOW STATUS will not block anymore with wsrep_sync_wait=1 (MW-86)
Version 5.5.55-25.21:
* CREATE TABLE AS SELECT fixes (MW-322)
* Fixes for certfication key generation in the presence of foreign key
constraints (MW-369)
* SHOW STATUS will not block anymore with wsrep_sync_wait=1 (MW-86)
 
KNOWN ISSUES WITH THIS RELEASE:
Server cannot be started using ‘service’ command on Debian Stretch.
For Galera Cluster 5.6:
If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped
using systemd. Please use the SysV init script with the ‘bootstap’ option to
bootstrap the node. Note that a server that has been started that way can not
be controlled via systemd and must be stopped using the SysV script. Normal
server startup and shutdown is possible via systemd.
For Galera Cluster 5.7:
SST between 5.6 and 5.7 nodes is not supported;
The –wsrep-replication-bundle option has no effect and may be removed in a
future release
InnoDB tablespaces outside of the data directory are not supported, as they
may not be copied over during SST
Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=0 may be used to
disable DTrace

China Mobile & Intel Deploy Galera for 1000-Node OpenStack Cloud

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

Emea Webinar-Galera Cluster® Best Practices for DBAs and DevOps Part 3: DDLs and Schema Upgrades Feb 21st

Description
 
In this part of the webinar series on best practices for Galera Cluster, we will discuss schema changes and DDL.
We will show how Galera Cluster executes DDLs in a safe, consistent manner across all the nodes in the cluster, and the differences with stand-alone MySQL. We will discuss how to prepare for and successfully carry out a schema upgrade and the considerations that need to be taken into account during the process.
 
Time: 11-12 AM EEST (Eastern Europe Standard Time), 21st of February
Speakers: Philip Stoev, Quality and Release Manager, Codership                Sakari Keskitalo, COO, Codership
REGISTER TO THE EMEA TIMEZONE WEBINAR

USA Webinar-Galera Cluster® Best Practices for DBAs and DevOps Part 3: DDLs and Schema Upgrades Feb 21st

Description In this part of the webinar series on best practices for Galera Cluster, we will discuss schema changes and DDL.We will show how Galera Cluster executes DDLs in a safe, consistent manner across all the nodes in the cluster, and the differences with stand-alone MySQL. We will discuss how to prepare for and successfully carry out a schema upgrade and the considerations that need to be taken into account during the process.The webinar will conclude with a Q&A session where you can ask any questions you may have about Galera Cluster.Time: 9-10 AM PST (Pacific time zone), 21st of  FebruarySpeakers: Philip Stoev, Quality and Release Manager, Codership                Sakari Keskitalo, COO, CodershipREGISTER TO USA TIME ZONE WEBINAR

MySQL Group Replication vs. Multi Source

In my previous post, we saw the usage of MySQL Group Replication (MGR) in single-primary mode. We know that Oracle does not recommends using MGR in multi-primary mode, but there is so much in the documentation and in presentations about MGR behavior in…

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569