mariadb

linux安装

• 创建server.cnf

tee server.cnf <<-'EOF'
[mysqld]
port=3306
server-id=1
log-bin=mysql-bin
binlog_format=row
binlog_annotate_row_events=true
binlog_row_metadata=FULL
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
max_allowed_packet=128M
max_connections=20000
# = 0 存储使用传输过来的大小写格式，读取时依旧严格遵循
# = 1 存储使用自动转换后的小写格式，读取比较时不区分大小写。
# = 2 存储使用给定的大小写，读取比较时自动转换为小写。
lower_case_table_names = 1
default-time_zone='+8:00'
EOF

• 创建 docker-compose.yml

tee docker-compose.yml <<-'EOF'
version: '3.1'

services:
   mariadb:
     image: mariadb
     container_name: mariadb
     hostname: mariadb
     restart: always
     ports:
       - 3306:3306
     volumes:
       - ./database:/var/lib/mysql
       - ./server.cnf:/etc/mysql/mariadb.conf.d/server.cnf
     environment:
       - MYSQL_ROOT_HOST=%
       - MYSQL_ROOT_PASSWORD=root
EOF

• 安装

docker-compose up -d