The Important Role of a Tungsten Rollback Error

Author: , May 24th, 2019

The Question Recently, a customer asked us: What is the meaning of this error message found in trepsvc.log? 2019/05/14 01:48:04.973 | | [east – binlog-to-q-0] INFO pipeline.SingleThreadStageTask Performing rollback of possible partial transaction: seqno=(unavailable) Simple Overview The Skinny This message is an indication that we are dropping any uncommitted or incomplete data read from […]

Performance Tuning Tungsten Replication to MySQL

Author: , May 21st, 2019

The Question Recently, a customer asked us: Why would Tungsten Replicator be slow to apply to MySQL? The Answer Performance Tuning 101 When you run trepctl status and see: appliedLatency : 7332.394 like this on a slave, it is almost always due to the inability for the target database to keep up with the applier. […]

SSH Differences Between Staging and INI Configuration Methods

Author: , May 7th, 2019

The Question Recently, a customer asked us: If we move to using the INI configuration method instead of staging, would password-less SSH still be required? The Answer The answer is both “Yes” and “No” No, for installation and updates/upgrades specifically. Since INI-based configurations force the tpm command to act upon the local host only for […]

How to Integrate Tungsten Clustering Monitoring Tools with PagerDuty Alerts

Author: , April 23rd, 2019

Overview The Skinny In this blog post we will discuss how to best integrate various Continuent-bundled cluster monitoring solutions with PagerDuty (, a popular alerting service. Agenda What’s Here? Briefly explore the bundled cluster monitoring tools Describe the procedure for establishing alerting via PagerDuty Examine some of the multiple monitoring tools included with the Continuent […]

How To Test Nagios Remote NRPE Commands

Author: , September 27th, 2018

There are many things to configure in Nagios, especially when using custom check commands. Recently I needed to configure all of the Continuent Clustering Nagios checks. Once setup on the database side, I wanted to confirm that everything was working. Basics: Run a Remote NRPE Check To test a remote NRPE client command from a […]

How To Check for Infected Files Using Nagios Plugins

Author: , January 25th, 2016

This example shows how to look for infection patterns inside all .php files in a directory tree using find and grep called from a Nagios NRPE plugin written in PERL. You can adjust the behavior by modifying the script, described at the bottom of this post in the Advanced section. On the host to be […]

How To Reset Nagios State

Author: , November 5th, 2015

Every once in a while there is a hiccup in my internet service and every host that Nagios monitors shows DOWN. In those situations, I do not need the hundreds of the emails and text messages generated by Nagios. Here is the procedure for resetting Nagios v3.5.0 running on MacOSX 10.6.8 via a MacPorts install: […]

How To Check Amazon RDS MySQL Servers in Nagios Without Ping

Author: , August 13th, 2015

Amazon Web Services (AWS) offers MySQL Server via the Relational Database Service (RDS) offering. Unfortunately, AWS doesn’t allow ICMP Ping to reach the nodes, so as configured by default, Nagios will fail on the host check. The solution is to submit a Passive Check for that host. Login to the Nagios web console Click on […]

How To Install Nagios/NRPE on AWS

Author: , August 1st, 2011

Protected: Denial of Service Attack Records

Author: , December 30th, 2010

There is no excerpt because this is a protected post.