Author:
erics, September 26th, 2019
Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves
Categories: Architecture, cctrl, Composite, Mastering Tungsten Clustering, Question Tags: HA, mysql, Performance, Performance Tuning, QA, Shell, Tungsten
| 
Comments Off on Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves
Author:
erics, August 26th, 2019
Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Categories: Architecture, cctrl, Composite, Datasource, Downtime, Maintenance, Mastering Tungsten Clustering, Question, Shun, Zero-Downtime Tags: Command, HA, Master, mysql, QA, recover, Shell, Slave, Switch, Tungsten, welcome, Zero
| Comments Off on Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance
Author:
erics, 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).
Categories: Balance, Bottleneck, Connector, Heavy I/O Load, Load Balancing, Mastering Tungsten Clustering, Overloaded, Read-only, Read-write, Splitting Tags: Clustering, mysql, proxy, Slave, Tungsten
| Comments Off on How to use Round-Robin Load Balancing with the Tungsten Connector
Author:
erics, 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.
Categories: Auto Recover, Auto recovery, Mastering Tungsten Clustering, Mastering Tungsten Replicator, Offline, Tune Tags: Configuration, mysql, Network, Online, Recovery, Replicator, Tungsten, tuning
| Comments Off on Enabling Autorecovery for the Tungsten Replicator
Author:
erics, July 25th, 2019
How to move the Relay role to another node in a Composite Tungsten Cluster
Categories: Architecture, cctrl, cls, Composite, Datasource, failover, Maintenance, Mastering Tungsten Clustering, Question Tags: Automatic, Command, HA, High Availability, Master, Move, mysql, QA, Relay, Replicator, Shell, Slave, Switch, Tungsten
| Comments Off on How to move the Relay role to another node in a Composite Tungsten Cluster
Author:
erics, 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?”
Categories: Bridge, Cluster, Connector, Direct, Mastering Tungsten Clustering, SmartScale Tags: Clustering, mysql, proxy, Tungsten
| Comments Off on How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale?
Author:
erics, 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.
Categories: Mastering Tungsten Clustering, Monitor Tags: Aliases, bash, cli, Command, Command line, HA, High Availability, monitoring, mysql, Tungsten
| Comments Off on Slick Command-Line Tricks for a Tungsten MySQL / MariaDB Database Cluster
Author:
erics, July 9th, 2019
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?
Categories: Cluster, Manager, Mastering Tungsten Clustering, Monitor Tags: Clustering, Log, Logs, mysql, Network, Switch, Tungsten
| Comments Off on Where are the logs for a Tungsten Cluster?
Author:
erics, June 26th, 2019
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.
Categories: Cluster, JVM, Mastering Tungsten Clustering, Tune Tags: Clustering, Config, Configuration, Memory, mysql, Network, Switch, Tungsten, tuning
| Comments Off on What is the Best Way to Check the Health of a Tungsten Cluster Before a Switch?
Author:
erics, June 24th, 2019
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.
Categories: Failsafe, Mastering Tungsten Clustering, Multimaster, Split-Brain, Tungsten Connector Tags: HA, High Availability, mysql, Tungsten
| Comments Off on What on Earth is a Split-Brain Scenario in a MySQL Database Cluster?
