Blog

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.

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

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

In this blog post we explore various options for performance tuning MySQL server for better replica replication performance.

In this blog post we will define what a split-brain scenario means in a MySQL database cluster, and then explore how a Tungsten MySQL database cluster reacts to a split-brain situation.

In this blog post, we will discuss how to use the Tungsten Connector keep-alive feature to ensure long-running MySQL & MariaDB/Percona Server client sessions stay connected in a Tungsten Cluster.

Cloud-based managed MySQL data services have become popular choices for businesses. While these services offer advantages, they also come with a host of drawbacks that can impact performance, control, and costs. This post explores these key drawbacks in detail and compares those to Tungsten Clustering running in the cloud, also multi-cloud, hybrid-cloud and on-premises.

MySQL has evolved significantly since its inception in 1995, becoming one of the most reliable and widely used open-source database solutions globally. Continuent has been instrumental in driving this evolution.

We are excited to announce the release of Tungsten Cluster & Tungsten Replicator v7.1.3, featuring new command enhancements, Ruby 3.2 support, and improved tools for better usability and stability. Additionally, several bug fixes address issues with command-line tools and monitoring.

While the MySQL Auto-Reconnect feature is both handy and interesting, it has to be used with great care, along with an understanding of the behavioral implications and side effects. In this blog post we will discuss some of the risks of using the MySQL driver Auto-Reconnect feature, and what happens when the Tungsten Connector internal version of it is enabled.

The Question

Recently, a customer asked us:

Why would heavy disk IO cause the Tungsten Manager and not MySQL to be starved of resources?

For example, we saw the following in the Manager log file tmsvc.log:

It is always a good idea to be mindful of open ports on your hosts, since they can be used by bad actors to gain access to your systems. For this reason, it is often desirable to prevent outside connections to the port whenever possible to prevent intrusions. For security purposes (and possibly PCI compliance), the Tungsten Connector proxy has the ability to bind to localhost/127.0.0.1 instead of listening on all available IP addresses via 0.0.0.0.