How To Read Multiple Lines of User Input from the Command Line in Perl

Author: , October 9th, 2019

Use Case: Export Apple Reminders from MacOS application to cleaned plain text, i.e. remove unwanted spaces, blank lines and square brackets PROCEDURE Click on a single item in the MacOS Reminders app list Select All (either Command-a or use Edit->Select All) Copy (either Command-c or use Edit->Copy) Open Terminal Run cleanme Paste the copied reminders […]

How To Sync Box to S3 Using rclone

Author: , October 3rd, 2019

To sync various cloud resources, use the excellent cli tool rclone from https://rclone.org/docs/ For this use case, the need was to sync from Box to an AWS S3 bucket. Install rclone:

Configure both S3 and Box – for remote name labels I just used “S3” and “Box”:

Validate Access and Functionality:

Perform […]

Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves

Author: , September 26th, 2019

Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves

How To Dual-Sort Query Results In WordPress Using get_posts

Author: , September 12th, 2019

Needed to build a feature for a Bookstore tool to have an optional sequence number for the Custom Post Type “books” that would allow items with a seq number to float to the top of the list and be sorted by seq #. The rest of the books would show underneath, sorted alphabetically.

10 Reasons Why Tungsten Clustering Beats the DIY Approach for Geo-Distributed MySQL Deployments

Author: , August 29th, 2019

Why does the DIY approach fail to deliver vs. the Tungsten Clustering solution for geo-distributed MySQL multimaster deployments? Before we dive into the 10 reasons, note why commercially-supported enterprise software is less risky and in fact less costly.

Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance

Author: , August 26th, 2019

Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance

How To Upgrade PHP on AWS Linux

Author: , August 22nd, 2019

As root:

~or~

THEN:

Be sure to restart your web server!!

How to use Round-Robin Load Balancing with the Tungsten Connector

Author: , August 8th, 2019

The power of Tungsten Clustering for MySQL / MariaDB is its built-in intelligent MySQL proxy, known as the Tungsten Connector. The Connector has built-in read-write splitting capabilities, and it is also possible to configure different algorithms which select the appropriate slave (i.e. Round-Robin or Lowest-Latency).

Enabling Autorecovery for the Tungsten Replicator

Author: , August 7th, 2019

The replicator is a critical piece of the Tungsten Clustering solution for MySQL / MariaDB, as well as its own stand-alone data replication product. Automatic recovery enables the replicator to go back online in the event of a transient failure. In this blog, we discuss how to enable Autorecovery.

How To Prevent Vim From Auto-Commenting New Lines

Author: , August 4th, 2019

To prevent vim from added net comments, edit the .vimrc file in your home directory, and add: