The Database Design Resource Center

Database Design | MySQL Backup | DB Management | MySQL Replication
MySQL Storage Engines | MySQL Stored Procedures | Transactions | MySQL Triggers | MySQL Tuning

MySQL DBA : Common tasks

Welcome to the MySQL DBA section of this site

In this MySQL DBA section, you will find a set of common tasks needed to be mastered and performed by any DBA. The articles are basic/intermediate level, and some are graphic intensive, so you will need some network speed to read them.

I recommend that you print each article for better reading experience. Use landscape orientation on your printer.

Starting with the release of MySQL version 5.0 and upwards, the Open Source MySQL database system have all of a sudden become an interesting alternative for serious business applications.

What is of particular interest for a MySQL DBA, is the accept that a modern database needs to have built-in support for stored procedures, triggers, ACID transactions and not least, being able to support referential integrity through primary and foreign keys constraints.

For a long time, I have wanted to present to you a set of articles for MySQL DBA's, which include:

  • Backup and restore
  • General DB design
  • DB Administration
  • MySQL tuning

and much more. So, here it is:

DISCLAIMER: All programming examples within the articles are meant for illustration purposes only, and The Database Design Resource Center holds no warrant for correctness if used.

Return to Database Design home

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © /
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.