github.com/ppickett-pivotal/mysql-timeline

mysql-timeline

Parse and format logs from a MySQL Galera cluster

originally written by Stephen Carter

Details

The tool parses known log lines (that I understand!) and generates a consolidated timeline of the events that happened on a cluster.

You still need to figure out what actually happened on the cluster but this is great to get a highlevel overview before digging deeper in to the logs.

Usage

1. mysql-timeline was created using go1.8.3 so make sure you have at least that version installed:
   • https://golang.org/dl/
2. Download the code:
   • go get github.com/ppickett-pivotal/mysql-timeline
3. Install the code:
   • go install github.com/ppickett-pivotal/mysql-timeline
4. Generate the timeline:
   • mysql-timeline NODE0_LOG NODE1_LOG NODE2_LOG > timeline.html
   • The tool expects 3 log files corresponding to MySQL node 0, 1 and 2.
5. Open timeline.html in your favourite browser.
   • The columns correspond to the nodes from left to right.