Which two are use cases of MySQL asynchronous replication? (Choose two.)
Which two are use cases of MySQL asynchronous replication? (Choose two.)
You can scale reads by adding multiple slaves, as replicas can handle read queries, distributing the load and improving performance. It allows backup to be done on the slave without impacting the master, ensuring that the main database continues its operations without interruption during backup processes.
Option C: Asynchronous replication allows you to add multiple slaves to distribute read queries, thus scaling reads horizontally. Option E: With asynchronous replication, you can perform backups on the slave without impacting the master, ensuring that backup processes do not affect the performance of the primary database operations.
C and E