Which two architecture options can provide Active/Active Master configuration for the MySQL Database?
A. Execute the following on the 2x MySQL Server Instances mysql> ALTER REPLICATION set mode= active;
B. Deploy MySQL Cluster on the following machines:
Machine 1: MySQL Node+ MySQL Management Node
Machine 2: MySQL Node+ MySQL Management Node
Machine 3: Data Node
Machine 4: Data Node
Application can access MySQL Node on Machine 1 or Machine 2 for Active/Active Configuration.
C. Configure MySQL Replication for two MySQL Database instances with circular Replication Topology, where two different applications with each using different database schemas connecting to a specified MySQL Database Instance.
MySQL Database Instance1 < —–Replication—> MySQL Database Instance 2
Application A connecting to MySQL Database Instance 1 for schema db1
Application B connecting to MySQL Database Instance 2 for schema db2
D. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active.
E. 2x MySQL Server Instances should be deployed on two machines with shared NFS volume. Datadir points to the shared folder. Applications can access either one of the MySQL Servers for the same set of data.
|
Download Printable PDF. VALID exam to help you PASS. |
 |