#mariadb - can one instance be used with several apps?

3 messages · Page 1 of 1 (latest)

restive locust
#

Hi Fellas! Im new to CasaOS, MariaDB and Docker in general. Assuming i had several apps that could make use of a db, could i run one instance (one container) of mariadb and just create db tables within that one instance for each app? And if so, how would i set this up?... or would each app need its own instance of mariaDB.

restive locust
#

also: i'm trying to follow BigBears tut on how to install Nextcloud with Mariadb and he is mapping just the /config folder. I got two 2TB ssd drives connected to my zimaboard and i want to store all data on those drives rather than on the internal drive. Not sure what folders i should create and map. In the documentation of mariadb on docker hub i see they map "/my/own/datadir:/var/lib/mysql". I'm confused ... if i only map "config" ... will mariadb create all other needed folders automatically in the custom maped folder on my ssd? Should i map "/mnt/Storage1/mariadb/config:/config" or "/mnt/Storage1/mariadb/data:/var/lib/mysql"? ... i'm confused.

foggy seal
#

I don't use Maria as such but normally one instance of maria can handle several databases. Usually its set up that way as each instance of Maria would use up RAM and CPU jsut to run, and you really want to minimise what resources the OS and software uses so the server can use RAM to cache transactions to speed its performance up.