Blog

In this blog post, we will discuss how to use the Tungsten Connector keep-alive feature to ensure long-running MySQL & MariaDB/Percona Server client sessions stay connected in a Tungsten Cluster.

While the MySQL Auto-Reconnect feature is both handy and interesting, it has to be used with great care, along with an understanding of the behavioral implications and side effects. In this blog post we will discuss some of the risks of using the MySQL driver Auto-Reconnect feature, and what happens when the Tungsten Connector internal version of it is enabled.

It is always a good idea to be mindful of open ports on your hosts, since they can be used by bad actors to gain access to your systems. For this reason, it is often desirable to prevent outside connections to the port whenever possible to prevent intrusions. For security purposes (and possibly PCI compliance), the Tungsten Connector proxy has the ability to bind to localhost/127.0.0.1 instead of listening on all available IP addresses via 0.0.0.0.

One nice thing about Tungsten Clustering is that you need just a single command to move the primary role to another host in your cluster.

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?"

This blog discusses some of the ways you can configure your MySQL / MariaDB / Percona Server replicas using Tungsten Clustering.

First step of the Tungsten overall “containerization” goal is achieved! The Continuent team wants to share with customers the Tungsten Proxy (originally Tungsten Connector) as a standalone service within a minimal Docker Image.

The Tungsten Connector proxy within a Tungsten Cluster is a very powerful tool, able to route traffic many different ways. The Quality Of Service (QoS) determines where the Connector proxy will send client request packets, either to the Primary for writes or to a Replica for reads. This short blog post will show you how to use the command line to control the Quality Of Service when creating a new connection to the MySQL Server database.

Need to do maintenance on a host? Learn how to suspend it gracefully.

Want your application to read from replicas? Here is how to choose the best r/w splitting option available in Tungsten Clustering.

How to pass arguments from an application to a database proxy, per-connection, to a Tungsten Database Proxy using connection parameters.

Thinking transparent reconnects of applications is the grail of HA? It is! But Active/Active setups make them risky.