Enabling Autorecovery for the Tungsten Replicator

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

Where are the logs for a Tungsten Cluster?

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?

What is the Best Way to Check the Health of a Tungsten Cluster Before a Switch?

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?

How To See MySQL Traffic Using tcpdump

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.=" $_"; 
  } 
}'

1

2

3

4

5

6

7

8

9

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

How To Use netcat and telnet for Simple Network Testing

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

S	M	T	W	T	F	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

Enabling Autorecovery for the Tungsten Replicator

Where are the logs for a Tungsten Cluster?

What is the Best Way to Check the Health of a Tungsten Cluster Before a Switch?

How To See MySQL Traffic Using tcpdump

How To Use netcat and telnet for Simple Network Testing

Our Link Network

Business

Client Websites

Fine Dining

Friends & Family

Galleries

Health

Resources

Technology

Travel

The Archives

Latest Ramblings…

Various Topics of No Interest