On Sun, 5 Jan 2020 22:19:59 +0100 Lars Vogdt
TL;DR: - Galera cluster is upgraded to latest version from server:database - backups are done each day (03:00 UTC) by mybackup.infra.opensuse.org now - backup retention is planned to be 30 days (calculation still ongoing)
- Added mysql.infra.opensuse.org port 3308 for read (select) SQL queries. Those are also distributed between the Galera nodes (with higher Prio for galera3 and galera1, while galera2 get's write traffic). If "your" application allows to send select statements to another machine than insert/update statements, please use this new port. - Did some additional tuning of all 3 Galera nodes. Helpfull scripts are 'mysqltuner.pl' and 'tuning-primer.sh'. Both are packaged in mysql-tuning-scripts (together with some additional files) and installed on each node. Please note that blindly following the output of those scripts will not really help - but they give good directions where to look at. - The configuration of the 3 Galera nodes is manually synchronized via 'csync2' at the moment. This can be saltified later, once the systems does not need much tuning any longer. Regards, Lars -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org