You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
It must be possible to rebuild the instance using the backup.
It must be verified.
It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)
Which MySQL utility copies the master instance to a slave instance on the same host?
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:
Slave:
There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?
Consider the ANALYZE TABLE command.
In which two situations should this command be used?
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)
Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?
Consider:
What does the range value in the type column mean?
