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 […]
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: […]
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 […]
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 
