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 APRIL 09, 2018
Applies to:Big Data Appliance Integrated Software - Version 4.5.0 and later
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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!