Planet MySQL HA Blog

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

XA transactions now work in your Galera Cluster!

08/19/2024 | Galera Cluster

Well, that is more a catchy headline, than the reality: XA transactions work in your Galera Cluster Enterprise Edition (EE). This has been supported since our very first release with 8.0.28 Enterprise, right up till now, in 8.0.39 Enterprise. If you try to run an XA transaction in your regular Galera Cluster you’ll be given an error as such:

mysql> XA START 'xatest'; ERROR 1235 (42000): This version of MySQL doesn't yet support 'XA with wsrep replication plugin'

However, with Galera Cluster E

Learn More »

Where can you find MySQL during September - November 2024

list of MySQL conferences 9-11, 2024

Learn More »

Customizing The MySQL Shell Prompt

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can customize the prompt in MuSQL Shell.

Learn More »

Deploy WordPress, Joomla, and Drupal with HeatWave Always Free DB System in Oracle Cloud Infrastructure

HeatWave Always Free DB System makes it easier than ever to deploy and manage popular content management systems like WordPress, Joomla, and Drupal.

Learn More »

Policies for Bring Your Own Certificate (BYOC) in Oracle Cloud Infrastructure HeatWave MySQL

This post guides the user through the essential steps to set up BYOC related policies, including configuring dynamic groups, activating resource principals, and crafting the necessary policies within the Oracle Cloud Infrastructure (OCI) Certificates Service, to securely integrate user-defined certificates into your HeatWave MySQL environment.

Learn More »

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 »

Pages