Hello @Friendica Admins ,
what is your backup strategy for the friendica database?
- What tools do you use?
- How often do you backup the database?
- How long do you save the backups?
- What else?
teilten dies erneut
⇧
Hello @Friendica Admins ,
what is your backup strategy for the friendica database?
teilten dies erneut
utzer [Friendica]
Als Antwort auf Matthias Moritz • • •@Matthias Moritz I use #borg backup and before that there is
mariabackup --backup --stream=xbstream --datadir=/var/lib/mysql | pigz -9 -p 6 >/var/mariabackup/mariabackup.gzexecuted to backup the DB.
You could probably also use
mysqldump -Aqf --routines --single-transaction --skip-lock-tables --max_allowed_packet=1024M|pigz > /var/mariabackup/all_databases.sql.gz#Borgbackup with the script from here:
borgbackup.readthedocs.io/en/s…
Keeping this:
diritschka mag das.
Friendica Admins hat dies geteilt.
Tuxi :Friendica: 🐧 ✅
Als Antwort auf utzer [Friendica] • •Sicherst Du absichtlich das komplette /var/lib/mysql und nicht nur das /var/lib/mysql/friendica?
Friendica Admins hat dies geteilt.
utzer [Friendica]
Als Antwort auf Tuxi :Friendica: 🐧 ✅ • • •Tuxi :Friendica: 🐧 ✅ mag das.
Friendica Admins hat dies geteilt.
Tuxi :Friendica: 🐧 ✅
Als Antwort auf utzer [Friendica] • •Noch eine Frage wenn ich darf: Macht es Sinn, vor dem Backup den mariadb Dienst zu stoppen oder reicht es aus de Instanz in den Wartungsmodus zu setzen?
Friendica Admins hat dies geteilt.
utzer [Friendica]
Als Antwort auf Tuxi :Friendica: 🐧 ✅ • • •Tuxi :Friendica: 🐧 ✅ mag das.
Friendica Admins hat dies geteilt.
diritschka
Als Antwort auf utzer [Friendica] • • •# apt-cache search mariabackup
Wo finde ich das "mariabackup"?
Friendica Admins hat dies geteilt.
diritschka
Als Antwort auf diritschka • • •Friendica Admins hat dies geteilt.
Tuxi :Friendica: 🐧 ✅
Als Antwort auf diritschka • •such mal nach mariadb-backup. Ich meine mich zu erinnern, dass es das ist.
Friendica Admins hat dies geteilt.
Matthias Moritz
Als Antwort auf diritschka • •diritschka mag das.
Friendica Admins hat dies geteilt.
Raroun
Als Antwort auf Matthias Moritz • • •So here the whole system is backed up.
A snapshot of the system is taken at a certain point in time, after which the backup is created. After the backup, the snapshot is deleted.
Afterwards, the backup is encrypted and transferred to an additional data centre.
The schedule looks like this:
every weekday,
4 weekly backups,
Six monthly backups
and one annual backup.
Every Backup is transfered to a VM host and boots up.
If the boot in a vm failes, another backup is taken and verified.
utzer [Friendica] mag das.
Friendica Admins hat dies geteilt.
utzer [Friendica]
Als Antwort auf Raroun • • •Friendica Admins hat dies geteilt.
Raroun
Als Antwort auf utzer [Friendica] • • •Since this is my daily businees, its literally no effort to me 😀
Friendica Admins hat dies geteilt.
utzer [Friendica]
Als Antwort auf Raroun • • •Raroun mag das.
Friendica Admins hat dies geteilt.
Raroun
Als Antwort auf utzer [Friendica] • • •From my point of view, its necessary.
Friendica Admins hat dies geteilt.
Raroun
Unbekannter Ursprungsbeitrag • • •@𝗝𝗮𝗸𝗼𝗯 :𝗳𝗿𝗶𝗲𝗻𝗱𝗶𝗰𝗮: 🇦🇹 ✅
... mehr anzeigenI agree with you when you say that the backup strategy from yours is a bit overdone.
Since I also use this strategy in my professional life, it was easy for me to apply it to my Friendica instance as well.
Why do backups take so long?
It's mainly forensic reasons. You can look up what was fact at time X 6 months ago.
Yes, with a social media instance like Friendica, an annual backup makes little sense, I agree. But I don't see any difference between a Friendica instance and other user data at the customer. I also have a system that I can restore at point in time X. Since the integrity of the backup is checked with each backup, I can sleep better.
Even if you re
@𝗝𝗮𝗸𝗼𝗯 :𝗳𝗿𝗶𝗲𝗻𝗱𝗶𝗰𝗮: 🇦🇹 ✅
I agree with you when you say that the backup strategy from yours is a bit overdone.
Since I also use this strategy in my professional life, it was easy for me to apply it to my Friendica instance as well.
Why do backups take so long?
It's mainly forensic reasons. You can look up what was fact at time X 6 months ago.
Yes, with a social media instance like Friendica, an annual backup makes little sense, I agree. But I don't see any difference between a Friendica instance and other user data at the customer. I also have a system that I can restore at point in time X. Since the integrity of the backup is checked with each backup, I can sleep better.
Even if you regularly check the recoverability of the backups, and even if you are 100% sure that it works, it is always better to have a backup from the day before from another system up your sleeve.
I have experienced so much "crap" in my professional life with backups that I would rather have 3845623854682346 different backups than rely on one.
Better Safe than Sorry.
Friendica Admins hat dies geteilt.