MariaDB What version?

Configuration
1

I am using MariaDB with HA but have it difined like this in my docker-compose:

  mariadb:
    image: mariadb:10.8
    container_name: mariadb
    restart: unless-stopped
    command: --innodb-read-only-compressed=OFF --max_allowed_packet=1024M --innodb-buffer-pool-size=1024M

Is this accurate? Shouldn’t I use :latest ? Any recomendations?

2

The MariaDB requirements on the Recorder integration page: Recorder - Home Assistant

As for the commands I’m not sure what you need. I don’t have anything set in command and running 11.7.

As for running a tagged version v.s. latest, that’s a docker best practice.

3

This is what I have. On and older version.

The reason for picking a specific version, is so you are in control of what you are running. Without that anytime you recreate the container it will upgrade. And then if you have a problem you need to figure out if it’s the new version vs the container config change.

Every time I upgrade HA, I shutdown MariaDb, and copy the database folder to a new folder name (for example mariadb_2025_3_2). Sometimes HA version upgrades also update the database schema. And sometimes those upgrades fail. So by copying to a new folder (use cp -rp) you can always roll back. I do the same thing for the HA folder.

  mariadb:
    container_name: mariadb_ha
    image: mariadb:10.11.2
    volumes:
      - ${DOCKER_LOCAL_FOLDER}/${MARIADB_FOLDER}:/var/lib/mysql
      - ${DOCKER_LOCAL_FOLDER}/mariadb_conf:/etc/mysql/conf.d
      - /etc/localtime:/etc/localtime:ro
      
    restart: unless-stopped
    environment:
      MARIADB_ROOT_PASSWORD: ${MARIADB_PWD}
      MARIADB_MYSQL_LOCALHOST_USER: "yes"
      MARIADB_MYSQL_LOCALHOST_GRANTS: "yes"
      MARIADB_AUTO_UPGRADE: "yes"
      MARIADB_DISABLE_UPGRADE_BACKUP: "yes"
      TZ: America/New_York
      PUID: ${MARIADB_PUID}
      PGID: 100
    networks: 
      local_network:
        ipv4_address: ${SUBNET}.4