startx/sv-mariadb repository overview

⁠Docker OS Images : MARIADB

Startx mariadb is a base container used for database services published in Dockerhub registry⁠ and Quay registry⁠. This container contain :

• fedora / centos /alpine /ubi operating system
• core OS packages (kernel, libs) updated every week
• fundamentals tools (ex: pwgen, tar, zip) updated every week
• usefull tools (psmisc, procps, coreutils, findutils, wget, curl, vi, bash-completion) only for the :latest flavour.
• Mariadb SQL server and fundamentals modules (mariadb release depend on the flavour you use, see container flavours⁠ for more information)

You can use Startx mariadb image in many ways :

• Docker OS Images : MARIADB⁠
  • Container flavours⁠
  • Running this image⁠
    • Running using docker⁠
    • Running using docker-compose⁠
    • Running using Openshift⁠
    • Using this image as S2I builder⁠
    • Using this image as base container⁠
  • Environment variable⁠
  • Container command⁠
  • For advanced users⁠
    • Build & run a container using docker⁠
    • Build & run a container using docker-compose⁠

See more applications builders and sample on startx docker images repository⁠

⁠Container flavours

⁠Running this image

If you want to be guided on setting-up and installing various containers engines (docker⁠, podman⁠, s2i⁠, dockerEE⁠, kubernetes⁠, openshift⁠) you can read ours containers engines guidelines⁠.

⁠Running using docker

docker run -it -p 9231:3306 --name="example-mariadb" startx/sv-mariadb

• Connect to your local database

mysql -h localhost -P 9231

⁠Running using docker-compose

• Create a docker-compose.yml file with the following content

mariadb:
  image: startx/sv-mariadb:latest
  container_name: "example-mariadb"

• Connect to your local database

mysql -h localhost -P 9231

• Execute the following command

docker-compose up -d
docker-compose logs

⁠Running using Openshift

• Openshift images streams

Openshift cluster administrator can offer this image and all its flavour to all consumers. You can import our openshift images stream⁠ in your openshift project.

You must be cluster-admin to add this image to the openshift project. If not, you can add it to your own project (skip the oc project openshift command in the next script)

# swith to the openshift project
oc project openshift
# Add image streams to the service catalog (project or cluster-wide scope)
oc create -f https://raw.githubusercontent.com/startxfr/docker-images/master/Services/mariadb/openshift-imageStreams.yml

• Openshift builder template

Openshift cluster administrator can add 2 build and deploy template to their consumers. As an administrator, you can import our openshift ephemeral builder template⁠ as well as our openshift persistent builder template⁠ in your openshift project.

You must be cluster-admin to add this image to the openshift project. If not, you can add it to your own project (skip the oc project openshift command in the next script)

# swith to the openshift project
oc project openshift
# Add this ephemeral template to the service catalog (project or cluster-wide scope)
oc create -f https://raw.githubusercontent.com/startxfr/docker-images/master/Services/mariadb/openshift-template-build.yml
# Add this persistent template to the service catalog (project or cluster-wide scope)
oc create -f https://raw.githubusercontent.com/startxfr/docker-images/master/Services/mariadb/openshift-template-build-persistent.yml

You can then build a database

# create an example project
oc new-project example
# start a new ephemeral database
oc process -f startx-mariadb-build-template \
    -p APP_NAME=mydb-e \
| oc create -f -
# start a new persistent database
oc process -f startx-mariadb-build-persist-template \
    -p APP_NAME=mydb-p \
| oc create -f -

• Openshift deploy template

Openshift cluster administrator can add a deploy template to their consumers. As an administrator, you can import our openshift deploy template⁠ in your openshift project.

You must be cluster-admin to add this image to the openshift project. If not, you can add it to your own project (skip the oc project openshift command in the next script)

# swith to the openshift project
oc project openshift
# Add this ephemeral template to the service catalog (project or cluster-wide scope)
oc create -f https://raw.githubusercontent.com/startxfr/docker-images/master/Services/mariadb/openshift-template-deploy.yml

You can then deploy a database

# create a example project
oc new-project example
# start a new ephemeral database
oc process -f startx-mariadb-deploy-template \
    -p APP_NAME=mydb-e \
| oc create -f -
# start a new persistent database
oc process -f startx-mariadb-deploy-persist-template \
    -p APP_NAME=mydb-p \
| oc create -f -

⁠Using this image as S2I builder

Create your local project (skip if you already are in a project diretory with a run bash script)

# Create a project directory
mkdir example-project
cd example-project
# create a run script
cat << "EOF"
DROP TABLE IF EXISTS `sample`;
CREATE TABLE `sample` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(128) NOT NULL DEFAULT '',
  `val` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sample` VALUES (1,'version','0.0.1');
EOF > schema-sample.sql

Then you can use this image as an s2i builder image

# With your current directory database code
s2i build . startx/sv-mariadb:latest startx-mariadb-mydb
docker run --rm -d -p 9231:3306 startx-mariadb-mydb
# With startx database sample code repository
s2i build https://github.com/startxfr/docker-images-example-mariadb startx/sv-mariadb startx-mariadb-sample
docker run --rm -d -p 9231:3306 startx-mariadb-sample

⁠Using this image as base 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⁠ for instructions on how to use this file.

FROM startx/sv-mariadb:latest
#... your container specifications

⁠Environment variable

⁠Container command

⁠For advanced users

You can contribute or start this container initiative locally. Follow theses instructions⁠ to setup a working environment.

This section will help you if you want to :

• Get latest version of this container Service source code
• Enhance and share your container improvement by adding instruction in Dockefile

⁠Build & run a container using docker

1. Jump into the container directory with cd Services/mariadb
2. Build the container using docker build -t startx-mariadb .
3. Run this container
   • Interactively with docker run -it startx-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,...)
   • As a daemon with docker run -d -p 9231:3306 startx-mariadb

⁠Build & run a container using docker-compose

1. Jump into the container directory with cd Services/mariadb
2. Run this container
   • Interactively with docker-compose up Startup logs appears and escaping this command stop the container
   • As a daemon with docker-compose up -d. Container startup logs can be read using docker-compose logs