Support multiple databases creation

[visay]

Currently I only have the option to create only one database in my docker-compose.yml

db:
  image: mariadb:10.0
  environment:
    MYSQL_DATABASE: mydbname

It would be good if multiple databases is supported (something similar to this merge request in mysql https://github.com/docker-library/mysql/pull/18/files), so I can write:

db:
  image: mariadb:10.0
  environment:
    MYSQL_DATABASES:
      - mydbname1
      - mydbname2

[yosifkit]

Although your yaml syntax would not work, there was discussion of letting MYSQL_DATABASE be a space separated string of databases: docker-library/mysql#18.

[bennythomps]

Keep in mind @visay, best practice would be to have a separate container for each application if that's what you're trying to do. Maybe your one application for some reason needs more than one database, though.

[Crafter6432]

+1

[Vingtoft]

+1

[madalinignisca]

-1

the idea for docker is minimalism. one database per container. you can start multiple containers with different databases.

[robbinalexander]

@madalinignisca Probably ok during development. What about the additional resource required to run another container? And additional configurations needed, especially when I need a mysql cluster?

[madalinignisca]

You can make a simple Dockerfile using this one as the image source and just add your own extra env variables to add more databases to your service. Easy as that. The base one isn't supposed to cover all possible scenarios we think about, but to offer the foundation on which we build the solutions to our problems.

Building it it might take an extra second or less ;)

[amir20]

Reading the README file suggests

Furthermore, it will execute files with extensions .sh, .sql and .sql.gz that are found in /docker-entrypoint-initdb.d.

So adding your own .sql file should be able to create multiple databases.

[alexanikanov]

+1

[qmcree]

Thanks, @amir20, that did it -- total duh moment LOL

[armansd]

Just update startup file under mysql directory:

DROP USER IF EXISTS 'MYSQL_USER';
CREATE USER 'MYSQL_USER'@'%';
CREATE DATABASE IF NOT EXISTS MYSQL_DATABASE;
GRANT ALL ON MYSQL_DATABASE.* TO 'MYSQL_USER'@'%' IDENTIFIED BY 'MYSQL_PASSWORD';
--------------your new testDB----------------------
CREATE DATABASE IF NOT EXISTS testDB;
GRANT ALL ON testDB.* TO 'MYSQL_USER'@'%' IDENTIFIED BY 'MYSQL_PASSWORD';

[sirgalleto]

What's the status of this issue? why is closed?

[visay]

@sirgalleto because you can already do it with our own script if they are mounted into /docker-entrypoint-initdb.d.

See the description at https://hub.docker.com/_/mariadb/ section "Initializing a fresh instance"