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.

• A basic understanding of MySQL Database Design should be present.
• One of the most important tasks is to establish and perform an MySQL backup and recovery. Without it, you are leading a dangerous life...
• In this article, we look at some general MySQL database Management tasks.
• If you need to, you can set up a MySQL Replication script.
• There are different ways your system will behave, depending on what MySQL Storage Engine you choose for each table.
• Placing business logic inside the database is a clever way to maintain identical behaviour indepentent of applications. MySQL Stored Procedures is the way to go.
• Ensuring that your database is consistent at all times, ACID MySQL transactions are a must.
• Transparent change management can be implemented by using MySQL triggers.
• The last article in the MySQL DBA section is about performance issues: MySQL Tuning.

Return to Database Design home