MySQL HeatWave Service

• Identify key features and benefits
• Describe MySQL HeatWave architecture
• Define MySQL HeatWave terminology
• Identify MySQL HeatWave limitations

Provisioning and Connecting DB systems

• Identify VCN requirements for provisioning DB systems
• Connect to DB system with OCI Bastion
• Connect to DB system with MySQL Shell
• Connect to DB system with OCI Cloud Shell
• Connect to DB system with OCI SQL Worksheet
• Authenticate DB system with OCI Identify Access Management credentials

Managing DB systems

• Demonstrate a command of DRG and DRG Attachments
• Apply BGP in the OCI environment
• Evaluate OCI VPN Services
• Validate the various FastConnect products from OCI
• Sustain Multicloud Connectivity configurations

Backing up and restoring DB systems

• Back up and restore a DB system
• Manage automatic backups
• Perform point-in-time recovery

MySQL HeatWave Configurations

• Create custom configurations
• Compare configurations
• Describe the effects of changing dynamic and non-dynamic variables
• Update a DB system configuration

Read Replicas  

• Create and manage read replicas
• Describe the read replica load balancer
• Connect to a read replica

Inbound Replication

• Set up and troubleshoot inbound replication
• Create and manage channels

Data Migrations

• Create a DB system with data import
• Import data into a DB system
• Export data from MySQL servers and DB systems
• Migrate data with replication

High Availability

• Enable and disable the high availability of a DB system
• Explain placement considerations for a high availability DB system
• Distinguish between switchover and failover