OurSQL Episode 111: Do You Make the Grade (part 1)?

This is part one of a series where we will explore the Operations Report Card and explain how it applies to DBAs. Listen and grade your own organization, this is a great opportunity to get some new ideas on how to organize your department and make your job more efficient and streamlined.

News
Alaska Airlines system crash

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

Call for papers for SCALE13, open until December 10th, 2012.

Percona Live, London Dec 3- Tues Dec 4. Millenium Gloucester Hotel.

Training
MySQL Marinate, a FREE basic MySQL training course offered by Sheeri.

SkySQL Trainings

Oracle's MySQL Trainings

Percona Tranings

Operations Report Card
Operations Report Card written by Tom Limoncelli

Tom also wrote Time Management for System Administrators and the standard for system administrators, The Practice of System and Network Administration.

Monthly metrics ideas:
# of DBAs
# of database servers
# of database users
# of databases
# of applications served (may be better than # of users or # of databases)
Amount of space used by databases
Amount of data transferred
Tx/queries per second, avg/peak
Restore time
Ticket metrics - how many open tickets, how many tickets per DBA, how many new tickets were created, what department opened the most tickets
Record how you met a few top SLA's (e.g. if the SLA for the most important DB is 99.99%, and you had 10 mins of downtime, note it)

Ear Candy
Episode 109 where we talked about startup scripts and how the 'mysql.server' supported 'reload' by sending a SIGHUP to the server. This week we explain what happens with the SIGHUP signal in general, and how it works for Apache and MySQL specifically.

At the Movies
This week in at the movies, we present The Art of Cat Herding: How to Manage Geeks. This is an hour-long presentation of a talk that Sheeri gave at Mozilla last week, talking about how to effectively manage folks when you might not really know how.

Where you can see us
Gerry will be speaking at Highload++ in Moscow Oct 22nd and 23rd giving my version of the “Indexing the right way” talk, a favorite topic at Tokutek.

The Seattle MySQL meetup will be held on Nov 5th at Pyramid Alehouse and will be a "get together and chat event", it's your opportunity to bring up what you'd like to talk about over the next 12 months and other issues around the organization of the Meetup.

Sheeri will be at CodeConnexx in Indianapolis November 8-9th speaking about "MySQL Query Optimization with EXPLAIN" and "The Art of Cat Herding: How to Manage Geeks".

Sheeri will also be at the November Boston MySQL User Group on Monday November 12th from 7-9 pm, which features a talk from ScaleArc about their transparent MySQL Server infrastructure software that achieves instant horizontal scaling, clustering and load balancing, connection multiplexing and connection pooling, transparent query-level caching, wire-speed filtering and higher availability…without requiring any changes or modifications to applications or MySQL databases at any point in time. In addition, ScaleArc provides real-time tools and Analytics to quickly troubleshoot problem queries, and then allows the user to take action to fix them.

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