Home » MYSQL » MySQL Access Control and Security » Question
  1. What causes a replication master server to delete all the binary log files even if they are still in use?
    1. FLUSH LOGS
    2. RESET MASTER LOGS
    3. FLUSH TABLES
    4. RELOAD
    5. None of these
Correct Option: B

‘RESET MASTER LOGS’ causes a replication master server to delete all binary log files even if they are in use which removes the information necessary to maintain the replication integrity.



Your comments will be displayed only after manual approval.