Planet MySQL HA Blog

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

Using MySQL Shell to Get MySQL Diagnostic Information

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can gather a plethora of diagnostic data with a single command.

Learn More »

Monitoring: Prometheus and Grafana for MySQL Clustering with Tungsten

08/07/2024 | Continuent

Prometheus and Grafana are open source tools that can be used for monitoring MySQL clusters. Prometheus can be used to collect metrics from MySQL clusters, and Grafana can be used to visualize the metrics. Starting with Tungsten v7, using the new Tungsten Prometheus Exporter feature, it’s become easy to leverage the best of these powerful monitoring tools.

Part of the reason v7+ makes monitoring simpler is that Prometheus metrics are exported by default. Metrics are available for f

Learn More »

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 »

How to use passkeys to authenticate to MySQL

MySQL 9.1 adds support for Windows Hello. And this supports passkeys stored on the OS store. Check how to set up and use one of these instead of the hardware based FIDO2 devices

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 »

Pages