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, 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 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, 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?
Author:
erics, June 18th, 2019
This blog is about configuring Tungsten for PCI compliance.
Categories: Architecture, Compliance, Connector, IP Address, Mastering Tungsten Clustering, PCI, Tungsten Connector Tags: HA, High Availability, mysql, Tungsten
| Comments Off on Configuring the Tungsten Connector for PCI Compliance
Author:
erics, June 14th, 2019
Overview The Skinny 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. Agenda What’s Here? Briefly explore how the Tungsten Connector works Describe the Connector keep-alives – what are they and why do we […]
Categories: Architecture, Bridge, Bridge mode, Connection, Connector, Intelligent, Keep-Alive, Load Balancing, Long, Long-Running, Mastering Tungsten Clustering, Multisite, SmartScale, Tungsten Connector Tags: HA, High Availability, Jobs, Keepalive, mysql, proxy, Session, TCP, Tungsten
| Comments Off on Using Keep-Alives To Ensure Long-Running MySQL & MariaDB Sessions Stay Connected
Author:
erics, May 24th, 2019
The Question Recently, a customer asked us: What is the meaning of this error message found in trepsvc.log? 2019/05/14 01:48:04.973 | mysql02.prod.example.com | [east – binlog-to-q-0] INFO pipeline.SingleThreadStageTask Performing rollback of possible partial transaction: seqno=(unavailable) Simple Overview The Skinny This message is an indication that we are dropping any uncommitted or incomplete data read from […]
Categories: Architecture, Mastering Tungsten Replicator, Multimaster, Multisite Tags: HA, High Availability, monitoring, mysql, nagios, NRPE
| Comments Off on The Important Role of a Tungsten Rollback Error
Author:
erics, May 22nd, 2019
Overview The Skinny In this blog post we will discuss how the managed cross-site replication streams work in a Composite Multi-Master Tungsten Cluster for MySQL, MariaDB and Percona Server. Agenda What’s Here? Briefly explore how managed cross-site replication works in a Tungsten Composite Multi-Master Cluster Describe the reasons why the default design was chosen Explain […]
Categories: Architecture, CMM, Mastering Tungsten Clustering, MSMM, Multi Master, Multimaster, Multisite, Site, v6 Tags: cross, cross-site, HA, High Availability, monitoring, mysql, Replication
| Comments Off on Understanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server
Author:
erics, May 21st, 2019
The Question Recently, a customer asked us: Why would Tungsten Replicator be slow to apply to MySQL? The Answer Performance Tuning 101 When you run trepctl status and see: appliedLatency : 7332.394 like this on a slave, it is almost always due to the inability for the target database to keep up with the applier. […]
Categories: Architecture, Mastering Tungsten Replicator, Multimaster, Multisite Tags: HA, High Availability, monitoring, mysql, nagios, NRPE
| Comments Off on Performance Tuning Tungsten Replication to MySQL
