A.Replication can use only TCP/IP connections.

B.Binary logging must be enabled on the master in order to replicate to other instances.

C.Any instance can have multiple slaves, but it can have only one master.

D.Binary logs contain only transactions originating from a single MySQL instance.

E.Each instance in a replication topology must have a unique server ID.

F.A replication user must have the SELECT privilege for all tables that need to be replicated.

G.Each slave must have its own MySQL user for replication.

A.MySQL Router is restarted.

B.MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

C.MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

D.MySQL Router is configured based on the information in files in directory_path.

A.ib_logfile0

B.undo_001

C.mysql.ibd

D.ibdata1

E.ibtmp1

F.ib_buffer_pool

A.The cluster will shut down to preserve data consistency.

B.A manual intervention to force group members to be only the working two instances is required.

C.There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

D.The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

E.The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

A.Snapshot-based backups greatly reduce time during which the database and applications are unavailable.

B.Snapshot backups can be used only in virtual machines.

C.There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.

D.The frozen file system can be cloned to another virtual machine immediately into active service.

E.A separate physical copy must be made before releasing the snapshot backup.