I recently helped a client implement a custom replication delay monitor and wanted to share the experience and discuss some of the iterations and decisions that were made. percona-millipede was developed in conjunction with Vimeo with the following high-level goal in mind: implement a millisecond level replication delay monitor and graph the results. Please visit http://making.vimeo.com for more information and thanks to Vimeo for sharing this tool!
Here is the rough list of iterations we worked through in developing this tool/process:
- Standard pt-heartbeat update/monitor
- Asynchronous, threaded update/monitor tool
- Synchronized (via zeroMQ), threaded version of the tool
pt-heartbeat
Initially, we had been running …
[Read more]