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. It was filled with plenty of activity.
The keynote by Michael Howard, C.E.O. of MariaDB, 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’s clear that open-source has arrived considering all of the success around the IBM acquisition of Red Hat, the Elastic I.P.O., the Microsoft acquisition of GitHub, the SalesForce acquisition fo MuleSoft and the MongoDB I.P.O.
Seppo Jaakola, the C.E.O. of Codership, talked about …
[Read more]
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 …
[Read more]
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 …
[Read more]Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell.
MySQL Shell
This is the last component in the cluster and I love it. Oracle have created this tool to centralize cluster management, providing a friendly, command-line based user interface.
The tool can be defined as an advanced MySQL shell, which is much more powerful than the well known MySQL client. With the capacity to work …
[Read more]MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router. We will address MySQL Shell in a final instalment of this three-part series. By then, you should have a good overview of the features offeed by MySQL InnoDB Cluster.
MySQL Router
This component is responsible for distributing the traffic between members of the cluster. It is a proxy-like solution to hide cluster topology from applications, so applications don’t …
[Read more]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 …
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
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: 9-10 AM PST (Pacific time zone), 21st of
February
Speakers: Philip Stoev, Quality and Release Manager, Codership Sakari Keskitalo, COO, Codership