Which of the following best describe a replication setup with regard to backup procedures?

The correct answer is C. 24 by 7 operations can be maintained without interruptions. D. 24 by 7 operations can be maintained with backups from a slave server. E. 24 by 7 operations can be maintained with a slave being the "hot spare". The advantage of making a backup this way is that it doesn't take place on the master server. Thus, the master need not be interrupted at all, and the backup procedure does not impose any extra disk or processing load on it.

MySQL Replication

Question

Options

A24 by 7 operations can be maintained but backups may not consist of a full snapshot
B24 by 7 operations can be maintained but may be halted at backup time.
C24 by 7 operations can be maintained without interruptions.
D24 by 7 operations can be maintained with backups from a slave server.
E24 by 7 operations can be maintained with a slave being the "hot spare".
Fnone of the above.

How the community answered

(29 responses)

A
14% (4)
B
3% (1)
C
79% (23)
F
3% (1)

Explanation

The advantage of making a backup this way is that it doesn't take place on the master server. Thus, the master need not be interrupted at all, and the backup procedure does not impose any extra disk or processing load on it.

Topics

#replication#backup strategy#slave server#high availability

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice