mariadb-11.8-lts容器化部署测试

Posted on Views:

MariaDB 11.8 LTS 的 docker-compose.yml 示例，适合开发、测试。

docker-compose.yml

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
services:
  mariadb-vector:
    image: mariadb:11.8
    container_name: mariadb-11.8-vector
    restart: unless-stopped
    environment:
      MARIADB_ROOT_PASSWORD: 321.321
      MARIADB_DATABASE: mvpbang
      MARIADB_USER: admin
      MARIADB_PASSWORD: 321.321
    ports:
      - "13306:3306"
    volumes:
      - ./data:/var/lib/mysql
      - ./my.cnf:/etc/mysql/my.cnf:ro
      - /etc/localtime:/etc/localtime:ro
    healthcheck:
      test: >
         bash -c 'mariadb-admin ping --silent -u $$MARIADB_USER -p$$MARIADB_PASSWORD' 
      interval: 10s
      retries: 3
      timeout: 5s

1.my.cnf

如需启用 Vector Search、系统时态表 或其他 MariaDB 11.8 特性

1
2
3
4
5
6
7
8
9
10
11
12
# my.cnf
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_520_ci
innodb_buffer_pool_size=512M
innodb_file_per_table=1
log_bin=mysql-bin
binlog_format=row
default_authentication_plugin=mysql_native_password

# 启用向量索引特性（若有需要）
plugin_load_add=ha_vector

2.启动命令

1
docker-compose up -d

可通过如下方式进入 MariaDB 容器：

1
docker exec -it mariadb-11.8 mariadb -umyuser -pmyuserpassword mydb

3.验证版本

1
SELECT VERSION();