OurSQL Episode 80: Lesser Known Percona Tools

This week, we talk about lesser-known Percona tools for MySQL.

News/Feedback:
This week we have some fun audio feedback from Patrick Hurley, a MySQL DBA in the UK.

The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. The conference is at the Santa Clara, CA Convention Center. Early bird pricing ends March 12th, 2012. Use code PL-pod and save 10% off the early bird prices!. Check out the tutorial and session schedule.

The day after Percona Live ends, on Friday April 13th, 2012 there will be a free one-day seminar on mysql topics, called the SkySQL and MariaDB Solutions Day. You do not have to be a conference attendee to join, so if you are in the Silicon Valley area on Friday April 13th and want to join a free day-long mini-conference on MySQL topics, we’ll link in the show notes on how to register.

Also on Friday, April 13th in Santa Clara, CA is Drizzle Day - a one-day workshop on all things drizzle. The event is free, but donations are welcome.

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.

LinuxFest Northwest will be happening Sat April 28th and Sun April 29th. The MySQL eco-system is usually well represented. The call for presentations is still open. If you live in the Pacific NW, you should consider submitting one or more. It's a lively event less than 2hs N of Seattle and 1hs S of Vancouver.

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.

Main content:
Percona Toolkit
pt-heartbeat

pt-slave-delay
pt-slave-restart

pt-deadlock-logger

pt-duplicate-key-checker and its bug list
pt-index-usage and filing a bug
pt-show-grants

pt-kill

Ear Candy
This week’s ear candy is about commonalities to the Percona toolkit, including DSN aka data source name.

Example bug regarding --ask-pass - note that this bug has been fixed in Percona Toolkit 2.0.3.

At the Movies
This week in at the movies present Tim Callaghan of Tokutek speaking at last month’s Boston MySQL User Group, about Fractal Tree indexes.

Where you can see us
Gerry will be at the March Seattle MySQL User Group on Monday March 5th from 7 - 9 pm. No subject has been set yet.

Sheeri will be at the March Boston MySQL User Group on Monday March 12th from 7 - 9 pm. The meetup topic is about VoltDB, a column-based data store.

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.

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.

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