Mysql_h5_h9
by Stefan Mayer
1. H5_MASTER
1.1. v. 5.6.31
1.2. SET GLOBAL expire_logs_days = 3;
1.3. PURGE BINARY LOGS BEFORE '2017-06-26 22:46:21';
1.4. /var/log/mysql/mysql-bin*
1.5. BIG-PROBLEM: NO FREE DISKSPACE MORE ON H5.PSPROX.COM
2. H9_SLAVE
2.1. SET MASTER-DELAY
2.1.1. STOP SLAVE;
2.1.2. CHANGE MASTER TO MASTER_DELAY = 6;
2.1.3. START SLAVE ;
2.2. v. 5.6.35
2.3. SET GLOBAL expire_logs_days = 3;
2.4. restart slave
2.4.1. stop slave;
2.4.2. reset slave;
2.4.3. start slave ;
2.4.4. show slave STATUS ;