Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

Create an InnoDB Replica Set With MySQL Shell

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can create an InnoDB replica set with a few as two commands.

Learn More »

Galera Cluster for MySQL 8.4.2-26.20 beta preview released

08/06/2024 | Galera Cluster

Codership is pleased to announce a new beta preview release of the multi-master Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.2-26.20 (release notes, download), with Galera replication library 4.20 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.4.2, adding a synchronous option for your MySQL High Availability solutions.

One will notice that MySQL-wsrep 8.4.2-26.20 uses the same Galera replication library 4.20 which we r

Learn More »

Galera Cluster for MySQL 8.0.39-26.20 released

08/05/2024 | Galera Cluster

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.39-26.20 (release notes, download), with Galera replication library 4.20 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.39, adding a synchronous option for your MySQL High Availability solutions.

In the Galera replication library 4.20, some notable changes were made around improving

Learn More »

Essential MySQL Cluster Monitoring Using Nagios and NRPE

08/02/2024 | Continuent

In a previous post we went into detail about how to implement Tungsten-specific checks. In this post, we will focus on the other standard Nagios checks that would help to monitor the health of your cluster nodes.

Your database cluster contains your most business-critical data. The Replica nodes must be online, healthy and in sync with the Primary in order to be viable failover candidates.

This means keeping a close watch on the health of the database nodes using many perspectiv

Learn More »

Copy Data Directly To A MySQL Instance With MySQL Shell

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can copy data from one MySQL instance directly to another.

Learn More »

Using Lookahead & Lookbehind in MySQL Regular Expressions

Regular expressions are powerful but often misunderstood tools developers have at their disposal. In this post we discuss how to use lookahead and lookbehind to match, but not return, a pattern.

Learn More »

Galera Manager July 2024 Release

07/26/2024 | Galera Cluster

Codership is please to announce a new release of Galera Manager. The current installer stands at version 1.14.0 ((you can check this by typing: ./gm-installer version which will report gm-installer version 1.14.0 (linux/amd64)) and the actual Galera Manager GUI is at version 1.8.6. Users ill notice usability improvements, and fixes for issues filed at the galera-manager-support issue tracker.

One notable change that will affect users is the removal of support for CentOS 7. Please read What to know

Learn More »

MySQL Vector Datatype: create your operations (part 2)

In this article we see how we can create a component to add UDFs functions to deal with the VECTOR datatype in MySQL.

Learn More »

MySQL Vector Datatype: create your operations (part 1)

How to deal with VECTORS in MySQL HeatWave and Enterprise Edition using JavaScript

Learn More »

MySQL Shell Table Export Utility

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss some of the options available to when exporting table data to different formats.

Learn More »

Pages