OurSQL Episode 190: Server State Monitoring

This week we discuss pt-sift and pt-stalk. Ear Candy is about a new tool called Orchestrator, and At the Movies is about Trove on OpenStack to provide open source Database as a Service.

News
Gerry:
In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL events

OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.

FrOSCon 2014 will be held Saturday 23 August - Sunday 24 August at the University of Applied Sciences Bonn-Rhein-Sieg in Germany.

Training
SkySQL Trainings
Tungsten University trainings
Oracle's MySQL Trainings
Percona Trainings

pt-stalk
mysqladmin manual page
Episode 150, ear candy is about monitoring with mysqladmin and --relative
Episode 155, ear candy is about pt-stalk

pt-stalk documentation
Options covered:
--trigger-condition
--variable
--function
--match
--threshold
--cycles
--collect
--dest
--daemonize
--prefix
--stalk, --no-stalk
--run-time
--interval
--iterations
--sleep. --sleep-collect
--retention-time, --disk-bytes-free, --disk-pct-free
--collect-gdb, --collect-strace, --collect-oprofile, --collect-tcpdump
wireshark tool to analyze network traffic
--notify-by-email
--plugin

pt-sift
pt-sift manual page
Episode 171, where we talked about pt-mext

Ear Candy
In this week's Ear Candy we introduce Orchestrator from Shlomi Noach, which offers a way to detect and manage your replication clusters in very easy way.
Orchestrator on Github
Download as a tarball, RPM or DEB package.

At the movies
This week in At the Movies we present Amrith Kumar at the June Boston MySQL User Group explaining Trove on OpenStack. Trove is open-source software to run databases as a service, or DBaaS.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast