Differenze tra le versioni di "Server/lessema/Technical documentation"
(#Backups) |
|||
| Riga 31: | Riga 31: | ||
:: {{Tl|Accesso server wmit|lessema|sistemisti}} | :: {{Tl|Accesso server wmit|lessema|sistemisti}} | ||
| − | == On-site backup == | + | == Backups == |
| + | |||
| + | === On-site backup === | ||
At 23:00 an on-site copy of all databases and webserver files are saved in this location: | At 23:00 an on-site copy of all databases and webserver files are saved in this location: | ||
| Riga 53: | Riga 55: | ||
https://gitpull.it/source/micro-backup-script/ | https://gitpull.it/source/micro-backup-script/ | ||
| − | == Off-site backups == | + | === Off-site backups === |
The same script that does [[#On-site backup]] also push the backup on server {{Server link|horror}} in this position: | The same script that does [[#On-site backup]] also push the backup on server {{Server link|horror}} in this position: | ||
| Riga 67: | Riga 69: | ||
The exact data retention is documented on server {{Server link|horror}}. | The exact data retention is documented on server {{Server link|horror}}. | ||
| − | == Other on-site backups == | + | === Other on-site backups === |
There is also this location with additional backups handled by {{Fornitore link|civih}}: | There is also this location with additional backups handled by {{Fornitore link|civih}}: | ||
Versione delle 09:47, 9 mag 2023
Unix users with sudo
Current enabled users with sudo:
- civihost-samuele (
💼 civih) - for CiviCRM development - civihost-stefano (
💼 civih) - for CiviCRM development - civihost-alessio (
💼 civih) - for CiviCRM development - emerald-stefano (
💼 eme) - tu support CiviCRM - anylink-davide-cuteri (
💼 Anylink) - in charge of operating system updates, backups, etc. - valerio-bozzolan (volunteer)
Password authentication is not allowed.
Add Unix user
Don't create Unix users with passwords.
Create Unix users with public SSH keys.
Shortcut:
/root/scripts/add-user.sh
Source code from Server/Setup
- Important
- After creation, mark the related user page in this website with:
- {{Accesso server wmit|lessema|sistemisti}}
Backups
On-site backup
At 23:00 an on-site copy of all databases and webserver files are saved in this location:
/var/backups/wmi/lessema.wikimedia.it
Note: the permissions of the parent directory MUST be set to 750 root:root to keep the backups not accessible by untrusted users (note: the www-data is considered not trusted).
The execution time can be edited with
crontab -e
Note: the backup script prevents duplicate executions caused by daylight saving or standard time changeover.
The backup instructions can be configured here:
/opt/micro-backup-script/backup-instructions.conf
This is the source code of our dummy backup script in use:
https://gitpull.it/source/micro-backup-script/
Off-site backups
The same script that does #On-site backup also push the backup on server ⚙️ horror in this position:
/var/backups/wmi/lessema.wikimedia.it
The users are authorized to access this location:
💼 civih(preferred professional contact)💼 eme(secondary professional contact)- User:Valerio Bozzolan (emergency volunteer contact)
The exact data retention is documented on server ⚙️ horror.
Other on-site backups
There is also this location with additional backups handled by 💼 civih:
/mnt/backup/databases
Script:
/root/mysql_db_backup.sh
Usually they are executed at 11:00, 15:00, 18:00. If you notice slowness in the application in these hours, consider changing or disabling this backup entry.