redhound/docker-mariadb-mssql repository overview

⁠MariaDB 10.0 Docker Image with CONNECT to MS SQL (Centos7)

This is a fork of Million12's MariaDB 10.0 Docker million12/mariadb⁠ image, adding CONNECT engine with correctly configured FreeTDS MS SQL driver. Built on top of official centos:centos7⁠ image. Inspired by Tutum⁠'s tutum/mariadb⁠ image.

Note: be aware that, by default in this container, MariaDB is configured to use 1GB memory (innodb_buffer_pool_size in tuning.cnf⁠). If you try to run it on node with less memory, it will fail.

⁠Basic Usage

docker pull redhound/docker-mariadb-mssql

Or, if you prefer to build it on your own:
docker build -t redhound/docker-mariadb-mssql .

Run the image as daemon and bind it to port 3306:
docker run -d -p 3306:3306 redhound/docker-mariadb-mssql

The first time that you run your container, a new user admin with all privileges will be created in MariaDB with a random password. To get the password, check the logs of the container by running:
docker logs <CONTAINER_ID>

You will see an output like the following:

	========================================================================
    You can now connect to this MariaDB Server using:

        mysql -uadmin -pCoFlnc3ZBS58 -h<host>

    Please remember to change the above password as soon as possible!       
    MariaDB user 'root' has no password but only allows local connections
    ========================================================================

In this case, CoFlnc3ZBS58 is the password assigned to the admin user.

⁠Custom Password for user admin

If you want to use a preset password instead of a random generated one, you can set the environment variable MARIADB_PASS to your specific password when running the container:

docker run -d -p 3306:3306 -e MARIADB_PASS="mypass" redhound/docker-mariadb-mssql

⁠Mounting the database file volume from other containers

One way to persist the database data is to store database files in another container. To do so, first create a container that holds database files:

docker run -d -v /var/lib/mysql --name db-data busybox:latest

This will create a new container and use its folder /var/lib/mysql to store MariaDB database files. You can specify any name of the container by using --name option, which will be used in next step.

After this you can start your MariaDB image using volumes in the container created above (put the name of container in --volumes-from).

docker run -d --volumes-from db-data -p 3306:3306 redhound/docker-mariadb-mssql

⁠Using CONNECT Engine with SQL Server

In this example, we are connecting to an AWS SQL Server instance, which was created and populated as follows:

CREATE TABLE [dbo].[RED_HOUND_SERVICES]  
 ( ID			int IDENTITY(1,1) PRIMARY KEY  
  ,NAME	        varchar(255) null  
  ,DESCRIPTION	varchar(255) null  
 )  
   
INSERT RED_HOUND_SERVICES VALUES ('MAPPING', 'Message Mapping for OTC Derivatives')  
INSERT RED_HOUND_SERVICES VALUES ('PACKER', 'Automation of Microsoft Server builds')  
INSERT RED_HOUND_SERVICES VALUES ('DOCKER', 'Docker builds of MariaDB and Tomcat')    

We then connect to MariaDB and set up a new CONNECT table:

--Use the default database
USE mysql;  
  
--Useful snippet for testing
--DROP TABLE IF EXISTS MS_TEST_CONNECT; 
  
--Table names and column names are not case sensitive  
--Use your own values for server IP, database name, username and mypwd.  
CREATE TABLE MS_TEST_CONNECT (  
  ID INT(10) NOT NULL,   
  NAME VARCHAR(255),   
  DESCRIPTION VARCHAR(255)) ENGINE=CONNECT TABLE_TYPE=ODBC DEFAULT CHARSET=latin1 tabname='RED_HOUND_SERVICES'  
  CONNECTION='Driver={FreeTDS};Server=10.10.10.10;Port=1433;Database=DBNAME;UID=username;PWD=mypwd;'  

This table can then be queried like a regular MariaDB table:

SELECT * FROM MS_TEST_CONNECT;

ID  NAME     DESCRIPTION  
1	MAPPING	 Message Mapping for OTC Derivatives
2	PACKER	 Automation of Microsoft Server builds
3	DOCKER	 Docker builds of MariaDB and Tomcat  

⁠Authors

Author: Marcin Ryzycki ([email protected]⁠)
Author: Przemyslaw Ozgo ([email protected]⁠)
Forked by: Ben Dalby ([email protected]⁠)

Sponsored by Typostrap.io - the new prototyping tool⁠ for building highly-interactive prototypes of your website or web app. Built on top of TYPO3 Neos CMS and Zurb Foundation framework.
CONNECT fork by redhound.net - map and test high volume message flows⁠