QuestionQ28

Architecture

Which two of the following are use cases for MySQL asynchronous replication?

Choose two
  • A You can scale writes by creating a replicated mesh.
  • B It guarantees near real-time replication between a master and a slave.
  • C You can scale reads by adding multiple slaves.
  • D MySQL Enterprise Backup will automatically back up from an available slave.
  • E It allows backup to be done on the slave without impacting the master.
Explanation

MySQL asynchronous replication supports read scale-out by directing read workloads to multiple replicas while writes remain on the source. It also permits backups to run on a replica, isolating backup activity from the source's normal operation.

Learn more

Community Discussion

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