Question 71

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUSoutput:

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVEcommand. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVEcommand to resolve the duplicate key error. Which statement should be used?
  • Question 72

    You have just executed a manual backup by using this command:
    mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
    What is the state of this backup and operation required before it is ready to be restored?
  • Question 73

    Consider these global status variables:

    Which two conclusions can be made from the output? (Choose two.)
  • Question 74

    Which three are key advantages of standard MySQL replication?
  • Question 75

    Consider the two partial outputs of the SHOW GLOBAL VARIABLEScommand 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?