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 …

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 …

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 …

We will have a kiosk at Moscone Center, south exhibition hall, Oracle’s Data Management area number 123, close to high availability area and exits 16 and 18. Our kiosk number is DBA-P1.

Our CEO and Co-Founder Seppo Jaakola will host a presentation highlighting the main features of our upcoming Galera Cluster 4.0. The presentation will take place Monday, Oct 22, 1:00 p.m. – 1:20 p.m at the Exchange @ Moscone South – Theater 2. Seats are limited!

Come and meet us! Let’s discuss your MySQL high availability plan or your Galera Cluster deployment. If you want to set up a meeting with us please email to ínfo@galeracluster.com for a meeting request.

Codership is pleased to announce the release of Galera Replication library 3.24, implementing wsrep API version 25.  The new release includes improved deadlock error management with foreign keys and security fixes. 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.23, MySQL 5.6.41 and MySQL 5.5.61.

Galera Replication Library 3.24
New features and notable fixes in Galera replication since last binary release by Codership (3.23)

* A support for new …

Galera Cluster is the leading high availability solution for MySQL and MariaDB. We are always looking for bright and driven people who have a passion for technology, especially for database replication and clustering. If you are interested in challenging work, being part of a innovative team and world’s leading MySQL clustering company-then Codership is right place for you!  This is a remote job.

Job Description and Responsibilities

• Write Galera Cluster technical marketing material (blogs, white papers, benchmarks)
• Prepare presentations and present at webinars and conferences
• Be active in social media channels and forums
• Consult customers for Galera Cluster best practices
• Pre-sales support
• Interface with the development team to provide user feedback
• Assist in writing Galera documentation

…

In the previous article we researched MySQL Client / Server Protocol using WireShark. Now lets start to write our codes in python to simulate MySQL native client. Ready codes are here: Github repo

First of all we have to create MYSQL_PACKAGE class. MYSQL_PACKAGE class is the parent of all other package classes (HANDSHAKE_PACKAGE, LOGIN_PACKAGE, OK_PACKAGE and etc.)

class MYSQL_PACKAGE: “””Data between client and server is exchanged in packages of max 16MByte size.”””    def __init__(self, resp= b”):       self.resp = resp       self.start =0       …

MySQL Client / Server protocol is used in many areas. For example:

• MySQL Connectors like ConnectorC, ConnectorJ and etc.
• MySQL proxy
• Between master and slave

What is MySQL Client / Server protocol?

MySQL Client / Server protocol is accepted conventions (rules). Through these rules client and server “talks” and understand each other. Client connects to server through TCP connection with special socket, sends to server special packets and accepts them from server. There are two phases of this connection:

• Connection phase
• Command phase

Next illustration describes phases:

STRUCTURE OF PACKETS

Each packet consists of valuable data types. Maximum length of each packet can be 16MB. If the length of packet is more than 16MB, then it is separated into several chunks (16MB). First of all let’s see the protocol data types. …

Codership is pleased to announce the release of Galera Replication library 3.23, implementing wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.21, MySQL 5.6.39 and MySQL 5.5.59, including several fixes to vulnerabilities reported by Oracle in here.

New features and notable fixes in Galera replication since last binary release
by Codership (3.22):

• Write set serialization has been changed to use proper memory alignment in order to avoid crashes on platforms which do not allow unaligned memory access (http://www2.galeracluster.com/e/38852/codership-galera-issues-445/88b8yp/875788176)

Notable bug fixes in MySQL 5.7.21: …

“Our three megastores’ and webshop’s combined revenue was 432 million euros in the year 2017. Galera Cluster has been the cornerstone of the system, secured our sales and supported our growth.”

“MySQL master/slave setup was just too fragile and needed regular work to fix each time the slave got out of sync. Now with Galera we’ve found that even if we take a node offline for a while, it re-syncs automatically and without intervention.”

“The big plus is that all nodes have exact the same information, and no node is running for even a fraction of a second behind. This will also mean that no information will be lost!”

READ MORE CASE STUDIES AND TESTIMONIALS