From a94ba1639fa444e99f7e5ec1f3f956b14db3e34b Mon Sep 17 00:00:00 2001 From: startxfr 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/README.md') 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 + + +# 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= --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