Public | Automated Build

Last pushed: 8 months ago
Short Description
This a simple image to play around with flyway using a MariaDB database.
Full Description

MariaDB Docker Image with Flyway

Table of Contents

##Project Description ##
This project provides a simple MariaDB Docker image that,
although it uses reasonable default values for most configuration options, it allows you to provide you own
configuration and change the default values to your personal requirements.
In addition to the pure database this Docker file provides Flyway,
a tools that lets you populate your database with some versionable structure (tables, views, triggers, ...)
and data in an easy and reproducible way.

##Contact information ##

Name Email
Michael Neßlinger michael.nesslinger@gmx.de

##Example Use Case Scenarios ##
The whole project is not intended for use in any kind of production environment. You should see this image as a
way to quickly spawn a single MariaDB instance and use it to do some evaluation or prototyping.
An image used in production would require a much better security hardening. The use cases focus completely on evaluation
and prototyping with a single instance version of MariaDB.

For all the following use cases it is assumed, that you have access to a host that runs a Docker
daemon and that you have the permission to start and stop Docker containers on this host.
If that is not the case, please have a look at this page:
Install Docker Engine

###Simple Use Case without Flyway ###
You just want to get a MariaDB database up and running with no prefilled databases and tables.

This could for example be the case, when you have some SQL data
exported from another database and you want to analyze it in a separate
instance. If you are more into things that have an UI you might want to use
your favorite SQL client to populate the database.
Assuming you have access to a host running docker all you need to do
is typing:

docker run -d -p 3306:3306 nesslinger/docker-flyway-mariadb

Now, after some time the DBMS needs to start up, you should be able to connect to MariaDB by using the IP of the
docker host and the standard port 3306. You can connect as user "root"
with password "verysecret".

###Simple Use Case with Flyway ###
You just want to get a MariaDB database up and running with a prefilled database. You do not care about
the content of the database.

This could for example be the case, when you want to test a new SQL client and its features.
In situations like this some prefilled database you can easily destroy and recreate with a single command
is very handy.
Assuming you have access to a host running docker all you need to do
is typing:

docker run -d -p 3306:3306 -e FLYWAY_POPULATE_DATABASE=true nesslinger/docker-flyway-mariadb

In the example above the database will be populated with the latest version (1_0_2) of data bundled with this image.
If you want to use a previous version you can submit the version in the following way:

docker run -d -p 3306:3306 -e FLYWAY_POPULATE_DATABASE=true -e FLYWAY_DATABASE_VERSION=1_0_1 nesslinger/docker-flyway-mariadb

Now, after some time the DBMS needs to start up, you should be able to connect to MariaDB by using the IP of the
docker host and the standard port 3306. You can connect as user "root" with password "verysecret".

###Providing your own SQL data for Flyway ###

###Providing your own configuration for MariaDB ###

###Use this image as base image for your own image ###

###Problems running the examples ###
If you are not able to run the examples above, please have a look at the
Troubleshooting Guide first. If you do not find
an answer to your question please contact us. If you
think you found a bug please read Report a bug and file a ticket.

##Getting Started Guide ##
The fastest way to get running:

  • Install Docker Engine if not already installed
  • start the container:
    • docker run nesslinger/docker-flyway-mariadb

##Installation and Build Instructions ##

##Troubleshooting Guide ##

##Report a bug ##

##Howto contribute ##

Docker Pull Command
Owner
nesslinger

Comments (0)