OurSQL Episode 98: MySQL Puppeteering

This week we present using Puppet to manage MySQL. Ear Candy is netcat and At the Movies is a video about the Master High Availability toolkit by Yoshinori Matsunobu.

Daniƫl van Eeden gave us lots of great feedback this week:
Episode 93, which included iotop and ionice in ear candy
CFQ scheduler for Linux
noop scheduler for Linux
deadline scheduler for Linux
anticipatory scheduler for Linux

Episode 92, where we talked about FLOAT. See MySQL bug #57519.

Shlomi Noach's common-schema provides a view to monitor the 'fullness' of an auto_increment column

OSCon will be held Monday Jul 16th through Friday Jul 20th and has a data track. We did a podcast about OSCon, including a discount code!

FrOSCon will be held Saturday and Sunday, August 25th - 26th at the University of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a small fee for personal attendees, only 5 euros. It is more for corporate attendees. There will be a MySQL and friends room this year, as in years past.

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps. The schedule is now online.

Percona Live: New York City 2012 will be held from Monday, Oct 1st through Tuesday Oct 2nd.

SkySQL Trainings

Percona Tranings

Oracle's MySQL Trainings

Puppet and MySQL
We talked about why you would want to do configuration management in episode 85
Puppet homepage
Apache licenses
MySQL 5.6 Replication and a server UUID

Puppet templates:
MySQL Server Patterns
MySQL Stored Configuration Patterns
MySQL SSL using Puppet Certificates

Leap second causes problems on some MySQL machines (Linux kernel bug)

Ear Candy
netcat and Xtrabackup (there's also a GNU netcat utility)

At the Movies
This week we share a talk given by Yoshinori Matsunobu of Facebook about his MHA (Master High Availability) toolkit for MySQL at the SkySQL Solutions Day.

Where you can see us
The July Boston MySQL User Group - Wed July 18th at the Mozilla Boston office space, where Sheeri will talk about MySQL Security.

Gerry will be at the August Seattle MySQL User Group on Monday Aug 06 at 7:00 PM.

Sheeri will be at the August Boston MySQL User Group on Monday, August 13th, at the Microsoft NERD Center, where Dave Stokes of the MySQL Community Team (at Oracle) will talk about MySQL 5.6. MySQL 5.6 has many improvements and new features that you may not know about that you will want to exploit. Find out how changes in replication, Global Transaction IDs, sub-partitions, optimizer tracing, and other changes will make you life as a DBA better.

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