Examine this partial output for InnoDB Cluster status:
Which statement explains the state of the instance deployed on host2? It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('@host3:3377') It can rejoin the cluster by using the command cluster.addInstance('@host3:3377') It has been removed from the cluster by using the command STOP GROUP_REPLICATION; It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage() It has been expelled from the cluster because of a transaction error.
How can mysql_multi be configured to allow MySQL instances to use the same port number? The instances use different user accounts unique to each instance. The instances listen on different IP addresses. The instances use different socket names. The instances have appropriate net masks set.
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)
SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}). Configuring SSL group communication also configures SSL distributed recovery.
An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode. If only some InnoDB Cluster members are enabled for SSL group communication, and --ssl-mode=PREFERRED, communication will fall back to unencrypted connection. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes?
MySQL writes SDI to the binary log for distributed backups. MySQL keeps InnoDB metadata changes in .sdi files in datadir. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI). MySQL Server stores a copy of the serialized data in the InnoDB user tablespace. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.
Examine these statements and output: ---
Which statement is true? The user is logged in with --user=accounting as an option. The user is authenticated as the anonymous proxy user ‘’@’%’. The user is authorized as the accounting@localhost user. The user is authorized as the rsmith@localhost user. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?
Sort the “Exec" column and check for SQL queries with low Query Response Time index (QRTi) values. Look for queries with low total latency times in the Latency section in the times series graph. Look for queries with big prolonged spikes in row activity/access graph in the times series graph. Sort the “Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.
You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?
general query log audit log slow query log binary log error log.
Examine these entries from the general query log:
All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?
Connection 24 experiences a lock wait timeout. Connection 25 experiences a lock wait timeout. A deadlock occurs immediately. All statements execute without error. A deadlock occurs after innodb_lock_wait_timeout seconds.
Which four are types of information stored in the MySQL data dictionary? (Choose four.) performance metrics table definitions access control lists view definitions server runtime configuration server configuration rollback stored procedure definitions InnoDB buffer pool LRU management data.
Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true?
It fails if any of the roles is specified in the mandatory_roles variable. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles. Existing connections can continue to use the roles’ privileges until they reconnect. You must revoke all privileges from r_role1 and r_role2 before dropping the roles. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2. It fails if at least one of the roles does not exist.
|
