OurSQL Episode 85: Keep it Under Control

This week we talk about package and configuration management with MySQL.

News/Events:
Don't forget to send us questions to answer for future versions of Ear Candy, see the "Feedback" section below.

There are 2 free webcasts on Efficiently deploying new MySQL applications on Windows coming up: in French on Thursday April 5th and in German, on Thursday, April 19th.

There is also a free webcast on Building High Performance and High Traffic PHP Applications with MySQL - The Fundamentals on Thursday, April 26, 2012 geared towards the Asia-Pacific time zones.

The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. The conference is at the Santa Clara, California Convention Center. Use code PL-pod and save 10% off registration!. Check out the tutorial and session schedule.

The day after Percona Live ends, on Friday April 13th, 2012 there will be three free events that you can mix and match. You do not have to be a conference attendee to join:
The SkySQL and MariaDB Solutions Day, A free one-day seminar on mysql topics.
Drizzle Day - a one-day workshop on all things drizzle. The event is free, but donations are welcome.
Sphinx will have their Sphinx Search Day.

Collaborate, the technology and applications forum for the Oracle Community, has 18 MySQL sessions. Collaborate runs from Sunday, April 22nd through Thursday, April 26th, 2012 at the Mandalay Bay Hotel and Casino in Las Vegas Nevada.

On Wednesday, April 25th in London, Oracle is offering a free seminar, including breakfast, on scaling MySQL.

Oracle is also having a free seminar on High Availability with MySQL in Belmont, CA on Thu Apr 26th.

LinuxFest Northwest will be happening on Saturday April 28th and Sunday April 29th.

There is a free afternoon Oracle seminar on MySQL Enterprise at Oracle in Düsseldorf, Germany on Tuesday, May 8th.

There is also a free afternoon Oracle seminar on
Scaling MySQL, to be held Tuesday, May 22nd from 12:45 to 5 pm at the Best Western Premier Hotel am Borsigturm in Berlin Germany
.

SkySQL is offering a training on performance tuning mysql in Paris on:
May 15, 2012 – May 18, 2012
and
Jun 18, 2012 – Jun 21, 2012

And note the Performance Tuning class is not the only available class at the moment. full SkySQL Training Schedule.

Oracle will be bringing their free 4-hour seminar on High availability solutions based on MySQL to

München, Germany on Wednesday, May 23rd
and Baden-Dättwil, Switzerland (near Zurich) on Thursday, May 24th

On Tuesday June 5th, 2012, a MySQL Innovation Day is being hosted at Oracle’s Conference Center in Redwood Shores, California. The MySQL Innovation day will feature multiple “lightning” talks by Oracle’s MySQL Engineers. If you cannot make it out to California, the lightning talks will be available via a live webcast, too - so either way, save the date!

OpenSQLCamp US will be co-located with the Southeast LinuxFext.
, or SELF. SELF is Friday, June 8th through Sunday, June 10th in Charlotte, North Carolina. Registration is free for both OpenSQLCamp and the Southeast LinuxFest. There is a MySQL day on Friday, June 8th, a database track on Saturday for chosen presentations, and an unconference style day for OpenSQLCamp talks on Sunday.

The 1st Latin American Conference about Mysql,, NoSQL and Cloud technologies will be held in Buenos Aires Wednesday, June 27th through Friday, June 29th at the Puerto Madero Hilton Hotel. It is called the MariaDB NoSQL & Cloud Latin American Conference and we will link to information in the show notes.

Configuration Control and MySQL
Wikipedia's definition of "configuration control"

Episode 36 and episode 37 where we talk about what we'd put as our defaults in a my.cnf file

Practice of System and Network Administration, which also talks about configuration control.

!include directive in the configuration file

pt-config-diff

Don't do schema changes and don't let your configuration management system restart mysql

Ear Candy
In this week's ear candy we explain why the binary logs might be greater than max_binlog_size.

At the Movies
Configuration management for Development Environments, using Puppet. This talk was given by Gareth Rushgrove at PuppetConf 2011

Where you can see us
Sheeri will be delivering a tutorial on White-hat Google Hacking and MySQL Security at Percona Live: MySQL Conference and Expo from April 10-12th, 2012 in Santa Clara, CA. Gerry and Sheeri will be signing CD's on the Wed night community event on Wed, April 11th

Sheeri will also be speaking at the SkySQL and MariaDB Solutions Day on Friday, April 13th, 2012 in Santa Clara, CA, giving a session on creating a data warehouse.

Gerry will be at the Seattle MySQL User Group on Monday MAY 7TH from 7 - 9 pm. No topic has been set yet.

Sheeri will be speaking about MySQL Security at the Professional IT Community Conference, Friday May 11 - Saturday May 12 in New Brunswick, NJ

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