A.It manages the configuration of the MySQL Firewall feature.

B.It will use [client] options by default unless you provide --login-path.

C.It provides an interface to change my.cnf files.

D.It manages the configuration of client programs.

E.It manages the configuration of user privileges for accessing the server.

F.It can move datadir to a new location.

G.It can be used to create and edit SSL certificates and log locations.

A.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.

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

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

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

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

A.The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B.The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

C.The mysqlcheck --optimize --all-databases command reclaims free space from table files.

D.The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
Section: (none)
Explanation

E.The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

A.Execute SET GLOBAL log_error = ‘<new error log file>’.

B.Execute SET GLOBAL max_error_count = <number of messages at point to rotate>.

C.Execute SET GLOBAL expire_logs_days=0to enforce a log rotation.

D.Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

A.Remove group read/write privileges from the private_key.pem file.

B.Change the parent directory owner and group to mysql.

C.Change the group ownership of the mysql directory to the mysql user group.

D.Remove world read privileges from the server-cert.pem certificate file.

E.Remove the world read/execute privilege from the accounting directory.

F.Remove world read privileges from the public_key.pem file.