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 | mysql02.prod.example.com | [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 (pagerduty.com), 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 Install Nagios/NRPE on AWS

Author: , August 1st, 2011

How To Check Memory Utilization With Nagios And NRPE

Author: , December 30th, 2010

Proper Credit for this script is due to “jlightner”, user “MensaWater” on linuxquestions.org – reposted without permission (no contact info available). Original link: http://www.linuxquestions.org/questions/linux-software-2/nagios-check-ram-usage-on-remote-server-747531/ Create the script /usr/local/nagios/libexec/check_mem.sh as shown below (make sure you set execute perms):

How To Fix NRPE “Could not complete SSL handshake” Error

Author: , December 13th, 2010

If you get this obnoxious error fron Nagios/NRPE: “CHECK_NRPE: Error – Could not complete SSL handshake” Make sure to comment out the following line in /etc/nagios/nrpe.cfg: #allowed_hosts=127.0.0.1 Use this to test on MacOSX: /opt/local/libexec/nagios/check_nrpe -H {IP}

How to Control NRPE on MacOSX

Author: , April 4th, 2010

I installed NRPE via the MacPorts command-line tool as root. As a result, I am able to start and stop NRPE with the following commands: * To Start NRPE: /opt/local/share/nrpe/init-script start * To Stop NRPE: /opt/local/share/nrpe/init-script stop [code lang=”shell”] #!/bin/sh # # Created 2000-01-03 by jaclu@grm.se # # nrpe This shell script takes care of […]