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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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):
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} NOTE: Be sure to fully stop and restart nrpe!
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 […]
erics, May 24th, 2019 
Categories: Architecture, Mastering Tungsten Replicator, Multimaster, Multisite HA, High Availability, monitoring, mysql, nagios, NRPE
| 
Comments Off on The Important Role of a Tungsten Rollback Error 
