… Nichter. This tool is also completely rewritten. Instead of a Bash script that you have to configure with environment variables and run… a “real” Percona Toolkit tool ought to have, such as command-line options and a configuration file. In addition, we merged…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…run_worker to contain the following: #!/bin/bash while [ 1 ] do ./worker >> /dev/null 2>&1 …data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact… provided a convenient script which will summarize the output from the ./run_query command, called pivot…
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
… the MySQL node. At its smallest expression, the instance monitoring script is a simple empty loop that will run forever like: #!/bin/bash… monitoring scripts can be written but let’s provide a basic functional one that monitor MySQL with the mysqladmin ping command. #!/bin/sh # MySQL…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… don’t noticeably affect the results. Here is the tcpdump command used. tcpdump -i eth0 -s 65535 -x -n -q -tttt… draft of a script to automate this; use at your own risk and update to suit your needs. #!/bin/bash # Set some…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… Then, a startup script becomes a nightmare. Finally, if the box on which the script is supposed …usr/local/bin/fake_ndb_mgmd #!/bin/bash /usr/bin/nohup /usr/local/mysql/libexec/ndb_mgmd > /dev/null & …xml format, editing and reloading. In term of commands, it means: cibadmin –query > local.xml vi …
