Question No 2
By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.
Options
A.MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
B.MySQL Enterprise Backup will back up from Slave automatically.
C.It provides multi-master access where the application can write and read data across the databaseservers.
D.It allows backup to be done on the slave without impacting the master.
E.You can create a slave server for reporting applications, which get only read access to the slave servers.It off-loads the master server. Additional servers allow different database server configuration.
Answer: B D E

No comments:
Post a Comment
Note: Only a member of this blog may post a comment.