MySQL DBA Responsibilities

Overview of DBA duties Server startup/shutdown Mastering the mysqladmin administrative client Using the mysql interactive client User account maintenance Log file maintenance Database backup/copying Hardware tuning Multiple server setups Software updates and upgrades File system security Server security Repair and maintenance Crash recovery Preventive maintenance Understanding the mysqld server daemon Performance analysis Obtaining and Installing…