TECHNICAL DOCS

PostgreSQL, MySQL containers and cloning

Windocks delivers database clones and containers for PostgreSQL and MySQL. See the samples in windocks\samples\postgres and windocks\samples\mysql

First create the dockerfile as follows:

dockerfile for MySQL

FROM mysql-5.7

SETUPCLONING FULL vendors C:\windocks\dbbackups\mysqldump1

dockerfile for PostgreSQL

FROM postgres-10.13

SETUPCLONING FULL customers C:\windocks\dbbackups\pgdump1

 

Build the image from the above dockerfile. This will create an image

In a command line on the Windocks server:
docker build -t yourimagename path\to\directory\containing\dockerfile

Alternatively, use the web application and click on Build in the top menu and click Browse. Select all the files in the directory (dockerfile, any script files) and then Open. Then click Build.

You may also use the REST API to build the image

 

Create a container from the image. This can be done using a command line (only on the Windocks machine), or the web application (from any machine) or from the REST API (any machine)

In a command line on the Windocks server:
docker run -d yourimagename

This will deliver a container with a writeable database clone of the vendors database

You may also create containers with the clones from the web application at ServerIp:/index.html or the file windocks\ui\index.html in Chrome or Firefox

You may also create containers with the REST API here

 

View logs of the scripts in the web application by clicking log next to your container / clone.

Extend CI/CD to your data layer