This week, we finish our series on the Operations Report Card as it applies to database administrators. In Ear Candy, we discuss one problem with setting table_open_cache higher than needed., and At the Movies is Tools and Techniques of Index Design by Bill Karwin.
common_schema 1.2 has also come out - common_schema is a framework for MySQL server administration and diagnostics. It introduces SQL based tools which simplify otherwise complex shell and client scripts, allowing the DBA to be independent of operating system, installed packages and dependencies. It is a self contained schema, compatible with all MySQL >= 5.1 servers. Installed by importing the schema into the server, there is no need to configure nor compile. No special plugins are required, and no changes to your configuration.
Oracle's "Scale with MySQL" seminars:
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 led by Sheeri.
Operations Report Card
This week we finish our series on the Operations Report Card.
Our Backup series:
Episode 30 - backup concepts
Episode 32 - backup tools that ship with MySQL
Episode 33 - LVM snapshots
Episode 35 - advanced logical exports
Episode 38 - Xtrabackup
Episode 41 - Zmanda
In Ear Candy, we discuss one problem with setting table_open_cache higher than needed.
At the Movies
Tools and Techniques of Index Design by Bill Karwin. This is a Percona webinar, so you have to register for free and you'll be sent a link to the recording.
Where you can see us
Gerry will be at the December Seattle MySQL Meetup on Dec 3rd, topic and venue to be determined.
Sheeri will be at the December Boston MySQL meetup group on Monday, December 10th from 7-9 pm. The topic is "Elastic Database Scalability: Making your MySQL data tier flexible and adaptable to system demand with ParElastic" by Amrith Kumar, CTO of ParElastic.
MySQL Marinate starts January 1st, 2013. It is a virtual self-study course learning MySQL which both Gerry and Sheeri will be helping lead.
Sheeri will be speaking at the miniconfs at Linux Conf Australia, Monday January 28th through Saturday February 2nd, 2013 about "Getting Started With a Podcast" and "The Art of Cat Herding: How to Manage Geeks."
Sheeri will be speaking at Confoo in Montreal, Canada on Monday February 25 - Friday March 1, 2013, giving talks in English about "Are You Getting the Most Out of Your Indexes?" and "Different (MySQL) Forks for Different Folks".