Thursday, February 28, 2008

Learning MySQL DBA Best Practices

It is a challenge for new MySQL DBAs to learn best practices for managing database servers. There are no books that teach you everything you need to know. Key knowledge areas new MySQL DBAs need to learn:
  • Best practices for installation and configuration.
  • How to monitor and manage a database.
  • How to monitor for tuning.
  • Best practices for backup/recovery.
  • Best security practices.
  • What audit controls need to be put in place.
  • Disaster planning.
  • Growth projections and scalability planning.
  • Change management.
Sources I would recommend a new DBA start with:
  • Google - do searches on best DBA practices, etc.
  • Read information on the MySQL Optimal Configuration Architecture (MOCA) and the Optimal Flexible Architecture (OFA - Oracle related). Both give examples of things to consider when planning databases.
  • Go to conferences and download presentations from previous conferences.
  • Find a mentor.
  • Larger environments look at Sarbanes-Oxley, COBIT and ITIL in terms of best practices for managing IT infrastructures. Waters get deep here for new DBAs.
  • http://www.planetmysql.org

No comments: