Hello!
db1060 had a failed BBU and that caused the slave to lag as it went into writethrough mode.
root@db1060:~# megacli -LDInfo -L0 -a0 | grep "Current Cache Policy:" Current Cache Policy: WriteThrough, ReadAheadNone, Direct, No Write Cache if Bad BBU
root@db1060:~# megacli -AdpBbuCmd -aAll BBU status for Adapter: 0 BatteryType: BBU Voltage: 3497 mV Current: 0 mA Temperature: 45 C Battery State: Degraded(Need Attention) A manual learn is required. BBU Firmware Status: Charging Status : None BBU GasGauge Status: 0x0128 Relative State of Charge: 18 % Charger Status: Unknown
Can we get another one?
I have changed the Policy to WriteBack to help the server with the replication lag:
root@db1060:~# megacli -LDSetProp -ForcedWB -Immediate -Lall -aAll Set Write Policy to Forced WriteBack on Adapter 0, VD 0 (target id: 0) success root@db1060:~# megacli -LDInfo -L0 -a0 | grep "Current Cache Policy:" Current Cache Policy: WriteBack, ReadAheadNone, Direct, Write Cache OK if Bad BBU