Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
dienste:bytecluster0002:mariadb [05.10.2020 23:56] – [Tabelle] added wordpress chaos | dienste:bytecluster0002:mariadb [05.08.2023 22:08] (aktuell) – Debian Testing wird nicht mehr benötigt mape2k | ||
---|---|---|---|
Zeile 19: | Zeile 19: | ||
===== Datenbanken ===== | ===== Datenbanken ===== | ||
- | ^ Datenbank | + | ^ Datenbank |
- | | nextcloud | + | | cloud | cloud | [[cloud]] |
- | | wordpress | + | | etherpadlite |
+ | | nextcloud | ||
+ | | paste | paste | [[paste]] | ||
+ | | wordpress | ||
+ | | wordpress_technikkultur | ||
+ | | wordpress_freifunk_erfurt | ||
===== Betrieb ===== | ===== Betrieb ===== | ||
Zeile 83: | Zeile 88: | ||
- MariaDB neustarten | - MariaDB neustarten | ||
* **systemctl restart mariadb.service** | * **systemctl restart mariadb.service** | ||
+ | |||
+ | ==== Backup mit Borgmatic ==== | ||
+ | |||
+ | - Borgmatic installieren | ||
+ | * **sudo apt-get update** | ||
+ | * **sudo apt-get install borgmatic** | ||
+ | - pwgen installieren | ||
+ | * **sudo apt-get install pwgen** | ||
+ | - Borgmatic-Konfiguration in der Datei / | ||
+ | * **sudo generate-borgmatic-config** | ||
+ | - SSH-Key erzeugen | ||
+ | * **sudo ssh-keygen -a100 -t ed25519 -f / | ||
+ | - SSH-Key bei Backupserver hinterlegen | ||
+ | - Zufälliges Passwort in Konfiguration erzeugen< | ||
+ | sudo sed -i -e " | ||
+ | sudo sed -i " | ||
+ | - Konfiguration anpassen (USERNAME, SERVERNAME, SSH-PORT ersetzen)< | ||
+ | location: | ||
+ | ... | ||
+ | source_directories: | ||
+ | - /etc | ||
+ | - /home | ||
+ | - /root | ||
+ | - /usr/local | ||
+ | - /var/log | ||
+ | ... | ||
+ | repositories: | ||
+ | - USERNAME@SERVERNAME: | ||
+ | ... | ||
+ | one_file_system: | ||
+ | ... | ||
+ | exclude_caches: | ||
+ | ... | ||
+ | storage: | ||
+ | ... | ||
+ | encryption_passphrase: | ||
+ | ... | ||
+ | compression: | ||
+ | ... | ||
+ | ssh_command: | ||
+ | ... | ||
+ | retention: | ||
+ | ... | ||
+ | keep_daily: 7 | ||
+ | ... | ||
+ | keep_weekly: | ||
+ | ... | ||
+ | keep_monthly: | ||
+ | ... | ||
+ | keep_yearly: | ||
+ | ... | ||
+ | consistency: | ||
+ | ... | ||
+ | checks: | ||
+ | - repository | ||
+ | - archives | ||
+ | ... | ||
+ | hooks: | ||
+ | before_backup: | ||
+ | - dpkg-query -f ' | ||
+ | ... | ||
+ | mysql_databases: | ||
+ | - name: all | ||
+ | ... | ||
+ | </ | ||
+ | - Borg-Repository initialisieren | ||
+ | * **< | ||
+ | - Verschlüsselungsinformationen sicher verwahren | ||
+ | - Verschlüsselungs-Passwort ermitteln | ||
+ | * **< | ||
+ | - Verschlüsselungs-Schlüssel ermitteln | ||
+ | * **sudo cat / | ||
+ | - Erstes Backup initialisieren | ||
+ | * **< | ||
+ | ------------------------------------------------------------------------------ | ||
+ | Archive name: mariadb-2020-12-05T17: | ||
+ | Archive fingerprint: | ||
+ | Time (start): Sat, 2020-12-05 17:36:49 | ||
+ | Time (end): | ||
+ | Duration: 6.57 seconds | ||
+ | Number of files: 472 | ||
+ | Utilization of max. archive size: 0% | ||
+ | ------------------------------------------------------------------------------ | ||
+ | | ||
+ | This archive: | ||
+ | All archives: | ||
+ | |||
+ | | ||
+ | Chunk index: | ||
+ | ------------------------------------------------------------------------------ | ||
+ | </ | ||
+ | - Backupinhalt nochmal prüfen | ||
+ | * **< | ||
+ | USERNAME@SERVERNAME: | ||
+ | drwxr-xr-x root | ||
+ | -rw-r--r-- root | ||
+ | ... | ||
+ | </ | ||
+ | - Cronjob einrichten | ||
+ | * **< |