How to Restore A MySQL Master Which Has Stopped Generating Binary Log Files and/or Reset MySQL Slave Replication With Cluster Downtime on Oracle Big Data Appliance (Doc ID 2237773.1)

Last updated on NOVEMBER 20, 2023

Applies to:

Goal

To resolve the case where the following has occurred on the BDA:

1. The MySQL master has stopped generating binary log files and consequently the MySQL slave does not have replication turned on. This could happen if  /var/lib is full preventing data from flushing to disk, leaving some new data stored in memory.
or
2. The MySQL slave does not have replication turned on and due to the size of the databases taking downtime and copying the files is preferred to the steps in the "Verify the MySQL master/slave hosts" section in How to Reset MySQL Slave Replication without Full BDA Cluster Downtime (Doc ID 2152683.1).

Note: The steps here can also be considered an alternative process to use if you need to restore a slave to rebuild the master. Both MySQL master and slave need to be stopped and the cluster needs to be shutdown as per the note. The MySQL slave's data can be copied to the MySQL master, basically the same process but in reverse.  For this see: How to Restore A MySQL Master From MySQL Slave With Cluster Downtime on Oracle Big Data Appliance (Doc ID 2376877.1).

The steps in the example were done on MySQL 5.6.  But they apply to MySQL 5.5 with the differences pointed out below.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.