Planet MySQL HA Blog
Using MySQL Shell to Get MySQL Diagnostic Information
Monitoring: Prometheus and Grafana for MySQL Clustering with Tungsten
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
Create an InnoDB Replica Set With MySQL Shell
Galera Cluster for MySQL 8.4.2-26.20 beta preview released
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
Galera Cluster for MySQL 8.0.39-26.20 released
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
Essential MySQL Cluster Monitoring Using Nagios and NRPE
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
Copy Data Directly To A MySQL Instance With MySQL Shell
How to use passkeys to authenticate to MySQL
Using Lookahead & Lookbehind in MySQL Regular Expressions
Galera Manager July 2024 Release
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