Diamond Notes

So since everyone else seems to be doing this it must be cool right?  I am proposing the following talk.  I pretty much copy/pasted what I have submitted. However, I can edit the proposal up until midnight tomorrow night if someone would like something added.

——

In this session I will provide all the basic information that a beginning MySQL DBA needs. We will cover (albeit briefly) all the major aspects of a DBA’s responsibilities and other areas of interest:

• an overview of the MySQL Server (cache/parser/optimizer/storage engines)
• the mysql client (command lines & GUIs)
• users and permissions
• log files (what’s in the slow query log file?)
• backups/restores (mysqldump, parallel dump and restore, lvm snapshots, etc)
• disaster recovery (what to do when I type ‘DROP DATABASE BOSS_DATA’)
• scaling your databases (replication, sharding and clustering)
• profiling (the five minute guide to EXPLAIN and other resources)
• tuning the my.cnf file for your hardware (hey boss…I need 8 GB of RAM!!!)
• benchmarking
• resources

As there is quite a bit to cover I will have to move fast. Even so, I will be including many real examples using actual screenshots and my own experiences. While I have never actually dropped a database that was still needed, I have had to restore backups and recover from disasters. The binary logs can be your best friend at times!!!

In short, I will include all the “stuff” I wished I knew back in 1998 when I set up MySQL for the first time.