Author:
erics, 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.
Categories: Connector, Geo-Distributed, Maintenance, Multimaster, Multimaster MySQL, Multisite Tags: AWS, Clustering, Disaster REcovery, High Availability, mysql, proxy, Replicator
| 
Comments Off on 10 Reasons Why Tungsten Clustering Beats the DIY Approach for Geo-Distributed MySQL Deployments
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
Author:
erics, May 7th, 2019
The Question Recently, a customer asked us: If we move to using the INI configuration method instead of staging, would password-less SSH still be required? The Answer The answer is both “Yes” and “No” No, for installation and updates/upgrades specifically. Since INI-based configurations force the tpm command to act upon the local host only for […]
Categories: Architecture, Mastering Tungsten Clustering, Multimaster, Multisite Tags: HA, High Availability, monitoring, mysql, nagios, NRPE
| Comments Off on SSH Differences Between Staging and INI Configuration Methods
