Steps to Setup Automatic Purging of MySQL Binary Logs on Oracle Big Data Appliance (BDA)
(Doc ID 1529258.1)
Last updated on MAY 23, 2021
Applies to:Big Data Appliance Integrated Software - Version 2.0.1 to 4.0 [Release 2.0 to 4.0]
This document provides the steps to enable automatic purging of mysql binary logs on Oracle Big Data Appliance(BDA)
On Oracle Big Data Appliance, MySQL Binary Log feature is enabled for High Availability / Replication.
The binary log has two important purposes:
- Data Recovery: It may be used for data recovery operations. After a backup file has been restored, the events in the binary log that were recorded after the backup was made are re-executed. These events bring databases up to date from the point of the backup.
- High Availability / Replication: The binary log is used on master replication servers as a record of the statements to be sent to slave servers. The master server sends the events contained in its binary log to its slaves, which execute those events to make the same data changes that were made on the master.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document