OBIETTIVI

The MySQL for Database Administrators enables DBAs and other database professionals to maximize their organization’s investment in MySQL:

• Learn to configure the MySQL Server
• Set up replication and security.
• Perform database backups and recoveries.
• Optimize query performance.
• Configure for high availability.

CONTENUTI:

• Install the MySQL server and client programs
• Upgrade MySQL on a running server
• Describe MySQL architecture
• Explain how MySQL processes, stores, and transmits data
• Configure MySQL server and client programs
• Use server logs and other tools to monitor database activity
• Create and manage users and roles
• Protect your data from common security risks
• Troubleshoot server slowdowns and other common problems
• Identify and optimize poorly performing queries
• Define and implement a backup strategy
• Perform physical and logical backups of your data
• Describe MySQL replication and its role in high availability and scalability
• Configure simple and complex replication topologies
• Administer a replication topology
• Configure and administer InnoDB Cluster