- relay-log-info-repository = TABLE (previous default FILE)
- relay-log-recovery = ON (previous default OFF)
- master-info-repository = TABLE (previous default FILE)
- sync-master-info = 1,000 (previous default 10,000)
- sync-relay-log = 1,000 (previous default 10,000)
Saturday, August 20, 2016
A discussion about sync-master-info and other replication parameters
Some time ago, feedback was requested on new replication default after MySQL 5.7. Some of the suggested default are: