Is It a Good Idea to Synchronize Replication One Database at a Time? (Doc ID 2177432.1)

Last updated on AUGUST 31, 2016

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Goal

During maintenance of slave replica server some of the replica log files have been deleted and there is no way to start the replication processes again. The master server consists of 70 DB's and 1 TB of data. Is it better to use binlog_do_db option in the my.cnf file for each DB to setup replication one database at a time? or is there some other way to load the data one database at a time?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms