On Tue, Jul 13, 2010 at 8:24 AM, alba.albetti <alba.albetti@stripped> wrote:
> Hi,
> I'd like to know which are the main tasks for a DBA, so in addition of the on-line
> tutorial of MySQL, is there anyone telling me whether there exists some tutorial (better
> if in PDF)
Sure, the MySQL Reference Manual http://dev.mysql.com/doc/
>where it's possible to undestand and learn all you need for managing the MySQL DB as
> DBA? I mean I'd like to read something explaining what are datafiles, tablespaces, ... and
> what usually a DBA is asked to do (creating databases, starting up and shutting down the
> database, managing the database's storage structures, making database backups and
> performing recovery, monitoring and tuning performance, ...) In other words I'd like to
> read how to manage a DB as DBA, because I've always worked only as developer and not as
> DBA.
Maybe the Certification: Sun Certified MySQL Database Administrator
(SCMDBA) could help you with that:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=333
by the way they recommend the book: MySQL 5 certification study guide
http://books.google.com/books?id=0tErAAAACAAJ
> Thanks!
