Docker MariaDB

Docker MariaDB

Ubuntu:

/home/test/mysql/config/my.cnf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
server-id = 1
log_bin = /var/lib/mysql/mysql-bin.log
max_binlog_size = 1000M
binlog-format = row



docker run \
    --name mariadbtest \
    -d \
    -p 3306:3306 \
    --privileged=true \
    -v /home/test/mysql/config/my.cnf:/etc/mysql/my.cnf \
    -v /home/test/mysql/data:/var/lib/mysql \
    -e MYSQL_ROOT_PASSWORD="mypass" \
    -d mariadb/server:10.3

Windows:

D:\Documents\mysql\config\my.cnf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
server-id = 1
log_bin = /var/lib/mysql/mysql-bin.log
max_binlog_size = 1000M
binlog-format = row


docker run \
  --name mariadbtest \
  -d \
  -p 3306:3306 \
  --privileged=true \
  -v D:\Documents\mysql\config\my.cnf:/etc/mysql/my.cnf \
  -v D:\Documents\mysql\data:/var/lib/mysql \
  -e MYSQL_ROOT_PASSWORD="mypass" \
  -d mariadb/server:10.3

MySQL误操作后如何快速回滚
https://www.jianshu.com/p/4b71eb2de1ba

other:

docker run --name mariadbtest -e MYSQL_ROOT_PASSWORD=mypass -d mariadb/server:10.3 --log-bin --binlog-format=MIXED
docker run --name mariadbtest -e MYSQL_ROOT_PASSWORD=mypass -d mariadb/server:10.3
docker run -d -p 3306:3306 -e MYSQL_USER="woniu" -e MYSQL_PASSWORD="123456" -e MYSQL_ROOT_PASSWORD="123456" --name mysqltest1 mysql:5.7 --character-set-server=utf8 --collation-server=utf8_general_ci
docker run -d -p 3306:3306 --privileged=true -v /docker/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /docker/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 --name mysqltest2 mysql:5.7

--link
docker run --name other-app --link first-mysql:mysql -d other-application-use-mysql