Welcome to Centmin Mod Community
Register Now

MariaDB MariaDB 10.0 to 10.11 to 11.4 MySQL Variables Change History

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Jul 12, 2024.

Thread Status:
Not open for further replies.
  1. eva2000

    eva2000 Administrator Staff Member

    54,564
    12,224
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,793
    Local Time:
    9:10 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Upgrading MariaDB MySQL major versions isn't as simple as just upgrading in place, as major versions may deprecate or remove variables or rename existing variables, which may result in MariaDB MySQL servers not starting up or restarting properly.

    Centmin Mod centmin.sh menu option 11 submenu to upgrade MariaDB MySQL major versions, will automatically take care of deprecated or removed variable changes for each major version you upgrade to. To be able to do this, I will research and read all MariaDB documentation and JIRA bug tracker issues for all major versions to understand how removed/deprecated or newly added variables change MariaDB server's functionality. Then after that research, I will code the upgrade routines to automatically remove and/or change variables for specific major version upgrades.

    If you use and/or appreciate the work that goes into Centmin Mod development, please considering supporting Centmin Mod ;)

    centmin.sh menu
    Code (Text):
    --------------------------------------------------------
         Centmin Mod Menu 140.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).  Option Being Revised (TBA)
    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 ] 11
    --------------------------------------------------------
    


    centmin.sh menu option 11 submenu in 140.00beta01 added MariaDB 10.11 and 11.4 LTS private testing for now. While 131.00stable supports up to MariaDB 10.6 LTS.
    Code (Text):
    --------------------------------------------------------
         MariaDB MySQL Upgrade & Management Sub-Menu      
    --------------------------------------------------------
    0). Regenerate New MySQL Root User Password (local server)
    1). MariaDB 5.2.x Branch Upgrade Only
    2). MariaDB 5.2.x to MariaDB 5.5 YUM upgrade
    3). MariaDB 5.5 to MariaDB 10.x YUM upgrade
    4). MariaDB 5.5 to MariaDB 10.1.x YUM upgrade
    5). MariaDB 10.x to MariaDB 10.1.x YUM upgrade
    6). MariaDB 10.1.x to MariaDB 10.2.x YUM upgrade
    7). MariaDB 10.2.x to MariaDB 10.3.x YUM upgrade
    8). MariaDB 10.3.x to MariaDB 10.4.x YUM upgrade
    9). MariaDB 10.4.x to MariaDB 10.5.x YUM upgrade
    10). MariaDB 10.5.x to MariaDB 10.6.x LTS YUM upgrade
    11). MariaDB 10.6.x to MariaDB 10.11.x YUM upgrade
    12). MariaDB 10.6.x to MariaDB 11.4.x LTS YUM upgrade
    13). MariaDB 10.11.x to MariaDB 11.4.x LTS YUM upgrade
    14). Back to Main menu
    --------------------------------------------------------
    Enter option [ 0 - 14 ]
    



    MariaDB 11.4 LTS


    Variable Added
    Removed Variables

    MariaDB 11.3


    Variable Added
    Removed Variables

    MariaDB 11.2


    Variable Added

    MariaDB 11.1


    Variable Added

    MariaDB 11.0


    Variable Added
    Removed Variables
    Deprecated Variables

    MariaDB 10.11 LTS


    Variable Added
    Renamed, Deprecated Variables
    InnoDB Variables
    Spider Variables
    The following deprecated variables have been removed (MariaDB 10.10):

    MariaDB 10.10


    Variable Added
    Removed/Deprecated Variables

    InnoDB
    Spider
    The following deprecated variables have been removed:

    MariaDB 10.9


    Variable Added
    Deprecated And Merged Variables
    The following variables have been deprecated:

    MariaDB 10.8


    Variable Added

    MariaDB 10.7


    Deprecated Variables

    MariaDB 10.6 LTS


    Variable Added
    Changed & Deprecated Variables
    InnoDB Variables
    The following deprecated variables have been removed (MDEV-23397):

    MariaDB 10.5


    Variable Added
    Changed And Deprecated Variables

    InnoDB New Defaults for Variables
    InnoDB Removed or Deprecated Variables

    MariaDB 10.4


    Variable Added

    MariaDB 10.3


    Variable Added

    MariaDB 10.2



    Variable Added

    MariaDB 10.1



    Variable Added

    MariaDB 10.0




    Variable Added
     
    Last edited: Jul 12, 2024
Thread Status:
Not open for further replies.