Self-host the Databases

Hosting the databases yourself outside the containers can be quite usefull.

Why ?

Well this way you are fully in controll of the data, backups and can you for example easily let your AI model learn your network through the collected data from Slurp’it.

Recently we received the following support ticket:

Our company has a Database department where they will fully manage the Redundancy and Backups of our data. We kind of prefer to make use of this, is it possible to have the Slurp’it data stored outside the containers?

This is possible, and what’s good to know is that Slurp’it is using 2 databases:

– MariaDB (relational SQL) for the Portal
– MongoDB (no SQL) for the Warehouse

How do I host them outside the containers?

Docker compose variables for the Portal

PORTAL_DB_HOSTNAME: localhost
PORTAL_DB_NAME: portal
PORTAL_DB_PORT: 3306
PORTAL_DB_USERNAME: root
PORTAL_DB_PASSWORD: welcome1

Docker compose variables for the Warehouse

WAREHOUSE_MONGODB_LOCAL: false
WAREHOUSE_ MONGODB _HOST: localhost
WAREHOUSE_ MONGODB _DBNAME: slurpit
WAREHOUSE_MONGODB _USERNAME: root
WAREHOUSE_MONGODB _PASSWORD: welcome1

Example