Welcome to Centmin Mod Community
Become a Member

MariaDB not supported by Mattermost

Discussion in 'Other Centmin Mod Installed software' started by GASTAN, Jan 2, 2026.

  1. GASTAN

    GASTAN Member

    111
    12
    18
    Jun 28, 2017
    Ratings:
    +19
    Local Time:
    10:20 AM
    Please fill in any relevant information that applies to you:
    • CentOS Version: i.e. CentOS 7 64bit

    Mattermost stopped to support MySQL and wont run on MariaDB no more.
    for migration the only offer migration from MYSQL
    is there any way to switch MariaDB to stealth mode, so that migration tool doesnt discover it's MariaDB rather than MySQL ?

     
  2. eva2000

    eva2000 Administrator Staff Member

    58,894
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    6:20 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Don't follow Mattermost's developments but interesting indeed https://support.mattermost.com/hc/en-us/articles/37264481177236-Does-Mattermost-Support-MariaDB

    MariaDB indeed has diverged but not to the extent compared to Oracle MySQL but I don't know what features Mattermost uses that works with Oracle MySQL but not MariaDB.

    Centmin Mod does have some preliminary and optional support for PostgreSQL install and PHP postgresql extensions but no management shell menus or features as that is left to end user to manage after installation. @MaximilianKohler is using Centmin Mod with PostgreSQL AFAIK https://community.centminmod.com/search/12230880/?q=postgresql&o=date&c[user][0]=4143

    Centmin Mod does also have some optional support for Percona forked Oracle MySQL 8.x as well but that isn't well integrated into menu and tools in terms of testing wise. It was only added as some of my private clients required Oracle MySQL 8.x so used Percona's forked Oracle MySQL 8.x Percona Server for MySQL. Mattermost folks recommend a separate staging Oracle MySQL 8 server for migration to PostgreSQL anyway, so you don't necessarily need Centmin Mod with Oracle/Percona MySQL 8 for the migration anyway.

    Migration guidelines from MySQL to PostgreSQL - Mattermost documentation

     
  3. eva2000

    eva2000 Administrator Staff Member

    58,894
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    6:20 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    With @MaximilianKohler and you bringing up PostgreSQL servers, thought I'd start work in EL10 development 141.00beta branch for this at least

    centmin.sh new menu option 8

    Code (Text):
    --------------------------------------------------------
         Centmin Mod Menu 141.00beta01 centminmod.com     
    --------------------------------------------------------
    1).  Centmin Install
    2).  Add Nginx vhost domain
    3).  NSD setup domain name DNS
    4).  Nginx Upgrade / Downgrade
    5).  PHP Upgrade / Downgrade
    6).  MySQL User Database Management
    7).  Persistent Config File Management
    8).  PostgreSQL Server Management
    9).  Option Being Revised (TBA)
    10). Memcached Server Re-install
    11). MariaDB MySQL Upgrade & Management
    12). Zend OpCache Install/Re-install
    13). Install/Reinstall Redis PHP Extension
    14). SELinux disable
    15). Install/Reinstall ImagicK PHP Extension
    16). Change SSHD Port Number
    17). Multi-thread compression: zstd,pigz,pbzip2,lbzip2
    18). Suhosin PHP Extension install
    19). Install FFMPEG and FFMPEG PHP Extension
    20). NSD Install/Re-Install
    21). Data Transfer
    22). Add Wordpress Nginx vhost + Cache Plugin
    23). Update Centmin Mod Code Base
    24). Exit
    --------------------------------------------------------
    Enter option [ 1 - 24 ] 24
    --------------------------------------------------------
    

    Code (Text):
    --------------------------------------------------------
             PostgreSQL Server Sub-Menu                     
    --------------------------------------------------------
    1). Install/Reinstall PostgreSQL Server
    2). PostgreSQL User/Database Management
    3). Check PostgreSQL Status
    4). Upgrade PostgreSQL Version
    5). Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 5 ] 
    

    Code (Text):
    ----------------------------------------------------------------
     PostgreSQL User Database Management Sub Menu
    ----------------------------------------------------------------
    1). Create PostgreSQL Role and Database
    2). Add Database to Existing Role
    3). Change PostgreSQL Role Password
    4). Delete PostgreSQL Role
    5). Show Grants for PostgreSQL Role
    6). List All Databases and Roles
    7). Delete PostgreSQL Database
    8). Return to Main Menu
    ----------------------------------------------------------------
    Enter option [ 1 - 8 ]: 
    

    Still work in progress