Multiple RDBMS Version Test Setup Ideas

[rotexdegba]

Mysql Containers

podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:5.6.51
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:5.7.44
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:8.0.36
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mysql:8.3.0

Mariadb Containers

podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.4.32
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.5.23
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.6.16
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:10.11.6
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.0.4
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.1.3
podman run -dt -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password_goes_here docker.io/library/mariadb:11.2.2

Postgres Containers

podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:12.17
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:13.13
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:14.10
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:15.5
podman run -dt -p 5432:5432 -e POSTGRES_HOST_AUTH_METHOD=trust docker.io/library/postgres:16.1

MariaDB

• https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/

• https://endoflife.date/mariadb

• https://hub.docker.com/_/mariadb/tags?page=1

• Maria 10.4.32+ (Ends June 2024) LTS

  • docker pull mariadb:10.4.32
  • https://hub.docker.com/layers/library/mariadb/10.4.32/images/sha256-706bd6ffbb57ef141d578774df2415386fd859178b5294c73c2740c86f66a742?context=explore

• Maria 10.5.23+ (Ends June 2025) LTS

  • docker pull mariadb:10.5.23
  • https://hub.docker.com/layers/library/mariadb/10.5.23/images/sha256-44b025abf54f798e7a9ac95d543b1f1d3dc80af1769237f6d5f72d807bdb61aa?context=explore

• Maria 10.6.16+ (Ends June 2026) LTS

  • docker pull mariadb:10.6.16
  • https://hub.docker.com/layers/library/mariadb/10.6.16/images/sha256-00d41c8b5d61c1c1904896fcf98029c5d5f7deaf21d4adb03e0d00d955fc1bca?context=explore

• Maria 10.11.6+ (Ends Feb 2028) LTS

  • docker pull mariadb:10.11.6
  • https://hub.docker.com/layers/library/mariadb/10.11.6/images/sha256-0a2c136bd7f771adcefe93b8cc828dcb9a451d93b305492fcc463f882f96b97f?context=explore

• Maria 11.0.4+ (Ends Jun 2024)

  • docker pull mariadb:11.0.4
  • https://hub.docker.com/layers/library/mariadb/11.0.4/images/sha256-79dafddcfb7f8d85a1ffdf16ce761e81caaf963459060e34a1b12595eb6a9a0b?context=explore

• Maria 11.1.3+ (Ends Aug 2024)

  • docker pull mariadb:11.1.3
  • https://hub.docker.com/layers/library/mariadb/11.1.3/images/sha256-287c6de2af0b08fbdf0f2ef7084e30c2ceb942593e0b948b6a0b05ab7c47023e?context=explore

• Maria 11.2.2+ (Ends Nov 2024)

  • docker pull mariadb:11.2.2
  • https://hub.docker.com/layers/library/mariadb/11.2.2/images/sha256-ac933f87a5fc8b743a3c522179116ee63aec31105795dc28dea8b80bb74cdd36?context=explore

Mysql

• https://dev.mysql.com/blog-archive/introducing-mysql-innovation-and-long-term-support-lts-versions/

• https://en.wikipedia.org/wiki/MySQL#Release_history

• https://github.com/cycle/orm/blob/2.x/.github/workflows/ci-mysql.yml

• https://hub.docker.com/_/mysql/tags?page=1

• Mysql 5.6.51 (Ended Feb 2021) LTS

  • docker pull mysql:5.6.51
  • https://hub.docker.com/layers/library/mysql/5.6.51/images/sha256-897086d07d1efa876224b147397ea8d3147e61dd84dce963aace1d5e9dc2802d?context=explore

• Mysql 5.7.44 (Ended Oct 2023) LTS

  • docker pull mysql:5.7.44
  • https://hub.docker.com/layers/library/mysql/5.7.44/images/sha256-dab0a802b44617303694fb17d166501de279c3031ddeb28c56ecf7fcab5ef0da?context=explore

• Mysql 8.0 (Ubuntu & Rocky Linux Latests) LTS

  • docker pull mysql:8.0.36
  • https://hub.docker.com/layers/library/mysql/8.0.36/images/sha256-094a1638b290a1c5d5faa3f06ac2e3ed975947594db4a60aadc58a92e3d0820b?context=explore

• Mysql 8.2+ (Ended, Extended & Premier Support) NON-LTS

• Mysql 8.3+ (Ended, Extended & Premier Support) NON-LTS

  • docker pull mysql:8.3.0
  • https://hub.docker.com/layers/library/mysql/8.3.0/images/sha256-6d5a11994be8ca5e4cfaf4d370219f6eb6ef8fb41d57f9ed1568a93ffd5471ef?context=explore

• Mysql 8.4+ (Ends Apr 2024) NON-LTS

Postgresql

• https://www.postgresql.org/support/versioning/

• https://endoflife.date/postgresql

• https://github.com/cycle/orm/blob/2.x/.github/workflows/ci-pgsql.yml

• https://hub.docker.com/_/postgres/tags

• Postgres 12.17+ (Ends Nov 2024)

  • docker pull postgres:12.17
  • https://hub.docker.com/layers/library/postgres/12.17/images/sha256-289b0a52099be5640afa26c3a38647141b2b36bc6b28d245ba727de7b7f77210?context=explore

• Postgres 13.13+ (Ends Nov 2025)

  • docker pull postgres:13.13
  • https://hub.docker.com/layers/library/postgres/13.13/images/sha256-8a547348d67cd3f0dc6e6e7c0dada4160b119bd2759a144532b279a7112b3fa4?context=explore

• Postgres 14.10+ (Ends Sep 2026)

  • docker pull postgres:14.10
  • https://hub.docker.com/layers/library/postgres/14.10/images/sha256-336b0536e103d5520f499f5ff53abf2a8bee7094aa75efb7ef68fb704b100771?context=explore

• Postgres 15.5+ (Ends Nov 2027)

  • docker pull postgres:15.5
  • https://hub.docker.com/layers/library/postgres/15.5/images/sha256-c85d974e97b6387c99edaed1873911155d94e990f81df869efcde6118da2dbb3?context=explore

• Postgres 16.1+ (Ends Nov 2028)

  • docker pull postgres:16.1
  • https://hub.docker.com/layers/library/postgres/16.1/images/sha256-021d7d217750a1b97b2232c1be9331eaa3f7d90a8a1bb2e9c25cd04a28e8306c?context=explore

MsSqlSrvr

• https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&pivots=cs1-bash
• https://github.com/microsoft/mssql-docker