While testing MySQL 5.6, I came across some curious values for the new values used to set the crash-safe slave tables. To get safety, we need to set relay_log_info_repository and master_info_repository to 'TABLE'. That way, the replication information, instead of going to a file, will be saved to two tables in the mysql schema (mysql.slave_relay_log_info and mysql.slave_master_info).
So I was setting these values back and forth between 'FILE' and 'TABLE', until I made a "mistake." Instead of typing
set global relay_log_info_repository='table';
To [Read more...]
set global relay_log_info_repository=1;