From a94ba1639fa444e99f7e5ec1f3f956b14db3e34b Mon Sep 17 00:00:00 2001
From: startxfr <clarue@startx.fr>
Date: Sat, 5 Dec 2015 02:44:49 +0100
Subject: improving mariadb README.md

---
 Services/mariadb/README.md | 208 +++++++++++++++++++++++++++++++++------------
 1 file changed, 154 insertions(+), 54 deletions(-)

(limited to 'Services/mariadb')

diff --git a/Services/mariadb/README.md b/Services/mariadb/README.md
index b5f3d78..188808f 100644
--- a/Services/mariadb/README.md
+++ b/Services/mariadb/README.md
@@ -1,54 +1,154 @@
-# STARTX Services docker-images : MariaDB Server
-
-Container running mysqld daemon under a fedora server
-
-## Running from docker registry
-
-	docker run -d -p 3306:3306 --name="mariadb" startx/sv-mariadb
-        # when used with a volume container (run data container, then run service)
-	docker run -d -v /var/lib/mysql -v /var/logs/mysql --name mariadb-data startx/sv-mariadb  echo "Data container for mariadb"
-	docker run -d -p 3306:3306 --volumes-from mariadb-data --name="mariadb" startx/sv-mariadb
-	# when used in a linked container
-	docker run -d --name="mariadb" startx/sv-mariadb
-	docker run -d --name="php" --link mariadb:mariadb startx/sv-php
-
-## Build and run from local Dockerfile
-### Building docker image
-Copy sources in your docker host 
-
-	mkdir startx-docker-images; 
-	cd startx-docker-images;
-	git clone https://github.com/startxfr/docker-images.git .
-
-Change configuration and personalize your base image. See sx/mariadb_run.sh to perform some usefull task against the database, especially importing sql script, adding users and changing passwords. See also example.sql for injecting sql content when creating container.
-
-Build the container
-
-	docker build -t sv-mariadb Services/mariadb/
-
-### Running local image
-
-	docker run -d -p 3306:3306 --name="mariadb" sv-mariadb
-
-## Accessing server
-get connection information's, use docker logs to see result and connection details
-
-	docker logs mariadb
-
-access to the running database
-
-	mysql -h localhost -p 3306
-
-access to the container itself
-
-	docker exec -it mariadb /bin/bash
-
-## Related Resources
-* [Sources files](https://github.com/startxfr/docker-images/tree/master/Services/mariadb)
-* [Github STARTX profile](https://github.com/startxfr/docker-images)
-* [Docker registry for this container](https://registry.hub.docker.com/u/startx/sv-mariadb/)
-* [Docker registry for Fedora](https://registry.hub.docker.com/u/fedora/)
-* [Fedora-files mariadb container](https://github.com/fedora-cloud/Fedora-Dockerfiles/tree/master/mariadb)
-* [Tutum mariadb container](https://registry.hub.docker.com/u/tutum/mariadb/)
-* [Tutum mariadb github](https://github.com/tutumcloud/tutum-docker-mariadb)
-* [Dylan Lindgren mariadb container](https://registry.hub.docker.com/u/dylanlindgren/docker-mariadb/)
\ No newline at end of file
+<!--[metadata]>
++++
+title = "STARTX Docker Services Images : MARIADB"
+description = "Docker container with mariadb service based on latest fedora"
+keywords = ["home, docker, startx, mariadb, fedora, centos, repository, container, swarm, compose"]
+weight=3
++++
+<![end-metadata]-->
+
+# Docker OS Images : MARIADB
+
+Simple and lightweight (170Mo) container used to deliver mysql like database service using [mariadb project](https://mariadb.org/).
+Run [mariadb daemon](https://mariadb.org/) under a container based on [startx/fedora container](https://hub.docker.com/r/startx/fedora)
+
+| [![Build Status](https://travis-ci.org/startxfr/docker-images.svg)](https://travis-ci.org/startxfr/docker-images) | [Dockerhub Registry](https://hub.docker.com/r/startx/sv-mariadb/) | [Sources](https://github.com/startxfr/docker-images/Services/mariadb)             | [STARTX Profile](https://github.com/startxfr) | 
+|-------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------|----------------------------------------------------------------------------------|-----------------------------------------------|
+
+
+## Available flavours
+
+* `:latest` : Fedora core 23 + MariaDB 
+* `:fc23` : Fedora core 23 + MariaDB 
+* `:fc22` : Fedora core 22 + MariaDB 
+* `:fc21` : Fedora core 21 + MariaDB 
+* `:centos7` : CentOS 7 + MariaDB 
+* `:centos6` : Centos 6 + MariaDB 
+
+## Running from dockerhub registry
+
+* with `docker` you can run `docker run -it --name="sv-mariadb" startx/sv-mariadb` from any docker host
+* with `docker-compose` you can create a docker-compose.yml file with the following content
+```
+service:
+  image: startx/sv-mariadb:latest
+  container_name: "sv-mariadb"
+  environment:
+    CONTAINER_TYPE: "service"
+    CONTAINER_SERVICE: "mariadb"
+    CONTAINER_INSTANCE: "service-mariadb"
+    MYSQL_ROOT_PASSWORD: "rootpassword"
+    MYSQL_USER: "user-test"
+    MYSQL_PASSWORD: "pwd-test"
+    MYSQL_DATABASE: "db_test"
+  volumes:
+    - "/tmp/container/logs/mariadb:/data/logs/mariadb"
+    - "/tmp/container/mariadb:/data/mariadb"
+```
+
+## Docker-compose in various situations
+
+* sample docker-compose.yml linked to host port 1000
+```
+service:
+  image: startx/sv-mariadb:latest
+  container_name: "sv-mariadb"
+  environment:
+    CONTAINER_INSTANCE: "service-mariadb"
+  ports:
+    - "1001:3306"
+```
+* sample docker-compose.yml with port exposed only to linked services
+```
+service:
+  image: startx/sv-mariadb:latest
+  container_name: "sv-mariadb"
+  environment:
+    CONTAINER_INSTANCE: "service-mariadb"
+  expose:
+    - "3306"
+```
+* sample docker-compose.yml using data container
+```
+data:
+  image: startx/fedora:latest
+  container_name: "sv-mariadb-data"
+  environment:
+    CONTAINER_INSTANCE: "service-mariadb-data"
+service:
+  image: startx/sv-mariadb:latest
+  container_name: "sv-mariadb"
+  environment:
+    CONTAINER_INSTANCE: "service-mariadb"
+  volume_from:
+    - data:rw
+```
+
+## Using this image in your own container
+
+You can use this Dockerfile template to start a new personalized container based on this container. Create a file named Dockerfile in your project directory and copy this content inside. See [docker guide](http://docs.docker.com/engine/reference/builder/) for instructions on how to use this file.
+ ```
+FROM startx/sv-mariadb:latest
+#... your container specifications
+CMD ["/bin/run.sh"]
+```
+
+## Environment variable
+
+| Variable                  | Type     | Mandatory | Description                                                              |
+|---------------------------|----------|-----------|--------------------------------------------------------------------------|
+| CONTAINER_INSTANCE        | `string` | `yes`     | Container name. Should be uning to get fine grained log and application reporting
+| CONTAINER_TYPE            | `string` | `no`      | Container family (os, service, application. could be enhanced 
+| CONTAINER_SERVICE         | `string` | `no`      | Define the type of service or application provided
+| MYSQL_ROOT_PASSWORD       | `string` | `no`      | Root password used for this instance. Default will use an auto generated password displayed on startup
+| MYSQL_USER                | `string` | `no`      | If present, add a new user with this name
+| MYSQL_PASSWORD            | `string` | `no`      | Password associated to the new user declared with $MYSQL_USER
+| MYSQL_DATABASE            | `string` | `no`      | If present, add a new database with this name
+| HOSTNAME                  | `auto`   | `auto`    | Container unique id automatically assigned by docker daemon at startup
+| LOG_PATH                  | `auto`   | `auto`    | is set to /data/logs/mariadb and used as a volume mountpoint
+| APP_PATH                  | `auto`   | `auto`    | is set to /data/mariadb and used as a volume mountpoint
+
+## Exposed port
+
+| Port  | Description                                                              |
+|-------|--------------------------------------------------------------------------|
+| 3306  | standard mariadb network port used for sql communication
+
+## Exposed volumes
+
+| Container directory  | Description                                                              |
+|----------------------|--------------------------------------------------------------------------|
+| /data/logs/mariadb    | log directory used to record container and mariadb logs
+| /data/mariadb         | data directory served by mariadb. If empty will be filled with database files on startup. In other case use content from mountpoint or data volumes
+
+## Testing the service
+
+access to the running service with mysql terminal `mysql --host=localhost --port=3306 --user=<MYSQL_USER> --password=<MYSQL_PASSWORD>`. Change port and hostname according to your current configuration
+
+## For advanced users
+
+You want to use this container and code to build and create locally this container, follow theses instructions.
+
+This section will help you if you want to :
+* Get latest version of this service container
+* Enhance container content by adding instruction in Dockefile before build step
+
+You must have a working environment with the source code of this repository. Read and follow [how to setup your working environment](https://github.com/startxfr/docker-images#setup-your-working-environment-mandatory) to get a working directory. The following instructions assume you are at the top level of your working directory.
+
+### Build & run a container using `docker`
+
+1. Jump into the container directory with `cd Services/mariadb`
+2. Build the container using `docker build -t sv-mariadb .`
+3. Run this container 
+  1. Interactively with `docker run -p 3306:3306 -v /data/logs/mariadb -it sv-mariadb`. If you add a second parameter (like `/bin/bash`) to will run this command instead of the default entrypoint. Usefull to interact with this container (ex: `/bin/bash`, `/bin/ps -a`, `/bin/df -h`,...) 
+  2. As a daemon with `docker run -p 3306:3306 -v /data/logs/mariadb -d sv-mariadb`
+
+
+### Build & run a container using `docker-compose`
+
+1. Jump into the container directory with `cd Services/mariadb`
+2. Run this container 
+  1. Interactively with `docker-compose up` Startup logs appears and escaping this command stop the container
+  2. As a daemon with `docker-compose up -d`. Container startup logs can be read using `docker-compose logs`
+
+If you experience trouble with port already used, edit docker-compose.yml file and change port mapping
-- 
cgit v1.2.3