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