How to use Round-Robin Load Balancing with the Tungsten Connector
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
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.
In a proxy-ed world, where do connections come from?
Database Proxies provide a single entry point into MySQL for the calling client applications. Proxies are wonderful tools to handle various situations like a master role switch to another node for maintenance, or for transparency with read and write connections. However, when the time comes to perform the switch action, all of the calling clients have been funneled through the proxy, so identification of the calling host from the database itself becomes difficult.
How to move the Relay role to another node in a Composite Tungsten Cluster
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?
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
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.
Where are the logs for a Tungsten Cluster?
Where are the logs for a Tungsten Cluster and which are the proper log files to monitor if I do a master role switch to another node?
The Fast Way to Import CSV Data Into a Tungsten Cluster
In this blog post we discuss importing CSV data into a Tungsten Cluster.
What is the Best Way to Check the Health of a Tungsten Cluster Before a Switch?
Latency-sensitive applications running in Java sometimes experience unacceptable delays under heavy I/O load. This blog discusses why this problem occurs and what to do about it for applications running Tungsten Clustering for MySQL.
What on Earth is a Split-Brain Scenario in a MySQL Database Cluster?
In this blog post we will define what a split-brain scenario means in a MySQL database cluster, and then explore how a Tungsten MySQL database cluster reacts to a split-brain situation.
Configuring the Tungsten Connector for PCI Compliance
This blog is about configuring Tungsten for PCI compliance.
Why is My Java Application Freezing Under Heavy I/O Load?
Latency-sensitive applications running in Java sometimes experience unacceptable delays under heavy I/O load. This blog discusses why this problem occurs and what to do about it for applications running Tungsten Clustering for MySQL.