Download 1Z0-320 Exam Study Material - 1Z0-320 Braindumps

Question No 8

Which two architecture options can provide Active/Active Master configuration for the MySQL Database?

Options

A. Execute the following on the 2x MySQL Server Instancesmysql> ALTER REPLICATION set mode= active;
B. Deploy MySQL Cluster on the following machines:Machine 1: MySQL Node+ MySQL Management NodeMachine 2: MySQL Node+ MySQL Management NodeMachine 3: Data NodeMachine 4: Data
NodeApplication 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 2Application A connecting to MySQL Database Instance 1 for schema db1Application 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.

Answer: C,D