Theo Chatzimichos wrote:
3) what we did to avoid the problem from happening again
We changed the time that the daily cron jobs are running on the second and the third node, in order to avoid the issue is happening again. So now the daily cron jobs on the first node will run on 19:00, on the second node at 19:30 and on the third node at 20:00.
4) what we could also do to improve the situation
- more frequent backups (eg 4 times per day) - enable backups on galera3 as well - make sure that the auto-update script doesn't run at the same time on all three hosts - add connect.opensuse.org webpage to the monitoring
It might be worth considering if there really is a need to run logrotate for mysql. mysql usually doesn't log much unless someone has turned on query logging (for debugging). -- Per Jessen, Zürich (14.1°C) openSUSE mailing list admin -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org