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.
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.
MySQL Marinate, a FREE basic MySQL training course offered by Sheeri.
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
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)
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.
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.