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 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, March 22nd, 2016
Quick-and-dirty way: tcpdump -i eth0 -s 0 -l -X dst port 3306 NOTE: That option above is a dash-ELL which provides for unbuffered output. Maciej Dobrzanski posted the following script on the Percona site at https://www.percona.com/blog/2008/11/07/poor-mans-query-logging/, which I am reposting without permission because it is so good:
|
|
tcpdump -i eth0 -s 0 -l -w - dst port 3306 | strings | perl -e ' while(<>) { chomp; next if /^[^ ]+[ ]*$/; if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER)/i) { if (defined $q) { print "$q\n"; } $q=$_; } else { $_ =~ s/^[ \t]+//; $q.=" $_"; } }' |
Categories: How-To's, Technology Tags: 3306, mysql, Network, Scan, Sniff, Sniffer, tcpdump, Watch
| No comments
Author:
erics, January 27th, 2015
yum install nc SERVER-SIDE: host1 shell> echo hello | nc -l 3456 CLIENT-SIDE: host2 shell> nc host1 3456 hello ~or~ CLIENT-SIDE: yum install telnet host1 shell> telnet host2 {PORT}
Categories: How-To's, Technology Tags: howto, nc, netcat, Network, Network Port, Port, Testing, tips, Yum
| No comments
