R.I.P. James Caan

Author: , Posted on Thursday, July 7th, 2022 at 9:56:11am

James Caan 1940 - 2022

James Caan 1940 – 2022

Advanced Tungsten Troubleshooting Using Log Files

Author: , Posted on Thursday, June 30th, 2022 at 3:13:30am

Tungsten Clustering is a powerful tool with many moving parts, including the Tungsten Connectors which may be installed on any application server. During a troubleshooting event, it is helpful to understand what to look for and where, in addition to understanding how the logs work together to provide a clear picture of the situation. In Tungsten version 7, we introduced a number of features designed to make troubleshooting easier, and this blog will cover some of that too.

Zero Downtime: Upgrading MySQL Server in a Tungsten Cluster

Author: , Posted on Tuesday, June 28th, 2022 at 6:17:09am

Tungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster nodes with zero downtime.

Configuring HAProxy for Tungsten Dashboard

Author: , Posted on Wednesday, June 22nd, 2022 at 11:25:41am

This blog post will walk you through configuring HA Proxy for the Tungsten Dashboard, along with the new command tpm generate-haproxy-for-api which helps automate the process by translating existing INI files into haproxy.cfg config file format. The Tungsten Dashboard is a browser-based GUI, designed to make using a Tungsten Cluster as easy as possible.

Recover Disk Space: Easy THL Clean-Up In Tungsten v7

Author: , Posted on Friday, June 17th, 2022 at 9:18:43am

Transaction History Log (THL) files are the core of Tungsten Replication, containing the actual MySQL write events that are replicated to the replicas. These files can take up considerable amounts of disk space, making them of interest for housekeeping operations to limit the consumption and ultimately, the cost. This blog post will walk you through THL management, along with the new command tpm purge-thl which helps automate the process when THL needs to be removed prior to the automatic rotation window.

Lock It Down and Tighten It Up: THL Encryption and Compression Comes With Tungsten Replicator v7

Author: , Posted on Friday, June 10th, 2022 at 2:53:11am

Performance tuning any system provides more speed for the same hardware spend, gives the end-user a better, faster experience and typically reduces the stress on staff all around. Security tuning locks down critical data to prevent unauthorized access. Today we will explore both the security and performance enhancements available for the Tungsten Replicator THL sub-system as of version 7.x.

Inspect In-Flight MySQL Queries: Tungsten Connector Audit Logging to the Rescue

Author: , Posted on Monday, June 6th, 2022 at 2:59:13am

Sometimes you really, really want to know what a MySQL client is asking of the MySQL server. As of Tungsten Clustering v7.0.0, you may now enable Connector Audit Logging, which captures data transferred between client applications and MySQL servers to a file, database or socket. This blog post will walk you through the feature and how to enable, configure and disable Tungsten Connector Audit Logging.

Securing Your Cluster: View Your Security Stance Using tpm report

Author: , Posted on Tuesday, May 24th, 2022 at 2:59:00am

In this post we will explore a new command in v7.0.1, tpm report. The purpose of tpm report is to provide easy access to all of the settings that pertain to a specific topic. Since Security is a high priority at Continuent, the current default (and only) topic is the Security stance. The tpm report command will evolve and grow over time. This first version is Continuent’s way of providing as much transparency about Tungsten Cluster Security as possible.

How To Preserve Quotes In Bash Arguments

Author: , Posted on Monday, April 18th, 2022 at 2:21:50pm

If you want to preserve quoting to pass shell arguments to a called command, use the four characters "$@" (including the double quotes) instead of the two characters $*

How To Disable Email Bounce Messages In Postfix

Author: , Posted on Friday, March 18th, 2022 at 9:34:32am