[TikiWiki-commits] [Git][tikiwiki/tiki][27.x] [ENH] Update MariaDB and MySQL version support in CI configuration

SoftStart Code pushed to branch 27.x at Tiki Wiki CMS Groupware / Tiki


Commits:
3e93db92 by Sandeep D at 2026-01-21T09:01:21+00:00
[ENH] Update MariaDB and MySQL version support in CI configuration
---
* [ENH] Rename CI job for PHP max and MariaDB LTS version support

* [ENH] Update MariaDB and MySQL version support in CI configuration

See merge request tikiwiki/tiki!9378

- - - - -


1 changed file:

- .gitlab-ci.yml


Changes:

=====================================
.gitlab-ci.yml
=====================================
@@ -19,10 +19,15 @@ variables:
   #The schemas dumped for prior tikis on https://gitlab.com/tikiwiki/tikiwiki-ci-databases have explicit COLLATION() statements for each table column.  Later versions of mysql (8.0.11+, but not sure) will not dump the same whits explicit collations.
   #Running php doc/devtools/check_schema_upgrade.php -m 22 --db1=tiki:tiki@localhost:tikiold --db2=tiki:tiki@localhost:tikinew gives other errors localy that are false positives.  But locally, unless you decompress https://gitlab.com/tikiwiki/tikiwiki-ci-databases into doc/devtool/dbdiff/cache, tiki.org won't give the schemas to you, and will blacklist your IP address!  benoitg - 2023-05-16
 
-  MARIADB_IMAGE_NEWEST_SUPPORTED: mariadb:10.11.7
+  # Database Version Testing Strategy:
+  # - OLDEST versions: Minimum compatibility baseline, ensures backward compatibility
+  # - COMMON LTS: Widely deployed versions, provides stable testing baseline
+  # - NEWEST LTS: Future-proofing, tests latest LTS features and compatibility
   MARIADB_IMAGE_OLDEST_SUPPORTED: mariadb:10.5.11
-  MYSQL_IMAGE_NEWEST_SUPPORTED: mysql:8.0.36
+  MARIADB_IMAGE_COMMON_LTS: mariadb:10.11.15
+  MARIADB_IMAGE_NEWEST_SUPPORTED: mariadb:11.8.5
   MYSQL_IMAGE_OLDEST_SUPPORTED: mysql:8.0.29
+  MYSQL_IMAGE_NEWEST_SUPPORTED: mysql:8.4.7
   MANTICORE_NEWEST_SUPPORTED: 15.1.0
   #Only for older version upgrade tests these days
   MYSQL_5_IMAGE: mysql:5.7.44
@@ -404,7 +409,7 @@ composer-could-update-lock:
   <<: *template-tiki-schema-upgrade
   services:
     - name: ${DEPENDENCY_PROXY_PREFIX}$IMAGE
-      command: [ "--default-authentication-plugin=mysql_native_password", "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci"]
+      command: ["--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci"]
       alias: mysql
 
 db-upgrade-22-mariadb:
@@ -536,7 +541,7 @@ console-php-works:
   <<: *template-unit-tests
   services:
     - name: ${DEPENDENCY_PROXY_PREFIX}${MYSQL_IMAGE_OLDEST_SUPPORTED}
-      command: [ "--default-authentication-plugin=mysql_native_password", "--explicit-defaults-for-timestamp=off" ]
+      command: ["--explicit-defaults-for-timestamp=off"]
       alias: mysql
     - name: ${DEPENDENCY_PROXY_PREFIX}elasticsearch:5
       alias: elasticsearch
@@ -547,7 +552,7 @@ console-php-works:
   <<: *template-unit-tests
   services:
     - name: ${DEPENDENCY_PROXY_PREFIX}${MYSQL_IMAGE_NEWEST_SUPPORTED}
-      command: [ "--default-authentication-plugin=mysql_native_password", "--explicit-defaults-for-timestamp=off" ]
+      command: ["--explicit-defaults-for-timestamp=off"]
       alias: mysql
     - name: ${DEPENDENCY_PROXY_PREFIX}elasticsearch:5
       alias: elasticsearch
@@ -558,7 +563,17 @@ console-php-works:
   <<: *template-unit-tests
   services:
     - name: ${DEPENDENCY_PROXY_PREFIX}${MARIADB_IMAGE_OLDEST_SUPPORTED}
-      #command: [ "--default-authentication-plugin=mysql_native_password", "--explicit-defaults-for-timestamp=off" ]
+      #command: ["--explicit-defaults-for-timestamp=off"]
+      alias: mysql
+    - name: ${DEPENDENCY_PROXY_PREFIX}elasticsearch:5
+      alias: elasticsearch
+    - name: ${DEPENDENCY_PROXY_PREFIX}manticoresearch/manticore:${MANTICORE_NEWEST_SUPPORTED}
+      alias: manticore
+
+.template-unit-tests-mariadb-lts-supported: &template-unit-tests-mariadb-lts-supported
+  <<: *template-unit-tests
+  services:
+    - name: ${DEPENDENCY_PROXY_PREFIX}${MARIADB_IMAGE_COMMON_LTS}
       alias: mysql
     - name: ${DEPENDENCY_PROXY_PREFIX}elasticsearch:5
       alias: elasticsearch
@@ -569,7 +584,7 @@ console-php-works:
   <<: *template-unit-tests
   services:
     - name: ${DEPENDENCY_PROXY_PREFIX}${MARIADB_IMAGE_NEWEST_SUPPORTED}
-      #command: [ "--default-authentication-plugin=mysql_native_password", "--explicit-defaults-for-timestamp=off" ]
+      #command: ["--explicit-defaults-for-timestamp=off"]
       alias: mysql
     - name: ${DEPENDENCY_PROXY_PREFIX}elasticsearch:5
       alias: elasticsearch
@@ -596,8 +611,8 @@ unit-tests-phpmin-mariadbmin:
     IMAGE: tikiwiki/tikiwiki-ci:8.1-qa
   allow_failure: false
 
-unit-tests-phpmax-mariadbmax:
-  <<: *template-unit-tests-mariadb-newest-supported
+unit-tests-phpmax-mariadblts:
+  <<: *template-unit-tests-mariadb-lts-supported
   variables:
     IMAGE: tikiwiki/tikiwiki-ci:8.3-qa
   allow_failure: false



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/3e93db9220e8188411e953aa0e86d8788c6b8fb3

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/3e93db9220e8188411e953aa0e86d8788c6b8fb3
You're receiving this email because of your account on gitlab.com.

_______________________________________________
TikiWiki-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs