|
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 Clustering, Log, Logs, mysql, Network, Switch, Tungsten
| 
Comments Off on Where are the logs for a Tungsten Cluster?
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 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?
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 HA, High Availability, mysql, Tungsten
| Comments Off on What on Earth is a Split-Brain Scenario in a MySQL Database Cluster?
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 HA, High Availability, mysql, Tungsten
| Comments Off on Configuring the Tungsten Connector for PCI Compliance
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 Clustering, Java, mysql, Speed, Tungsten
| Comments Off on Why is My Java Application Freezing Under Heavy I/O Load?
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 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
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 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
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 HA, High Availability, monitoring, mysql, nagios, NRPE
| Comments Off on The Important Role of a Tungsten Rollback Error
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 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
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 HA, High Availability, monitoring, mysql, nagios, NRPE
| Comments Off on Performance Tuning Tungsten Replication to MySQL
