Public | Automated Build

Last pushed: 9 months ago
Short Description
mariadb-for-dcm4chee
Full Description

dockerized-mariadb-for-dcm4chee

Docker image that provides a MariaDB instance for DCM4CHEE 5.x

Based on https://github.com/dcm4che-dockerfiles/postgres-dcm4chee

Migrated from https://github.com/opendicom/dockerized-dcm4chee-mariadb

There are a couple of compose files available on the docker-compose directory that bootstap replicated nodes.
The simplest one starts a local environment with two containers. The purpose of the other two (host_one.yml and host_two.yml) is to test the replication with containers running on separate docker hosts.

Let's start with the local environment. Get it up by running
docker-compose up. After that, get inside the first container by executing
docker exec -ti db_node_one bash and:

  • Start a mysql session: mysql -psecure awesome
  • Get the status of the cluster: SHOW STATUS LIKE 'wsrep_cluster_size';
  • Insert a row in some random table: insert into code (pk) values(123);

Now read that row from the other node. Get inside it by executing docker exec -ti db_node_two bash and:

  • Start a mysql session: mysql -psecure awesome
  • Get the status of the cluster: SHOW STATUS LIKE 'wsrep_cluster_size';
  • Read from the table: select * from code;
Node One:
root@11dfe3540057:/# mysql -psecure awesome
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.1.14-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [awesome]> SHOW STATUS LIKE 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 2     |
+--------------------+-------+
1 row in set (0.01 sec)

MariaDB [awesome]> insert into code (pk) values(123);
Query OK, 1 row affected, 4 warnings (0.01 sec)
Node Two:
root@5099b8d519ec:/# mysql -psecure awesome                                                                                                                                                               
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.14-MariaDB-1~jessie mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [awesome]> select * from code;
+-----+--------------+------------+-----------------+--------------+
| pk  | code_meaning | code_value | code_designator | code_version |
+-----+--------------+------------+-----------------+--------------+
| 123 |              |            |                 |              |
+-----+--------------+------------+-----------------+--------------+
1 row in set (0.00 sec)

Sources

Galera Cluster System Variables:

Docker Pull Command
Owner
opendicom

Comments (0)