Differences

This shows you the differences between two versions of the page.

--- cbsnet [2025/12/15 13:41] – reno
+++ cbsnet [2025/12/17 14:13] (current) – reno
@@ Line 141: / Line 141: @@
 \\
 ===== Backups =====
-Backup are maintain via timeshift program. It creates two sets of backup of the entire "brews" drive
+  - Drive Backups are managed by [[https://github.com/linuxmint/timeshift|timeshift]].
-  - Monthly Backup
+    - Monthly Backup
-    - Backup are made on the 1st of each month at 00:00:01 UTC
+      - Backup are made on the 1st of each month at 00:00:00 UTC
-    -
+      - up to 3 copies are saved at one time
-  - Weekly Backup
+    - Weekly Backup
+      - Backup are made on each Sunday at 21:00:00 UTC
+      - up to 2 copies are saved at one time
+  - Database backups are managed by the db_backup.sh
+    - Database base backup are done every Tuesday and at 04:00:00 UTC
+    - Up to 9 copies are saved at one time
+    - Database that are being backed up are
+      - brewerdata
+      - brewer_db
+      - brewer_security
+      - brewerpart
+      - metabase
+\\
+===== Database =====
+There are currently 5 database (as of Dec 17, 2025) running on cbsnet via mariadb (Version 10.5.29-MariaDB-0+deb11u1 Debian 11)
+  - brewerdata - this database is primary used to host the IDEAS database and includes all the brewer data. The best way to view this data is via [[https://metabase.cbsn.hiitravel.ca|metabase]].
+  - brewer_db - this database is used to for hosting the brewer log form data.
+  - brewer_security - this database is used to host the user information needed for the brewer log form
+  - brewerpart - This database is used to host the brewer parts database. This is what brewparts.exe uses
+  - metabase - This database is used to host the config and different views used for [[https://metabase.cbsn.hiitravel.ca|metabase]].