Which three are key advantages of standard MySQL replication? (Choose three.)

Which three are key advantages of standard MySQL replication? (Choose three.)A . supports native automatic failoverB . enables automatic resync of databases when discrepancies are detectedC . provides arbitrary geographic redundancy with minimal overhead to masterD . synchronously guarantees identical slave copyE . is easy to configure and has low performance overheadF . can...

Continue reading

Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)

Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)A . The cluster can be operated in multimaster mode with conflict detection for DML statements.B . All MySQL client programs and connectors can be used for executing queries.C . It provides fully synchronous replication between the nodes.D . There is support for automatic failover...

Continue reading

Which two options must be configured correctly to allow this?

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)A . log-master-updatesB . rpl-recovery-rankC . server-idD . enable-master-startE . log-binF . master-logging View Answer Answer: C,E Explanation: Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave­replication-in-mysql...

  • Sign up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
We do not share your personal details with anyone.