Popis

Audience
• Database Administrators
• Developer

Goals
• Describe the MySQL Architecture
• Install and Upgrade MySQL
• Use the INFORMATION_SCHEMA database to access metadata
• Perform the MySQL start and shutdown operations
• Configure MySQL server options at runtime
• Use available tools including MySQL Workbench
• Evaluate data types and character sets for performance issues
• Understand data locking in MySQL
• Understand the use of the InnoDB storage engine with MySQL
• Maintain integrity of a MySQL installation
• Use triggers for administration tasks
• Use Enterprise Audit and Pluggable Authentication
• Configure advanced replication topologies for high availability
• Describe introductory performance tuning techniques
• Perform backup and restore operations
• Automate administrative tasks with scheduled events

Prerequisites
Required Prerequisites:
• Have some experience with relational databases and SQL