MySQL Database Administration

MySQL for DBA's

At the completion of this course, you should be able to

• Describe the MySQL Architecture, general operational characteristics and resources utilized for running it.
• Perform the most common Database Administration (DBA) tasks utilizing the various programs contained within the MySQL application
• Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
• Use the INFORMATION_SCHEMA database to access metadata
• Install and Upgrade MySQL 5.0 for the most common operating systems
• Perform the MySQL start and shutdown operations
• Configure MySQL server options at runtime
• Activate and manage numerous server logs
• Evaluate data types and character sets for performance issues
• Understand data locking concepts and the different levels of locking in MySQL
• Differentiate between the multiple storage engines available in MySQL
• Create, Maintain and Manage MySQL tables
• Perform backup and restore operations utilizing multiple MySQL tools
• Manage user maintenance and access to a MySQL Server
• Maintain integrity of a MySQL installation utilizing security protocols
• Use stored routines and triggers for administration tasks
• Manage, apply and understand the reason for using views
• Improve performance through query optimization
• Optimize Schemas (Databases) utilizing multiple techniques
• Utilize MySQL monitoring tools to improve server performance
• Compare multiple environment options to improve server performance
• Scale MySQL operations up

Top