percona mysql for nicescale
docker build -t nicescale/percona-mysql .
. path.ini
docker run -d -v $HOME/data:$data -v $HOME/log:$log nicescale/percona-mysql
. path.ini
docker run --rm -v $HOME/data:$data -e DBNAME=dbtest -e DBUSER=dbtest_user -e DBPASS=123qwe nicescale/percona-mysql /opt/nicedocker/create_db.sh
If you need to automate your work, you can create database like this:
docker run --rm -v $HOME/data:$data -e DBNAME=dbtest -e DBUSER=dbtest_user -e DBPASS=123qwe nicescale/percona-mysql /opt/nicedocker/wait.sh /opt/nicedocker/create_db.sh
Script wait.sh will execute create_db.sh until mysqld be ready.
. path
docker run --rm -it -v $HOME/data:$data nicescale/percona-mysql mysql
. path
docker run --rm -v $HOME/data:$data nicescale/percona-mysql mysql -e "select count(*) from dbtest.testtable"
. path
docker run --rm -v $HOME/data:$data -v $HOME/backup:/backup nicescale/percona-mysql sh -c "mysqldump dbtest > /backup/dbtest"
. path
docker run --rm -v $HOME/data:$data nicescale/percona-mysql mysqladmin --no-defaults shutdown