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:
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.
Free eBookSubscribe 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.Read more Testimonials
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."
Theory & Practice
SQL Server DBA
Install SQL Server
Database Normalization eBook:
Copyright © www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein.
Return to top
The name Oracle is a trademark of Oracle Corporation.