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 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 Print Matching Line and All After Using awk

Author: , August 1st, 2019

Every time I use awk, my respect for it grows! Like grep, find and rsync, it is one of the powerhouse command-line tools in my arsenal. Recently, I needed to list all MySQL binary log files from a starting file forwards in sequence. AWK to the rescue! For example, I knew the starting file was […]

Tungsten Clustering 5.4.0 and Tungsten Replicator 5.4.0 Released

Author: , July 31st, 2019

Continuent is pleased to announce Tungsten Clustering 5.4.0 and Tungsten Replicator 5.4.0 for MySQL / MariaDB. It’s significant in that it introduces MySQL 8 support, along with many new features, stability improvements and bug fixes.

Tungsten Clustering 6.1.0 and Tungsten Replicator 6.1.0 Released

Author: , July 31st, 2019

Continuent is pleased to announce Tungsten Clustering 6.1.0 and Tungsten Replicator 6.1.0 for MySQL / MariaDB. It’s significant in that it has MySQL 8 support, along with many new features, stability improvements and bug fixes. This release also features a new manager, and it also has the ability to do active/active Composite Multimaster geo-clustering.

How to move the Relay role to another node in a Composite Tungsten Cluster

Author: , July 25th, 2019

How to move the Relay role to another node in a Composite Tungsten Cluster

How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?

Author: , July 19th, 2019

Part of the power of Tungsten Clustering for MySQL / MariaDB is its intelligent MySQL Proxy, known as the Tungsten Connector. Tungsten Connector has three main modes, and depending on the type of operations you are performing (such as if you need read-write splitting), we help you choose which mode is best. Hence the question, “How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?”

Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster

Author: , July 16th, 2019

Tungsten Clustering provides high availability, disaster recovery, and a host of other benefits for MySQL / MariaDB / Percona Server databases. In this blog post we will explore some of the shell aliases I use every day to administer various Tungsten Clusters.