1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ200

Architecture

Which two components of MySQL InnoDB Cluster help achieve database high availability?

Choose two
  • A MySQL Router to ensure that client requests are load balanced and routed to the correct servers
  • B MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI
  • C MySQL Enterprise Backup to keep data consistent and always ready to be used
  • D MySQL Semi-Sync replication plugin is used to provide cluster consistency
  • E MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication
Explanation

MySQL Router is InnoDB Cluster middleware that routes client traffic to appropriate backend servers and redirects connections after failover. MySQL Shell includes AdminAPI, which is used to configure and administer InnoDB Cluster deployments. InnoDB Cluster uses Group Replication rather than the semi-synchronous replication plugin for replicated high availability.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!