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 17th, 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, Heavy I/O Load, I/O, Java GC, JVM, Manager, Mastering Tungsten Clustering Tags: Clustering, Java, mysql, Speed, Tungsten
| Comments Off on Why is My Java Application Freezing Under Heavy I/O Load?
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, June 12th, 2019
The Problem Tried to load a Tab-delimited text file into MuSQL 5.6.43 and got the following error: mysql> LOAD DATA INFILE ‘sample.txt’ INTO TABLE test_table; ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement Solution One mysql> SHOW VARIABLES LIKE “secure_file_priv”; Copy the file into the […]
Categories: How-To's, Technology Tags: Data, Error, File, howto, INFILE, Load, LOAD DATA, LOAD DATA INFILE, LOAD DATA LOCAL INFILE, local, mysql, Priv, Privilege, Secure, secure_file_priv, secure-file-priv, Show, SHOW VARIABLES, tips, VARIABLES
| No comments
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
Author:
erics, April 23rd, 2019
Overview The Skinny In this blog post we will discuss how to best integrate various Continuent-bundled cluster monitoring solutions with PagerDuty (pagerduty.com), a popular alerting service. Agenda What’s Here? Briefly explore the bundled cluster monitoring tools Describe the procedure for establishing alerting via PagerDuty Examine some of the multiple monitoring tools included with the Continuent […]
Categories: Architecture, Mastering Tungsten Clustering, Multimaster, Multisite Tags: HA, High Availability, monitoring, mysql, nagios, NRPE
| Comments Off on How to Integrate Tungsten Clustering Monitoring Tools with PagerDuty Alerts
