Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
dienste:bytecluster0002:mariadb [28.09.2020 18:42] – mape2k | dienste:bytecluster0002:mariadb [05.08.2023 22:08] (aktuell) – Debian Testing wird nicht mehr benötigt mape2k | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
====== Container ' | ====== Container ' | ||
+ | |||
+ | ===== Ressourcen ===== | ||
+ | |||
+ | * 1 GB RAM | ||
+ | * 2 Cores | ||
+ | * 8 GB HDD (root-fs) | ||
===== System ===== | ===== System ===== | ||
Zeile 10: | Zeile 16: | ||
* MariaDB 10 | * MariaDB 10 | ||
+ | |||
+ | ===== Datenbanken ===== | ||
+ | |||
+ | ^ Datenbank | ||
+ | | cloud | cloud | [[cloud]] | ||
+ | | etherpadlite | ||
+ | | nextcloud | ||
+ | | paste | paste | [[paste]] | ||
+ | | wordpress | ||
+ | | wordpress_technikkultur | ||
+ | | wordpress_freifunk_erfurt | ||
===== Betrieb ===== | ===== Betrieb ===== | ||
Zeile 17: | Zeile 34: | ||
* **sudo mysql** | * **sudo mysql** | ||
- Datenbank anlegen und Benutzer mit Passwort zuweisen< | - Datenbank anlegen und Benutzer mit Passwort zuweisen< | ||
- | CREATE DATABASE | + | CREATE DATABASE databasename; |
- | GRANT ALL PRIVILEGES ON 'databasename'.* TO ' | + | GRANT ALL PRIVILEGES ON databasename.* TO ' |
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
</ | </ | ||
Zeile 71: | 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 | ||
+ | * **< |