restsql/mysql-sakila
MySQL 5.7 with sakila database plus extensions for restsql-test
5.0K
Dockerfile
linksrestSQL is an open-source, ultra-lightweight data access layer for HTTP clients. restSQL is a persistence framework or engine in the middle tier of a classic three tier architecture: client, application server and database. It may also be embedded in any middle-tier as a Java library.
See restsql.org for more on concepts, architecture, API details, deployment instructions and project information.
This image provides a ready to use database for the restsql/service-sdk docker container. It contains MySQL 5.7.17 on ubuntu, the sakila database and extensions required for the restsql test harness, restsql-test.
$ docker run -d --name mysqld restsql/mysql-sakila
This creates a container with the following characteristics:
You can check proper health via:
$ docker run -it --link mysqld:mysql --rm mysql sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -psakila -e "show tables;" sakila'
(The password to the root
account, is sakila
, the same name as the schema/database to which you will connect.)
This downloads the mysql official library image, creates a temporary container, runs the mysql client, and lists all tables in the sakila schema. Drop the -e "show tables;"
to open an interactive mysql console.
If you want to open it up for exploration with other non-containerized tools, publish the port 3306, as in:
$ docker run -d --publish 3306:3306 --name mysqld restsql/mysql-sakila
This image was tested on Docker version 18.06.
Please see the Docker installation documentation for details on how to upgrade your Docker daemon.
If you have any problems with or questions about this image or restSQL, please contact us through a GitHub issue or see the Support Overview.
restSQL is licensed under the standard MIT license. The sakila database is licensed under the standard BSD license.
You are invited to contribute new features, fixes or updates, large or small, via github pull requests. See restsql.org/Roadmap for more information.
docker pull restsql/mysql-sakila