MariaDB is our favorite database to use for small business, and it meant for big business, so we’re using MariaDB for our business to keep growing. And I have a lot of skill experience with MariaDB than any database, but few other databases in my experience is lack. So, I don’t have time to do experience these. After I document all my notes and work for sure, I will study these (MongoDB, PostgreSQL) these I use some on app… Which is a pain for me, but I got the app working and stable. So let get start to Tutorial for MariaDB.
Make sure you do this first! Before starting build this,
Then We need to create a Network for MariaDB Database for another app to communicate, again. We would rather not expose our port!
docker network create mariadb
Then Now we can start to build stack detail for MariaDB Database on Portainer.
version: '2' services: mariadb: container_name: mariadb networks: - mariadb image: mariadb command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW restart: always environment: - MYSQL_ROOT_PASSWORD=yourownpassword - MARIADB_AUTO_UPGRADE=1 - MARIADB_DISABLE_UPGRADE_BACKUP=1 volumes: - /mnt/nasdrive/mariadb/:/var/lib/mysql networks: mariadb: external: true
Then you start deploying the stacks. And your app will be up running. Then you can add PhpMyAdmin to this docker-compose effortless. But I like separate stacks because, again, we can use one app for many databases.