Monitoring | Tags | Blog

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 these powerful monitoring tools have to offer.

Eric M. Stone

Aug 07, 2024

Cluster Management, Deployment, Monitoring and Observability

Essential MySQL Cluster Monitoring Using Nagios and NRPE

This post covers some standard Nagios checks that would help keep your Tungsten cluster nodes running MySQL / MariaDB / Percona Server healthy.

Eric M. Stone

Aug 02, 2024

Cluster Management, Database Administration, Monitoring and Observability

MySQL Cluster Performance Validation via Load Testing

Your MySQL database cluster contains your most business-critical data; in this post, we discuss how to ensure proper performance under load.

Eric M. Stone

Jul 29, 2024

Performance

Tungsten Cluster: Move MySQL Writes to Another Cluster in One Easy Step

One of the great powers of the Tungsten Cluster is that the writable Primary role can be moved to another node or cluster at will. When dealing with composite clusters and moving the Primary to another site entirely, there are different actions to take depending on the topology. In this blog post we will compare the procedures for moving the Primary role from one Composite cluster to another peer Composite cluster.

Eric M. Stone

Feb 14, 2023

Cluster Management, Database Administration

Tungsten Cluster: How Does Failover Work? Part 1 of 3

Did you ever wonder just what the Tungsten Manager is thinking when it does an automatic failover or a manual switch in a cluster? What factors are taken into account by the Manager when it picks a replica to fail over to? This blog post will detail the steps the Manager takes to perform a switch or failover. We will cover both the process and some possible reasons why that process might not complete, along with best practices and ways to monitor the cluster for each situation.

Eric M. Stone

Jan 25, 2023

Cluster Management, Database Administration

New Command for Tungsten: tungsten_get_ports

Tungsten Clustering contains many tools to monitor your cluster, and today we will look at a new one - the `tungsten_get_ports` command, included with Tungsten versions 6.1.20+ and 7.0.2+. This tool was created to help provide a clear view of running Tungsten processes and the associated listener ports.

Eric M. Stone

Dec 29, 2022

Cluster Management, Database Administration, Monitoring and Observability

New Command for Tungsten: tungsten_get_status

Tungsten Clustering contains many tools to monitor your cluster, and today we will look at a new one - the `tungsten_get_status` command, included with Tungsten versions 6.1.19+ and 7.0.2+. This tool was created in response to a customer request for a simple script that could display the status of all nodes cluster-wide for any topology from a single place. The status includes the datasource and replicator layers along with the policy for each cluster.

Eric M. Stone

Oct 11, 2022

Cluster Management, Database Administration, Monitoring and Observability

Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster

Tungsten Clustering provides high availability, disaster recovery, and a host of other benefits for MySQL / MariaDB / Percona Server databases. In this blog post we will explore some of the shell aliases I use every day to administer various Tungsten Clusters.

Eric M. Stone

Jul 16, 2019

Database Administration, Cluster Management, Native

The Important Role of a Tungsten Rollback Error

This blog explains why the Tungsten rollback error exists and why it's important.

Eric M. Stone

May 24, 2019

Geographic Distribution and Geo-Scale

Understanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server

In this blog post we will discuss how the managed cross-site replication streams work in a Composite Multi-Master Tungsten Cluster for MySQL, MariaDB and Percona Server.

Eric M. Stone

May 22, 2019

Geographic Distribution and Geo-Scale

SSH Differences Between Staging and INI Configuration Methods

This blog covers INI vs Staging configurations for Secure Shell.

Eric M. Stone

May 07, 2019

Tungsten University, Geographic Distribution and Geo-Scale

How to Integrate Tungsten Clustering Monitoring Tools with PagerDuty Alerts

In this blog post we will discuss how to best integrate various Continuent-bundled cluster monitoring solutions with PagerDuty (pagerduty.com), a popular alerting service.

Eric M. Stone

Apr 23, 2019

Tungsten University, Database Administration, Monitoring and Observability, Native, Performance

Blog

Categories

Series

Monitoring: Prometheus and Grafana for MySQL Clustering with Tungsten

Essential MySQL Cluster Monitoring Using Nagios and NRPE

MySQL Cluster Performance Validation via Load Testing

Tungsten Cluster: Move MySQL Writes to Another Cluster in One Easy Step

Tungsten Cluster: How Does Failover Work? Part 1 of 3

New Command for Tungsten: tungsten_get_ports

New Command for Tungsten: tungsten_get_status

Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster

The Important Role of a Tungsten Rollback Error

Understanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server

SSH Differences Between Staging and INI Configuration Methods

How to Integrate Tungsten Clustering Monitoring Tools with PagerDuty Alerts

Blog

Categories

Series

Monitoring: Prometheus and Grafana for MySQL Clustering with Tungsten

Essential MySQL Cluster Monitoring Using Nagios and NRPE

MySQL Cluster Performance Validation via Load Testing

Tungsten Cluster: Move MySQL Writes to Another Cluster in One Easy Step

Tungsten Cluster: How Does Failover Work? Part 1 of 3

New Command for Tungsten: tungsten_get_ports

New Command for Tungsten: tungsten_get_status

Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster

The Important Role of a Tungsten Rollback Error

Understanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server

SSH Differences Between Staging and INI Configuration Methods

How to Integrate Tungsten Clustering Monitoring Tools with PagerDuty Alerts

Pages