You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on three machines to a connected Storage NFS?
A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Enterprise Backup on machine which is used to start the backup.
3. Start mysqlbackup on only one machine with the installation to back up the databases for the threemachines to the mounted volume using – -backup-dir and by giving –hosts=machine1:port1, machine2:port2, machine3:port3.
4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Enterprise Backup on all three machines.
3. Start mysqlbackup on all machines to back up the database to the mounted volume using – -backupdir.
4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.
C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Enterprise Backup on the machine that is used to start the backup.
3. Start mysqlbackup on only one machine with the installation to back up the databases for the threemachines to the mounted volume using – – backup-dir and by specifying — config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.
4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.
D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.
2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines toback up and restore.
3. Startup MySQL backup from MySQL Workbench to back up the three databases.
4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
|
Download Printable PDF. VALID exam to help you PASS. |
 |