MariaDB MariaDB 10.1 upgrades to MariaDB 10.2, 10.3, 10.4, 10.5, 10.6

eva2000 · Jun 21, 2019

Centmin Mod 123.09beta01 supports MariaDB 10.1 defaults early on its development cycle and eventually switched to default to MariaDB 10.3 by default. But Centmin Mod 123.09beta01 supports MariaDB 10.1, 10.2, 10.3, 10.4, 10.5 and 10.6 upgrades. Right now MariaDB 10.2, 10.3, 10.4, 10.5, 10.6 upgrade submenus are publicly disabled and only can be enabled for the private testing stage. MariaDB 10.5 & 10.6 are will also eventually be added for private testing. The recommended method of upgrading is not to skip major versions, so if you're on MariaDB 10.1, you need to upgrade to MariaDB 10.2, then to MariaDB 10.3 and then to MariaDB 10.4, then MariaDB 10.5, then MariaDB 10.6 until you reach your intended upgraded version.

Notes

MariaDB 10.4, 10.5 and 10.6 are no longer drop-in compatible with Oracle MySQL and even downgrading to MariaDB 10.3. So treat their upgrade paths as one way. Meaning MariaDB doesn't support easy downgrade between major versions i.e. MariaDB 10.4/10.5/10.6 downgrade to 10.3 or switching between MariaDB 10.4+ to Oracle MySQL 5.7 or MySQL 8.0. So be 100% sure you want to upgrade. Especially, if you upgrade to MariaDB 10.4+, you may not be able to downgrade and/or switch between Oracle/Percona MySQL and MariaDB so need to rely on restoring the database backups you made prior to the MariaDB upgrade.

Unless you know what you're doing for MariaDB MySQL upgrades and know how to backup and restore your databases via SSH command line via mysqldump/mysql client commands etc, I'd recommend either staying on the MariaDB MySQL major version you're on 10.1, 10.2, 10.3 etc or hiring someone to do the upgrades for you. Centmin Mod is provided as is, so if you have database issues related to upgrades, you'd be on your own as I will no provide free support for such. You can hire me for paid $$$ support for such. Contact me for such requests.

MariaDB 10.4+ moves further away from being a 100% drop-in compatible MySQL (Oracle) server so features or changes in MariaDB 10.4+ may not allow an easy downgrade to other MySQL server versions or forks or make importing non-MariaDB MySQL data from Oracle or Percona MySQL into MariaDB 10.4+ go smoothly. Details at MariaDB - Interesting look at what's new in MariaDB 10.4.

MariaDB 10.4+ changes the user and password management so may break backwards compatibility with your web/php apps in theory.

MariaDB 10.5 support has been added and follow the same method of optional upgrade support as outlined below. MariaDB - What's New In MariaDB 10.5?

MariaDB 10.6 support has been added and follow the same method of optional upgrade support as outlined below. MariaDB - What's New In MariaDB 10.6?

Centmin Mod 123.09beta01 MariaDB Upgrade Submenu

To enable fully all upgrade paths for MariaDB 10.1 to 10.2 to 10.3 to 10.4 to 10.5 to 10.6, you need to enable some variables. First set in persistent config file /etc/centminmod/custom_config.inc the following variables to allow centmin.sh menu option 11 to do MairaDB 10.1 to 10.2 upgrade, 10.2 to 10.3 upgrade and 10.3 to 10.4 upgrades.
Code (Text):
ENABLE_MARIADBTENTWOUPGRADE='y'
ENABLE_MARIADBTENTHREEUPGRADE='y'
ENABLE_MARIADBTENFOURUPGRADE='y'
For Centmin Mod 130.00beta01 and higher and upgrades for MariaDB 10.5 & 10.6
Code (Text):
ENABLE_MARIADBTENFIVEUPGRADE='y'
ENABLE_MARIADBTENSIXUPGRADE='y'
centmin.sh menu option 11
Code (Text):
--------------------------------------------------------
     Centmin Mod Menu 123.09beta01 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).  XCache Re-install
7).  APC Cache Re-install
8).  XCache Install
9).  APC Cache Install
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). Update - Nginx + PHP-FPM + Siege
22). Add Wordpress Nginx vhost + Cache Plugin
23). Update Centmin Mod Code Base
24). Exit
--------------------------------------------------------
Enter option [ 1 - 24 ] 11
--------------------------------------------------------
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). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 9 ]
Without the persistent config variables enabling the additional MariaDB 10.1 to 10.2 to 10.3 to 10.4 upgrade submenus, you will get place holder messages like below.
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). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 9 ] 6
--------------------------------------------------------
Place holder for now until MariaDB 10.2.x is ready to be added
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). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 9 ] 7
--------------------------------------------------------
Need to be on MariaDB 10.2 before updating to MariaDB 10.3
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). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 9 ] 8
--------------------------------------------------------
Need to be on MariaDB 10.3 before updating to MariaDB 10.4
Upgrade MariaDB 10.1 To 10.2 & 10.2 To 10.3 To 10.4 Differences

MariaDB 10.1 to 10.2 has changes you need to be aware of which may affect your script/mysql using app specifically and Centmin Mod may not have tested for it so read Upgrading from MariaDB 10.1 to MariaDB 10.2 (centmin.sh menu option 11 takes care of step 1 to 8 with exception of step 4, you need to do MySQL backups yourself) and inspect /etc/my.cnf before and after MariaDB 10.2 upgrades. Centmin Mod upgrade routines try to as best adjust /etc/my.cnf for MariaDB 10.2 compatibility with previous MariaDB 10.1 but if your web app/scripts have issues, you'll need to figure those out yourself.

Same goes for MariaDB 10.2 to 10.3 upgrades Upgrading from MariaDB 10.2 to MariaDB 10.3 (centmin.sh menu option 11 takes care of step 1 to 8 with exception of step 4, you need to do MySQL backups yourself)

As is MariaDB 10.3 to 10.4 upgrades Upgrading from MariaDB 10.3 to MariaDB 10.4. And new features in MariaDB 10.4 Changes and Improvements in MariaDB 10.4

One of the big changes is from MariaDB 10.2.2 and newer, innodb_strict_mode is enabled by default while previously it was disabled by default and default options for sql_mode have changed.

XtraDB/InnoDB Strict Mode

MySQL :: MySQL 5.6 Reference Manual :: 14.14 InnoDB Startup Options and System Variables

When innodb_strict_mode is enabled, InnoDB returns errors rather than warnings for certain conditions.

Strict mode helps guard against ignored typos and syntax errors in SQL, or other unintended consequences of various combinations of operational modes and SQL statements. When innodb_strict_mode is enabled, InnoDB raises error conditions in certain cases, rather than issuing a warning and processing the specified statement (perhaps with unintended behavior). This is analogous to sql_mode in MySQL, which controls what SQL syntax MySQL accepts, and determines whether it silently ignores errors, or validates input syntax and data values.

The innodb_strict_mode setting affects the handling of syntax errors for CREATE TABLE, ALTER TABLE and CREATE INDEX statements.innodb_strict_mode also enables a record size check, so that an INSERT or UPDATE never fails due to the record being too large for the selected page size.

Oracle recommends enabling innodb_strict_mode when using ROW_FORMAT and KEY_BLOCK_SIZE clauses in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements. When innodb_strict_mode is disabled, InnoDB ignores conflicting clauses and creates the table or index with only a warning in the message log. The resulting table might have different characteristics than intended, such as lack of compression support when attempting to create a compressed table. When innodb_strict_mode is enabled, such problems generate an immediate error and the table or index is not created.

You can enable or disable innodb_strict_mode on the command line when starting mysqld, or in a MySQL configuration file. You can also enable or disable innodb_strict_mode at runtime with the statement SET [GLOBAL|SESSION] innodb_strict_mode=mode, where mode is either ON or OFF. Changing the GLOBAL setting requires privileges sufficient to set global system variables (see Section 5.1.8.1, “System Variable Privileges”) and affects the operation of all clients that subsequently connect. Any client can change the SESSION setting for innodb_strict_mode, and the setting affects only that client.
Click to expand...

eva2000 · Jun 21, 2019

Centmin Mod 123.09beta01 MariaDB 10.1 to MariaDB 10.2 Upgrade

First check what version of MariaDB MySQL you're on via SSH command

Code (Text):

mysqladmin ver

Second, ensure variables are set in persistent config file /etc/centminmod/custom_config.inc

Code (Text):

ENABLE_MARIADBTENTWOUPGRADE='y'
ENABLE_MARIADBTENTHREEUPGRADE='y'
ENABLE_MARIADBTENFOURUPGRADE='y'

Third, run cmupdate command to ensure all local Centmin Mod 123.09beta01 code is up to date

Code (Text):

cmupdate

Fourth, ensure you have done mysqldump backup of all your MySQL databases on your server ensuring you have enough free disk space to do and store the *.sql file backups. This will save a backup of all your databases into one file at /home/mysql-all-databases-backup-$(date +"%d%m%y-%H%M%S").sql which is date timestamped and save a copy of your /etc/my.cnf settings file at /etc/my.cnf-backedup-$(date +"%d%m%y-%H%M%S").cnf

Code (Text):

cp -a /etc/my.cnf /etc/my.cnf-backedup-$(date +"%d%m%y-%H%M%S").cnf
mysqldump -Q -K --max_allowed_packet=256M --net_buffer_length=65536 --routines --events --triggers --hex-blob --all-databases > /home/mysql-all-databases-backup-$(date +"%d%m%y-%H%M%S").sql

Verify the backed up files using ls list command

Code (Text):

ls -lahrt /etc | grep backedup
ls -lahrt /home | grep all-databases-backup

Code (Text):

ls -lahrt /etc | grep backedup
-rw-r--r--.  1 root root 6.4K Jun 21 00:24 my.cnf-backedup-210619-003341.cnf

and

Code (Text):

ls -lahrt /home | grep all-databases-backup
-rw-r--r--.  1 root  root  471K Jun 21 00:35 mysql-all-databases-backup-210619-003503.sql

Then restrict the backed up file permissions so they're not world readable

Code (Text):

cd /home
chmod 0640 /home/mysql-all-databases-backup*

Code (Text):

ls -lahrt /home | grep all-databases-backup     
-rw-r-----.  1 root  root         471K Jun 21 00:35 mysql-all-databases-backup-210619-003503.sql

Fifth, run centmin.sh menu option 11, submenu option 6 for MariaDB 10.1 to 10.2 upgrade which will ask if you done mysqldump backups before proceeding to upgrade stage. You'll have to do a backup for each major upgrade from MariaDB 10.1 to 10.2 to 10.3 to 10.4 (if you choose 10.4 - I'd stick with 10.3 for now).

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). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 9 ] 6
--------------------------------------------------------

Code (Text):

-------------------------------------------------------------------------------
 This script's MariaDB 10.2.x upgrade process is still in beta testing stages.
 So please test on a test server and not a live production server. But if you use
 on live server or if MySQL databases already exist, please back them up before
 running this upgrade script via mysqldump - instructions at:
 http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.

 ###################################################################
 ###          IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE          ###
 ###        OR RISK DATA LOSS DUE TO MARIADB 10.2 Changes        ###
 ###################################################################

 For each DATABASENAME backup via mysqldump i.e.

  mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
------------------------------------------------------------------------

Have you backed up your databases ? [y/n] y

Code (Text):

MariaDB 10.2.x https://mariadb.com/kb/en/mariadb/what-is-mariadb-102/

!!  Note  !!
upgrade process can take more >5 minutes.. you may want to shutdown
nginx server to not show mysql errors to visitors on your site or
put site(s) into maintenance mode before proceeding with mysql upgrade

Do you want to continue with upgrade to MariaDB 10.2.x ? [y/n] y

Code (Text):

checking mysql root password works in /root/.my.cnf
mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.1.40-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.1.40-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 day 6 hours 21 min 17 sec

Threads: 1  Questions: 4  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.000
             ____                                  _            
            |  _ \  _ __  ___  _ __    __ _  _ __ (_) _ __    __ _
            | |_) || '__|/ _ \| '_ \  / _` || '__|| || '_ \  / _` |
            |  __/ | |  |  __/| |_) || (_| || |   | || | | || (_| |
            |_|    |_|   \___|| .__/  \__,_||_|   |_||_| |_| \__, |
                              |_|                            |___/
    ____   _             _       _                          _____        
   / ___| | |__   _   _ | |_  __| |  ___ __      __ _ __   |  ___|___   _ __
   \___ \ | '_ \ | | | || __|/ _` | / _ \\ \ /\ / /| '_ \  | |_  / _ \ | '__|
    ___) || | | || |_| || |_| (_| || (_) |\ V  V / | | | | |  _|| (_) || |
   |____/ |_| |_| \__,_| \__|\__,_| \___/  \_/\_/  |_| |_| |_|   \___/ |_|
                                                                          
                  _   _                                _    
                 | | | | _ __    __ _  _ __  __ _   __| |  ___
                 | | | || '_ \  / _` || '__|/ _` | / _` | / _ \
                 | |_| || |_) || (_| || |  | (_| || (_| ||  __/
                  \___/ | .__/  \__, ||_|   \__,_| \__,_| \___|
                        |_|     |___/                      

shut down existing MariaDB server for upgrade..
Stopping mysql (via systemctl):  [  OK  ]

total 331M
drwxr-xr-x.  5 mysql mysql 4.0K Jun 21 00:23 .
drwxr-xr-x. 36 root  root  4.0K Jun 14 13:52 ..
-rw-rw----.  1 mysql mysql  16K Jun 21 00:23 aria_log.00000001
-rw-rw----.  1 mysql mysql   52 Jun 21 00:23 aria_log_control
drwxr-xr-x.  2 root  root  4.0K Nov 27  2018 cmsetiofiotest
-rw-rw----.  1 mysql mysql  74M Jun 21 00:23 ibdata1
-rw-rw----.  1 mysql mysql 128M Jun 21 00:23 ib_logfile0
-rw-rw----.  1 mysql mysql 483K Nov 27  2018 ib_logfile0.gz
-rw-rw----.  1 mysql mysql 128M Nov 27  2018 ib_logfile1
-rw-rw----.  1 mysql mysql 128K Nov 27  2018 ib_logfile1.gz
-rw-rw----.  1 mysql mysql    0 Nov 27  2018 multi-master.info
drwx--x--x.  2 mysql mysql 4.0K Nov 27  2018 mysql
-rw-r--r--.  1 root  root    15 Nov 27  2018 mysql_upgrade_info
drwx------.  2 mysql mysql 4.0K Nov 27  2018 performance_schema

Code (Text):

    __  __               _         ____   ____    _   ___     ____        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ \    __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    __) |   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  / __/  _  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|_____|(_)/_/\_\
                                                                          
           ____                       ____         _              
          |  _ \  ___  _ __    ___   / ___|   ___ | |_  _   _  _ __
          | |_) |/ _ \| '_ \  / _ \  \___ \  / _ \| __|| | | || '_ \
          |  _ <|  __/| |_) || (_) |  ___) ||  __/| |_ | |_| || |_) |
          |_| \_\\___|| .__/  \___/  |____/  \___| \__| \__,_|| .__/
                      |_|                                     |_|
*************************************************
MariaDB 10.2.x Repo setup...
*************************************************

Loaded plugins: fastestmirror, priorities, versionlock
Cleaning repos: base centos-sclo-rh centos-sclo-sclo epel extras mariadb nasm
              : percona-release-x86_64 rpmforge updates
Cleaning up list of fastest mirrors
Other repos take up 15 M of disk space (use --verbose for details)
rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

*************************************************
MariaDB 10.2.x check available packages
yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
*************************************************

Installed Packages
MariaDB-client.x86_64               10.1.40-1.el7.centos                @mariadb
MariaDB-common.x86_64               10.1.40-1.el7.centos                @mariadb
MariaDB-compat.x86_64               10.1.40-1.el7.centos                @mariadb
MariaDB-devel.x86_64                10.1.40-1.el7.centos                @mariadb
MariaDB-shared.x86_64               10.1.40-1.el7.centos                @mariadb
Available Packages
MariaDB-client.x86_64               10.2.25-1.el7.centos                mariadb
MariaDB-common.x86_64               10.2.25-1.el7.centos                mariadb
MariaDB-compat.x86_64               10.2.25-1.el7.centos                mariadb
MariaDB-devel.x86_64                10.2.25-1.el7.centos                mariadb
MariaDB-server.x86_64               10.2.25-1.el7.centos                mariadb
MariaDB-shared.x86_64               10.2.25-1.el7.centos                mariadb
mariadb-devel.x86_64                1:5.5.60-1.el7_5                    base
mariadb-server.x86_64               1:5.5.60-1.el7_5                    base

real    0m18.016s
user    0m3.550s
sys     0m0.520s

Code (Text):

    __  __               _         ____   ____    _   ___     ____        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ \    __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    __) |   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  / __/  _  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|_____|(_)/_/\_\
                                                                          
                        ___              _          _  _
                       |_ _| _ __   ___ | |_  __ _ | || |
                        | | | '_ \ / __|| __|/ _` || || |
                        | | | | | |\__ \| |_| (_| || || |
                       |___||_| |_||___/ \__|\__,_||_||_|
                                                      

*************************************************
MariaDB 10.2.x YUM install...
yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
*************************************************

Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
 * base: ftp.swin.edu.au
 * centos-sclo-rh: ftp.swin.edu.au
 * centos-sclo-sclo: ftp.swin.edu.au
 * extras: ftp.swin.edu.au
 * rpmforge: mirror.as24220.net
 * updates: mirror.ventraip.net.au
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.1.40-1.el7.centos will be updated
---> Package MariaDB-client.x86_64 0:10.2.25-1.el7.centos will be an update
---> Package MariaDB-common.x86_64 0:10.1.40-1.el7.centos will be updated
---> Package MariaDB-common.x86_64 0:10.2.25-1.el7.centos will be an update
---> Package MariaDB-compat.x86_64 0:10.1.40-1.el7.centos will be updated
---> Package MariaDB-compat.x86_64 0:10.2.25-1.el7.centos will be an update
---> Package MariaDB-devel.x86_64 0:10.1.40-1.el7.centos will be updated
---> Package MariaDB-devel.x86_64 0:10.2.25-1.el7.centos will be an update
---> Package MariaDB-server.x86_64 0:10.2.25-1.el7.centos will be installed
---> Package MariaDB-shared.x86_64 0:10.1.40-1.el7.centos will be updated
---> Package MariaDB-shared.x86_64 0:10.2.25-1.el7.centos will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package             Arch        Version                     Repository    Size
================================================================================
Installing:
 MariaDB-server      x86_64      10.2.25-1.el7.centos        mariadb       24 M
Updating:
 MariaDB-client      x86_64      10.2.25-1.el7.centos        mariadb       11 M
 MariaDB-common      x86_64      10.2.25-1.el7.centos        mariadb       78 k
 MariaDB-compat      x86_64      10.2.25-1.el7.centos        mariadb      2.8 M
 MariaDB-devel       x86_64      10.2.25-1.el7.centos        mariadb      6.6 M
 MariaDB-shared      x86_64      10.2.25-1.el7.centos        mariadb      108 k

Transaction Summary
================================================================================
Install  1 Package
Upgrade  5 Packages

Total download size: 44 M
Downloading packages:
No Presto metadata available for mariadb
--------------------------------------------------------------------------------
Total                                              4.0 MB/s |  44 MB  00:10  
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Updating   : MariaDB-common-10.2.25-1.el7.centos.x86_64                  1/11
  Updating   : MariaDB-compat-10.2.25-1.el7.centos.x86_64                  2/11
  Updating   : MariaDB-client-10.2.25-1.el7.centos.x86_64                  3/11
  Installing : MariaDB-server-10.2.25-1.el7.centos.x86_64                  4/11
  Updating   : MariaDB-devel-10.2.25-1.el7.centos.x86_64                   5/11
  Updating   : MariaDB-shared-10.2.25-1.el7.centos.x86_64                  6/11
  Cleanup    : MariaDB-shared-10.1.40-1.el7.centos.x86_64                  7/11
  Cleanup    : MariaDB-client-10.1.40-1.el7.centos.x86_64                  8/11
  Cleanup    : MariaDB-compat-10.1.40-1.el7.centos.x86_64                  9/11
  Cleanup    : MariaDB-devel-10.1.40-1.el7.centos.x86_64                  10/11
  Cleanup    : MariaDB-common-10.1.40-1.el7.centos.x86_64                 11/11
  Verifying  : MariaDB-devel-10.2.25-1.el7.centos.x86_64                   1/11
  Verifying  : MariaDB-compat-10.2.25-1.el7.centos.x86_64                  2/11
  Verifying  : MariaDB-client-10.2.25-1.el7.centos.x86_64                  3/11
  Verifying  : MariaDB-shared-10.2.25-1.el7.centos.x86_64                  4/11
  Verifying  : MariaDB-server-10.2.25-1.el7.centos.x86_64                  5/11
  Verifying  : MariaDB-common-10.2.25-1.el7.centos.x86_64                  6/11
  Verifying  : MariaDB-shared-10.1.40-1.el7.centos.x86_64                  7/11
  Verifying  : MariaDB-compat-10.1.40-1.el7.centos.x86_64                  8/11
  Verifying  : MariaDB-client-10.1.40-1.el7.centos.x86_64                  9/11
  Verifying  : MariaDB-devel-10.1.40-1.el7.centos.x86_64                  10/11
  Verifying  : MariaDB-common-10.1.40-1.el7.centos.x86_64                 11/11

Installed:
  MariaDB-server.x86_64 0:10.2.25-1.el7.centos                              

Updated:
  MariaDB-client.x86_64 0:10.2.25-1.el7.centos                              
  MariaDB-common.x86_64 0:10.2.25-1.el7.centos                              
  MariaDB-compat.x86_64 0:10.2.25-1.el7.centos                              
  MariaDB-devel.x86_64 0:10.2.25-1.el7.centos                                
  MariaDB-shared.x86_64 0:10.2.25-1.el7.centos                              

Complete!

real    0m32.410s
user    0m15.923s
sys     0m4.639s

Code (Text):

*************************************************
* Adjust old MariaDB 10.x /etc/my.cnf
  for MariaDB 10.2.x my.cnf compatibility
*************************************************
    __  __               _         ____   ____    _   ___     ____        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ \    __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    __) |   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  / __/  _  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|_____|(_)/_/\_\
                                                                          
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/                  
         _        _   _              _                            _    
        / \    __| | (_) _   _  ___ | |_  _ __ ___    ___  _ __  | |_  ___
       / _ \  / _` | | || | | |/ __|| __|| '_ ` _ \  / _ \| '_ \ | __|/ __|
      / ___ \| (_| | | || |_| |\__ \| |_ | | | | | ||  __/| | | || |_ \__ \
     /_/   \_\\__,_|_/ | \__,_||___/ \__||_| |_| |_| \___||_| |_| \__||___/
                   |__/                                                

service mysql start
Starting mysql (via systemctl):  [  OK  ]
service mysql restart
Restarting mysql (via systemctl):  [  OK  ]

total 599M
-rw-rw----. 1 mysql mysql    0 Nov 27  2018 multi-master.info
drwx--x--x. 2 mysql mysql 4.0K Nov 27  2018 mysql
drwx------. 2 mysql mysql 4.0K Nov 27  2018 performance_schema
-rw-r--r--. 1 mysql mysql   15 Nov 27  2018 mysql_upgrade_info
-rw-rw----. 1 mysql mysql 128M Nov 27  2018 ib_logfile1.bak
drwxr-xr-x. 2 mysql mysql 4.0K Nov 27  2018 cmsetiofiotest
-rw-rw----. 1 mysql mysql 128M Jun 21 00:23 ib_logfile0.bak
-rw-rw----. 1 mysql mysql 128M Jun 21 00:24 ib_logfile1
-rw-rw----. 1 mysql mysql   52 Jun 21 00:24 aria_log_control
-rw-rw----. 1 mysql mysql  16K Jun 21 00:24 aria_log.00000001
-rw-rw----. 1 mysql mysql  924 Jun 21 00:24 ib_buffer_pool
-rw-rw----. 1 mysql mysql  74M Jun 21 00:24 ibdata1
-rw-rw----. 1 mysql mysql 128M Jun 21 00:24 ib_logfile0
-rw-rw----. 1 mysql mysql  12M Jun 21 00:24 ibtmp1
-rw-rw----. 1 mysql mysql  24K Jun 21 00:24 tc.log
-rw-rw----. 1 mysql mysql    6 Jun 21 00:24 host.domain.com.pid
srwxrwxrwx. 1 mysql mysql    0 Jun 21 00:24 mysql.sock
-rw-rw----. 1 mysql mysql 6.5K Jun 21 00:24 host.domain.com.err
mysql_upgrade --verbose
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
Processing databases
information_schema
mysql
performance_schema
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Processing databases
information_schema
mysql
performance_schema
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
performance_schema
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
------------------------------------------------
Installing MariaDB 10 plugins
------------------------------------------------
mysql -e "INSTALL SONAME 'metadata_lock_info';"
mysql -e "INSTALL SONAME 'query_cache_info';"
mysql -e "INSTALL SONAME 'query_response_time';"
mysql -t -e "SELECT * FROM mysql.plugin;"
+---------------------------+------------------------+
| name                      | dl                     |
+---------------------------+------------------------+
| METADATA_LOCK_INFO        | metadata_lock_info.so  |
| QUERY_CACHE_INFO          | query_cache_info.so    |
| QUERY_RESPONSE_TIME       | query_response_time.so |
| QUERY_RESPONSE_TIME_AUDIT | query_response_time.so |
+---------------------------+------------------------+
mysql -t -e "SHOW PLUGINS;"
+-------------------------------+----------+--------------------+------------------------+---------+
| Name                          | Status   | Type               | Library                | License |
+-------------------------------+----------+--------------------+------------------------+---------+
| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| wsrep                         | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CSV                           | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL                   | GPL     |
| user_variables                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| partition                     | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| METADATA_LOCK_INFO            | ACTIVE   | INFORMATION SCHEMA | metadata_lock_info.so  | GPL     |
| QUERY_CACHE_INFO              | ACTIVE   | INFORMATION SCHEMA | query_cache_info.so    | BSD     |
| QUERY_RESPONSE_TIME           | ACTIVE   | INFORMATION SCHEMA | query_response_time.so | GPL     |
| QUERY_RESPONSE_TIME_AUDIT     | ACTIVE   | AUDIT              | query_response_time.so | GPL     |
+-------------------------------+----------+--------------------+------------------------+---------+
mysql -t -e "SHOW ENGINES;"
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |
| CSV                | YES     | Stores tables as CSV files                                                       | NO           | NO   | NO         |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |
| MyISAM             | YES     | Non-transactional engine with good performance and small data footprint          | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
service mysql restart
Restarting mysql (via systemctl):  [  OK  ]
systemctl enable mariadb.service
Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

Code (Text):

mysqladmin  Ver 9.1 Distrib 10.2.25-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.2.25-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 sec

Threads: 4  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 1.000

------------------------------------------------
MariaDB 10.2.x Upgrade completed
------------------------------------------------

eva2000 · Jun 21, 2019

Centmin Mod 123.09beta01 MariaDB 10.2 to MariaDB 10.3 Upgrade

First check what version of MariaDB MySQL you're on via SSH command

Code (Text):

mysqladmin ver

Second, ensure variables are set in persistent config file /etc/centminmod/custom_config.inc

Code (Text):

ENABLE_MARIADBTENTWOUPGRADE='y'
ENABLE_MARIADBTENTHREEUPGRADE='y'
ENABLE_MARIADBTENFOURUPGRADE='y'

Third, run cmupdate command to ensure all local Centmin Mod 123.09beta01 code is up to date

Code (Text):

cmupdate

Fourth, ensure you have done mysqldump backup of all your MySQL databases on your server ensuring you have enough free disk space to do and store the *.sql file backups. This will save a backup of all your databases into one file at /home/mysql-all-databases-backup-$(date +"%d%m%y-%H%M%S").sql which is date timestamped and save a copy of your /etc/my.cnf settings file at /etc/my.cnf-backedup-$(date +"%d%m%y-%H%M%S").cnf

Code (Text):

cp -a /etc/my.cnf /etc/my.cnf-backedup-$(date +"%d%m%y-%H%M%S").cnf
mysqldump -Q -K --max_allowed_packet=256M --net_buffer_length=65536 --routines --events --triggers --hex-blob --all-databases > /home/mysql-all-databases-backup-$(date +"%d%m%y-%H%M%S").sql

Verify the backed up files using ls list command

Code (Text):

ls -lahrt /etc | grep backedup
ls -lahrt /home | grep all-databases-backup

Code (Text):

ls -lahrt /etc | grep backedup
-rw-r--r--.  1 root root 6.4K Jun 21 00:24 my.cnf-backedup-210619-003718.cnf
-rw-r--r--.  1 root root 6.4K Jun 21 00:24 my.cnf-backedup-210619-003341.cnf

and

Code (Text):

ls -lahrt /home | grep all-databases-backup                      
-rw-r--r--.  1 root  root  471K Jun 21 00:35 mysql-all-databases-backup-210619-003503.sql
-rw-r--r--.  1 root  root  471K Jun 21 00:35 mysql-all-databases-backup-210619-003521.sql

Then restrict the backed up file permissions so they're not world readable

Code (Text):

cd /home
chmod 0640 /home/mysql-all-databases-backup*

Code (Text):

ls -lahrt /home | grep all-databases-backup     
-rw-r-----.  1 root  root         471K Jun 21 00:35 mysql-all-databases-backup-210619-003503.sql
-rw-r-----.  1 root  root         471K Jun 21 00:35 mysql-all-databases-backup-210619-003521.sql

Fifth, run centmin.sh menu option 11, submenu option 7 for MariaDB 10.2 to 10.3 upgrade which will ask if you done mysqldump backups before proceeding to upgrade stage. You'll have to do a backup for each major upgrade from MariaDB 10.1 to 10.2 to 10.3 to 10.4 (if you choose 10.4 - I'd stick with 10.3 for now).

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). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 9 ] 7
--------------------------------------------------------

Code (Text):

-------------------------------------------------------------------------------
 This script's MariaDB 10.3.x upgrade process is still in beta testing stages.
 So please test on a test server and not a live production server. But if you use
 on live server or if MySQL databases already exist, please back them up before
 running this upgrade script via mysqldump - instructions at:
 http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.

 ###################################################################
 ###          IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE          ###
 ###        OR RISK DATA LOSS DUE TO MARIADB 10.3 Changes        ###
 ###################################################################

 For each DATABASENAME backup via mysqldump i.e.

  mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
------------------------------------------------------------------------

Have you backed up your databases ? [y/n] y

Code (Text):

MariaDB 10.3.x https://mariadb.com/resources/blog/whats-new-mariadb-server-103

!!  Note  !!
upgrade process can take more >5 minutes.. you may want to shutdown
nginx server to not show mysql errors to visitors on your site or
put site(s) into maintenance mode before proceeding with mysql upgrade

Do you want to continue with upgrade to MariaDB 10.3.x ? [y/n] y

checking mysql root password works in /root/.my.cnf
mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.2.25-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.2.25-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 13 min 34 sec

Threads: 4  Questions: 752  Slow queries: 0  Opens: 64  Flush tables: 1  Open tables: 58  Queries per second avg: 0.923
             ____                                  _              
            |  _ \  _ __  ___  _ __    __ _  _ __ (_) _ __    __ _
            | |_) || '__|/ _ \| '_ \  / _` || '__|| || '_ \  / _` |
            |  __/ | |  |  __/| |_) || (_| || |   | || | | || (_| |
            |_|    |_|   \___|| .__/  \__,_||_|   |_||_| |_| \__, |
                              |_|                            |___/
    ____   _             _       _                          _____          
   / ___| | |__   _   _ | |_  __| |  ___ __      __ _ __   |  ___|___   _ __
   \___ \ | '_ \ | | | || __|/ _` | / _ \\ \ /\ / /| '_ \  | |_  / _ \ | '__|
    ___) || | | || |_| || |_| (_| || (_) |\ V  V / | | | | |  _|| (_) || |  
   |____/ |_| |_| \__,_| \__|\__,_| \___/  \_/\_/  |_| |_| |_|   \___/ |_|  
                                                                            
                  _   _                                _      
                 | | | | _ __    __ _  _ __  __ _   __| |  ___
                 | | | || '_ \  / _` || '__|/ _` | / _` | / _ \
                 | |_| || |_) || (_| || |  | (_| || (_| ||  __/
                  \___/ | .__/  \__, ||_|   \__,_| \__,_| \___|
                        |_|     |___/                        

shut down existing MariaDB server for upgrade..
Stopping mysql (via systemctl):  [  OK  ]

total 587M
drwxr-xr-x.  5 mysql mysql 4.0K Jun 21 00:38 .
drwxr-xr-x. 36 root  root  4.0K Jun 14 13:52 ..
-rw-rw----.  1 mysql mysql  16K Jun 21 00:38 aria_log.00000001
-rw-rw----.  1 mysql mysql   52 Jun 21 00:38 aria_log_control
drwxr-xr-x.  2 mysql mysql 4.0K Nov 27  2018 cmsetiofiotest
-rw-rw----.  1 mysql mysql 1.1K Jun 21 00:24 ib_buffer_pool
-rw-rw----.  1 mysql mysql  74M Jun 21 00:38 ibdata1
-rw-rw----.  1 mysql mysql 128M Jun 21 00:38 ib_logfile0
-rw-rw----.  1 mysql mysql 128M Jun 21 00:23 ib_logfile0.bak
-rw-rw----.  1 mysql mysql 128M Jun 21 00:24 ib_logfile1
-rw-rw----.  1 mysql mysql 128M Nov 27  2018 ib_logfile1.bak
-rw-rw----.  1 mysql mysql    0 Nov 27  2018 multi-master.info
drwx--x--x.  2 mysql mysql 4.0K Jun 21 00:24 mysql
-rw-r--r--.  1 mysql mysql   15 Jun 21 00:24 mysql_upgrade_info
drwx------.  2 mysql mysql 4.0K Jun 21 00:24 performance_schema
-rw-rw----.  1 mysql mysql  11K Jun 21 00:38 host.domain.com.err

Code (Text):

    __  __               _         ____   ____    _   ___     _____        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ /   __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    |_ \   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |_  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/(_)/_/\_\
                                                                          
           ____                       ____         _                
          |  _ \  ___  _ __    ___   / ___|   ___ | |_  _   _  _ __
          | |_) |/ _ \| '_ \  / _ \  \___ \  / _ \| __|| | | || '_ \
          |  _ <|  __/| |_) || (_) |  ___) ||  __/| |_ | |_| || |_) |
          |_| \_\\___|| .__/  \___/  |____/  \___| \__| \__,_|| .__/
                      |_|                                     |_|  
*************************************************
MariaDB 10.3.x Repo setup...
*************************************************

Loaded plugins: fastestmirror, priorities, versionlock
Cleaning repos: base centos-sclo-rh centos-sclo-sclo epel extras mariadb nasm
              : percona-release-x86_64 rpmforge updates
Cleaning up list of fastest mirrors
Other repos take up 15 M of disk space (use --verbose for details)
rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

*************************************************
MariaDB 10.3.x check available packages
yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
*************************************************

Installed Packages
MariaDB-client.x86_64               10.2.25-1.el7.centos                @mariadb
MariaDB-common.x86_64               10.2.25-1.el7.centos                @mariadb
MariaDB-compat.x86_64               10.2.25-1.el7.centos                @mariadb
MariaDB-devel.x86_64                10.2.25-1.el7.centos                @mariadb
MariaDB-shared.x86_64               10.2.25-1.el7.centos                @mariadb
Available Packages
MariaDB-client.x86_64               10.3.16-1.el7.centos                mariadb
MariaDB-common.x86_64               10.3.16-1.el7.centos                mariadb
MariaDB-compat.x86_64               10.3.16-1.el7.centos                mariadb
MariaDB-devel.x86_64                10.3.16-1.el7.centos                mariadb
MariaDB-server.x86_64               10.3.16-1.el7.centos                mariadb
MariaDB-shared.x86_64               10.3.16-1.el7.centos                mariadb
mariadb-devel.x86_64                1:5.5.60-1.el7_5                    base  
mariadb-server.x86_64               1:5.5.60-1.el7_5                    base  

real    0m14.626s
user    0m3.678s
sys     0m0.502s

Code (Text):

    __  __               _         ____   ____    _   ___     _____        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ /   __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    |_ \   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |_  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/(_)/_/\_\
                                                                          
                        ___              _          _  _
                       |_ _| _ __   ___ | |_  __ _ | || |
                        | | | '_ \ / __|| __|/ _` || || |
                        | | | | | |\__ \| |_| (_| || || |
                       |___||_| |_||___/ \__|\__,_||_||_|
                                                        

*************************************************
MariaDB 10.3.x YUM install...
yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
*************************************************

Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
 * base: ftp.swin.edu.au
 * centos-sclo-rh: ftp.swin.edu.au
 * centos-sclo-sclo: ftp.swin.edu.au
 * extras: ftp.swin.edu.au
 * rpmforge: mirror.as24220.net
 * updates: mirror.colocity.com
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.2.25-1.el7.centos will be updated
---> Package MariaDB-client.x86_64 0:10.3.16-1.el7.centos will be an update
---> Package MariaDB-common.x86_64 0:10.2.25-1.el7.centos will be updated
---> Package MariaDB-common.x86_64 0:10.3.16-1.el7.centos will be an update
---> Package MariaDB-compat.x86_64 0:10.2.25-1.el7.centos will be updated
---> Package MariaDB-compat.x86_64 0:10.3.16-1.el7.centos will be an update
---> Package MariaDB-devel.x86_64 0:10.2.25-1.el7.centos will be updated
---> Package MariaDB-devel.x86_64 0:10.3.16-1.el7.centos will be an update
---> Package MariaDB-server.x86_64 0:10.3.16-1.el7.centos will be installed
---> Package MariaDB-shared.x86_64 0:10.2.25-1.el7.centos will be updated
---> Package MariaDB-shared.x86_64 0:10.3.16-1.el7.centos will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package             Arch        Version                     Repository    Size
================================================================================
Installing:
 MariaDB-server      x86_64      10.3.16-1.el7.centos        mariadb       24 M
Updating:
 MariaDB-client      x86_64      10.3.16-1.el7.centos        mariadb       11 M
 MariaDB-common      x86_64      10.3.16-1.el7.centos        mariadb       78 k
 MariaDB-compat      x86_64      10.3.16-1.el7.centos        mariadb      2.8 M
 MariaDB-devel       x86_64      10.3.16-1.el7.centos        mariadb      7.0 M
 MariaDB-shared      x86_64      10.3.16-1.el7.centos        mariadb      108 k

Transaction Summary
================================================================================
Install  1 Package
Upgrade  5 Packages

Total download size: 45 M
Downloading packages:
No Presto metadata available for mariadb
--------------------------------------------------------------------------------
Total                                              6.7 MB/s |  45 MB  00:06    
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Updating   : MariaDB-common-10.3.16-1.el7.centos.x86_64                  1/11
  Updating   : MariaDB-compat-10.3.16-1.el7.centos.x86_64                  2/11
  Updating   : MariaDB-client-10.3.16-1.el7.centos.x86_64                  3/11
  Installing : MariaDB-server-10.3.16-1.el7.centos.x86_64                  4/11
  Updating   : MariaDB-shared-10.3.16-1.el7.centos.x86_64                  5/11
  Updating   : MariaDB-devel-10.3.16-1.el7.centos.x86_64                   6/11
  Cleanup    : MariaDB-client-10.2.25-1.el7.centos.x86_64                  7/11
  Cleanup    : MariaDB-devel-10.2.25-1.el7.centos.x86_64                   8/11
  Cleanup    : MariaDB-shared-10.2.25-1.el7.centos.x86_64                  9/11
  Cleanup    : MariaDB-compat-10.2.25-1.el7.centos.x86_64                 10/11
  Cleanup    : MariaDB-common-10.2.25-1.el7.centos.x86_64                 11/11
  Verifying  : MariaDB-shared-10.3.16-1.el7.centos.x86_64                  1/11
  Verifying  : MariaDB-compat-10.3.16-1.el7.centos.x86_64                  2/11
  Verifying  : MariaDB-server-10.3.16-1.el7.centos.x86_64                  3/11
  Verifying  : MariaDB-common-10.3.16-1.el7.centos.x86_64                  4/11
  Verifying  : MariaDB-devel-10.3.16-1.el7.centos.x86_64                   5/11
  Verifying  : MariaDB-client-10.3.16-1.el7.centos.x86_64                  6/11
  Verifying  : MariaDB-devel-10.2.25-1.el7.centos.x86_64                   7/11
  Verifying  : MariaDB-client-10.2.25-1.el7.centos.x86_64                  8/11
  Verifying  : MariaDB-shared-10.2.25-1.el7.centos.x86_64                  9/11
  Verifying  : MariaDB-common-10.2.25-1.el7.centos.x86_64                 10/11
  Verifying  : MariaDB-compat-10.2.25-1.el7.centos.x86_64                 11/11

Installed:
  MariaDB-server.x86_64 0:10.3.16-1.el7.centos                                

Updated:
  MariaDB-client.x86_64 0:10.3.16-1.el7.centos                                
  MariaDB-common.x86_64 0:10.3.16-1.el7.centos                                
  MariaDB-compat.x86_64 0:10.3.16-1.el7.centos                                
  MariaDB-devel.x86_64 0:10.3.16-1.el7.centos                                  
  MariaDB-shared.x86_64 0:10.3.16-1.el7.centos                                

Complete!

real    0m30.690s
user    0m17.334s
sys     0m4.898s

Code (Text):

*************************************************
* Adjust old MariaDB 10.x /etc/my.cnf
  for MariaDB 10.3.x my.cnf compatibility
*************************************************
    __  __               _         ____   ____    _   ___     _____        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ /   __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    |_ \   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  ___) |_  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|____/(_)/_/\_\
                                                                          
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/                    
         _        _   _              _                            _      
        / \    __| | (_) _   _  ___ | |_  _ __ ___    ___  _ __  | |_  ___
       / _ \  / _` | | || | | |/ __|| __|| '_ ` _ \  / _ \| '_ \ | __|/ __|
      / ___ \| (_| | | || |_| |\__ \| |_ | | | | | ||  __/| | | || |_ \__ \
     /_/   \_\\__,_|_/ | \__,_||___/ \__||_| |_| |_| \___||_| |_| \__||___/
                   |__/                                                  

service mysql start
Starting mysql (via systemctl):  [  OK  ]
service mysql restart
Restarting mysql (via systemctl):  [  OK  ]

total 599M
-rw-rw----. 1 mysql mysql    0 Nov 27  2018 multi-master.info
drwxr-xr-x. 2 mysql mysql 4.0K Nov 27  2018 cmsetiofiotest
-rw-rw----. 1 mysql mysql 128M Jun 21 00:24 ib_logfile1.bak
drwx--x--x. 2 mysql mysql 4.0K Jun 21 00:24 mysql
drwx------. 2 mysql mysql 4.0K Jun 21 00:24 performance_schema
-rw-r--r--. 1 mysql mysql   15 Jun 21 00:24 mysql_upgrade_info
-rw-rw----. 1 mysql mysql 128M Jun 21 00:38 ib_logfile0.bak
-rw-rw----. 1 mysql mysql  11K Jun 21 00:38 host.domain.com.err
-rw-rw----. 1 mysql mysql 128M Jun 21 00:39 ib_logfile1
-rw-rw----. 1 mysql mysql 1004 Jun 21 00:39 ib_buffer_pool
-rw-rw----. 1 mysql mysql  74M Jun 21 00:39 ibdata1
-rw-rw----. 1 mysql mysql   52 Jun 21 00:39 aria_log_control
-rw-rw----. 1 mysql mysql  16K Jun 21 00:39 aria_log.00000001
-rw-rw----. 1 mysql mysql 128M Jun 21 00:39 ib_logfile0
-rw-rw----. 1 mysql mysql  12M Jun 21 00:39 ibtmp1
-rw-rw----. 1 mysql mysql  24K Jun 21 00:39 tc.log
-rw-rw----. 1 mysql mysql    5 Jun 21 00:39 host.pid
srwxrwxrwx. 1 mysql mysql    0 Jun 21 00:39 mysql.sock
mysql_upgrade --verbose
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
Processing databases
information_schema
mysql
performance_schema
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Processing databases
information_schema
mysql
performance_schema
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
performance_schema
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
------------------------------------------------
Installing MariaDB 10 plugins
------------------------------------------------
mysql -e "INSTALL SONAME 'metadata_lock_info';"
mysql -e "INSTALL SONAME 'query_cache_info';"
mysql -e "INSTALL SONAME 'query_response_time';"
mysql -t -e "SELECT * FROM mysql.plugin;"
+---------------------------+------------------------+
| name                      | dl                     |
+---------------------------+------------------------+
| METADATA_LOCK_INFO        | metadata_lock_info.so  |
| QUERY_CACHE_INFO          | query_cache_info.so    |
| QUERY_RESPONSE_TIME       | query_response_time.so |
| QUERY_RESPONSE_TIME_AUDIT | query_response_time.so |
+---------------------------+------------------------+
mysql -t -e "SHOW PLUGINS;"
+-------------------------------+----------+--------------------+------------------------+---------+
| Name                          | Status   | Type               | Library                | License |
+-------------------------------+----------+--------------------+------------------------+---------+
| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| wsrep                         | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CSV                           | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| SQL_SEQUENCE                  | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL                   | GPL     |
| user_variables                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| partition                     | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| METADATA_LOCK_INFO            | ACTIVE   | INFORMATION SCHEMA | metadata_lock_info.so  | GPL     |
| QUERY_CACHE_INFO              | ACTIVE   | INFORMATION SCHEMA | query_cache_info.so    | BSD     |
| QUERY_RESPONSE_TIME           | ACTIVE   | INFORMATION SCHEMA | query_response_time.so | GPL     |
| QUERY_RESPONSE_TIME_AUDIT     | ACTIVE   | AUDIT              | query_response_time.so | GPL     |
+-------------------------------+----------+--------------------+------------------------+---------+
mysql -t -e "SHOW ENGINES;"
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                            | NO           | NO   | NO         |
| CSV                | YES     | Stores tables as CSV files                                                       | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                        | NO           | NO   | NO         |
| MyISAM             | YES     | Non-transactional engine with good performance and small data footprint          | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                           | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
service mysql restart
Restarting mysql (via systemctl):  [  OK  ]
systemctl enable mariadb.service

Code (Text):

mysqladmin  Ver 9.1 Distrib 10.3.16-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.3.16-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 0 sec

Threads: 4  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.000

------------------------------------------------
MariaDB 10.3.x Upgrade completed
------------------------------------------------

eva2000 · Jun 21, 2019

Centmin Mod 123.09beta01 MariaDB 10.3 to MariaDB 10.4 Upgrade

Note, MariaDB 10.4 moves further away from being a 100% drop-in compatible MySQL (Oracle) server so features or change in MariaDB 10.4 may not allow easy downgrade to other MySQL server versions or forks or make importing non-MariaDB MySQL data from Oracle or Percona MySQL into MariaDB 10.4 go smoothly. Details at MariaDB - Interesting look at what's new in MariaDB 10.4.

First check what version of MariaDB MySQL you're on via SSH command

Code (Text):

mysqladmin ver

Second, ensure variables are set in persistent config file /etc/centminmod/custom_config.inc

Code (Text):

ENABLE_MARIADBTENTWOUPGRADE='y'
ENABLE_MARIADBTENTHREEUPGRADE='y'
ENABLE_MARIADBTENFOURUPGRADE='y'

Third, run cmupdate command to ensure all local Centmin Mod 123.09beta01 code is up to date

Code (Text):

cmupdate

Fourth, ensure you have done mysqldump backup of all your MySQL databases on your server ensuring you have enough free disk space to do and store the *.sql file backups. This will save a backup of all your databases into one file at /home/mysql-all-databases-backup-$(date +"%d%m%y-%H%M%S").sql which is date timestamped and save a copy of your /etc/my.cnf settings file at /etc/my.cnf-backedup-$(date +"%d%m%y-%H%M%S").cnf

Code (Text):

cp -a /etc/my.cnf /etc/my.cnf-backedup-$(date +"%d%m%y-%H%M%S").cnf
mysqldump -Q -K --max_allowed_packet=256M --net_buffer_length=65536 --routines --events --triggers --hex-blob --all-databases > /home/mysql-all-databases-backup-$(date +"%d%m%y-%H%M%S").sql

Verify the backed up files using ls list command

Code (Text):

ls -lahrt /etc | grep backedup
ls -lahrt /home | grep all-databases-backup

Code (Text):

ls -lahrt /etc | grep backedup                                                                                                                                                          
-rw-r--r--.  1 root root 6.4K Jun 21 00:24 my.cnf-backedup-210619-003718.cnf
-rw-r--r--.  1 root root 6.4K Jun 21 00:24 my.cnf-backedup-210619-003341.cnf
-rw-r--r--.  1 root root 7.6K Jun 21 00:39 my.cnf-backedup-210619-004255.cnf

and

Code (Text):

ls -lahrt /home | grep all-databases-backup                                                                                                                                              
-rw-r--r--.  1 root  root  471K Jun 21 00:35 mysql-all-databases-backup-210619-003503.sql
-rw-r--r--.  1 root  root  471K Jun 21 00:35 mysql-all-databases-backup-210619-003521.sql
-rw-r--r--.  1 root  root  472K Jun 21 00:42 mysql-all-databases-backup-210619-004259.sql

Then restrict the backed up file permissions so they're not world readable

Code (Text):

cd /home
chmod 0640 /home/mysql-all-databases-backup*

Code (Text):

ls -lahrt /home | grep all-databases-backup     
-rw-r-----.  1 root  root         471K Jun 21 00:35 mysql-all-databases-backup-210619-003503.sql
-rw-r-----.  1 root  root         471K Jun 21 00:35 mysql-all-databases-backup-210619-003521.sql
-rw-r-----.  1 root  root         472K Jun 21 00:42 mysql-all-databases-backup-210619-004259.sql

Fifth, run centmin.sh menu option 11, submenu option 8 for MariaDB 10.3 to 10.4 upgrade which will ask if you done mysqldump backups before proceeding to upgrade stage. You'll have to do a backup for each major upgrade from MariaDB 10.1 to 10.2 to 10.3 to 10.4 (if you choose 10.4 - I'd stick with 10.3 for now).

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). Back to Main menu
--------------------------------------------------------
Enter option [ 0 - 9 ] 8
--------------------------------------------------------

Code (Text):

-------------------------------------------------------------------------------
 This script's MariaDB 10.4.x upgrade process is still in beta testing stages.
 So please test on a test server and not a live production server. But if you use
 on live server or if MySQL databases already exist, please back them up before
 running this upgrade script via mysqldump - instructions at:
 http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.

 ###################################################################
 ###          IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE          ###
 ###        OR RISK DATA LOSS DUE TO MARIADB 10.4 Changes        ###
 ###################################################################

 For each DATABASENAME backup via mysqldump i.e.

  mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
------------------------------------------------------------------------

Have you backed up your databases ? [y/n] y

Code (Text):

MariaDB 10.4.x https://mariadb.com/kb/en/library/what-is-mariadb-104/

!!  Note  !!
upgrade process can take more >5 minutes.. you may want to shutdown
nginx server to not show mysql errors to visitors on your site or
put site(s) into maintenance mode before proceeding with mysql upgrade

Do you want to continue with upgrade to MariaDB 10.4.x ? [y/n] y

checking mysql root password works in /root/.my.cnf
mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.3.16-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.3.16-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 4 min 46 sec

Threads: 4  Questions: 386  Slow queries: 0  Opens: 65  Flush tables: 1  Open tables: 59  Queries per second avg: 1.349
             ____                                  _            
            |  _ \  _ __  ___  _ __    __ _  _ __ (_) _ __    __ _
            | |_) || '__|/ _ \| '_ \  / _` || '__|| || '_ \  / _` |
            |  __/ | |  |  __/| |_) || (_| || |   | || | | || (_| |
            |_|    |_|   \___|| .__/  \__,_||_|   |_||_| |_| \__, |
                              |_|                            |___/
    ____   _             _       _                          _____        
   / ___| | |__   _   _ | |_  __| |  ___ __      __ _ __   |  ___|___   _ __
   \___ \ | '_ \ | | | || __|/ _` | / _ \\ \ /\ / /| '_ \  | |_  / _ \ | '__|
    ___) || | | || |_| || |_| (_| || (_) |\ V  V / | | | | |  _|| (_) || |
   |____/ |_| |_| \__,_| \__|\__,_| \___/  \_/\_/  |_| |_| |_|   \___/ |_|
                                                                          
                  _   _                                _    
                 | | | | _ __    __ _  _ __  __ _   __| |  ___
                 | | | || '_ \  / _` || '__|/ _` | / _` | / _ \
                 | |_| || |_) || (_| || |  | (_| || (_| ||  __/
                  \___/ | .__/  \__, ||_|   \__,_| \__,_| \___|
                        |_|     |___/                      

shut down existing MariaDB server for upgrade..
Stopping mysql (via systemctl):  [  OK  ]

total 587M
drwxr-xr-x.  5 mysql mysql 4.0K Jun 21 00:44 .
drwxr-xr-x. 36 root  root  4.0K Jun 14 13:52 ..
-rw-rw----.  1 mysql mysql  16K Jun 21 00:44 aria_log.00000001
-rw-rw----.  1 mysql mysql   52 Jun 21 00:44 aria_log_control
drwxr-xr-x.  2 mysql mysql 4.0K Nov 27  2018 cmsetiofiotest
-rw-rw----.  1 mysql mysql 1.1K Jun 21 00:39 ib_buffer_pool
-rw-rw----.  1 mysql mysql  74M Jun 21 00:44 ibdata1
-rw-rw----.  1 mysql mysql 128M Jun 21 00:44 ib_logfile0
-rw-rw----.  1 mysql mysql 128M Jun 21 00:38 ib_logfile0.bak
-rw-rw----.  1 mysql mysql 128M Jun 21 00:39 ib_logfile1
-rw-rw----.  1 mysql mysql 128M Jun 21 00:24 ib_logfile1.bak
-rw-rw----.  1 mysql mysql    0 Nov 27  2018 multi-master.info
drwx--x--x.  2 mysql mysql 4.0K Jun 21 00:39 mysql
-rw-r--r--.  1 mysql mysql   16 Jun 21 00:39 mysql_upgrade_info
drwx------.  2 mysql mysql 4.0K Jun 21 00:39 performance_schema
-rw-rw----.  1 mysql mysql  11K Jun 21 00:38 host.domain.com.err

Code (Text):

    __  __               _         ____   ____    _   ___    _  _        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \  | || |    __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | | | || |_   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_|__   _|_  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)  |_| (_)/_/\_\
                                                                        
           ____                       ____         _              
          |  _ \  ___  _ __    ___   / ___|   ___ | |_  _   _  _ __
          | |_) |/ _ \| '_ \  / _ \  \___ \  / _ \| __|| | | || '_ \
          |  _ <|  __/| |_) || (_) |  ___) ||  __/| |_ | |_| || |_) |
          |_| \_\\___|| .__/  \___/  |____/  \___| \__| \__,_|| .__/
                      |_|                                     |_|
*************************************************
MariaDB 10.4.x Repo setup...
*************************************************

Loaded plugins: fastestmirror, priorities, versionlock
Cleaning repos: base centos-sclo-rh centos-sclo-sclo epel extras mariadb nasm
              : percona-release-x86_64 rpmforge updates
Cleaning up list of fastest mirrors
Other repos take up 15 M of disk space (use --verbose for details)
rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

*************************************************
MariaDB 10.4.x check available packages
yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
*************************************************

Installed Packages
MariaDB-client.x86_64               10.3.16-1.el7.centos                @mariadb
MariaDB-common.x86_64               10.3.16-1.el7.centos                @mariadb
MariaDB-compat.x86_64               10.3.16-1.el7.centos                @mariadb
MariaDB-devel.x86_64                10.3.16-1.el7.centos                @mariadb
MariaDB-shared.x86_64               10.3.16-1.el7.centos                @mariadb
Available Packages
MariaDB-client.x86_64               10.4.6-1.el7.centos                 mariadb
MariaDB-common.x86_64               10.4.6-1.el7.centos                 mariadb
MariaDB-compat.x86_64               10.4.6-1.el7.centos                 mariadb
MariaDB-devel.x86_64                10.4.6-1.el7.centos                 mariadb
MariaDB-server.x86_64               10.4.6-1.el7.centos                 mariadb
MariaDB-shared.x86_64               10.4.6-1.el7.centos                 mariadb
mariadb-devel.x86_64                1:5.5.60-1.el7_5                    base
mariadb-server.x86_64               1:5.5.60-1.el7_5                    base

real    0m14.029s
user    0m3.654s
sys     0m0.510s

Code (Text):

    __  __               _         ____   ____    _   ___    _  _        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \  | || |    __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | | | || |_   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_|__   _|_  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)  |_| (_)/_/\_\
                                                                        
                        ___              _          _  _
                       |_ _| _ __   ___ | |_  __ _ | || |
                        | | | '_ \ / __|| __|/ _` || || |
                        | | | | | |\__ \| |_| (_| || || |
                       |___||_| |_||___/ \__|\__,_||_||_|
                                                      

*************************************************
MariaDB 10.4.x YUM install...
yum -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
*************************************************

Loaded plugins: fastestmirror, versionlock
Loading mirror speeds from cached hostfile
 * base: ftp.swin.edu.au
 * centos-sclo-rh: ftp.swin.edu.au
 * centos-sclo-sclo: ftp.swin.edu.au
 * extras: ftp.swin.edu.au
 * rpmforge: mirror.as24220.net
 * updates: mirror.colocity.com
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.3.16-1.el7.centos will be updated
---> Package MariaDB-client.x86_64 0:10.4.6-1.el7.centos will be an update
---> Package MariaDB-common.x86_64 0:10.3.16-1.el7.centos will be updated
---> Package MariaDB-common.x86_64 0:10.4.6-1.el7.centos will be an update
---> Package MariaDB-compat.x86_64 0:10.3.16-1.el7.centos will be updated
---> Package MariaDB-compat.x86_64 0:10.4.6-1.el7.centos will be an update
---> Package MariaDB-devel.x86_64 0:10.3.16-1.el7.centos will be updated
---> Package MariaDB-devel.x86_64 0:10.4.6-1.el7.centos will be an update
---> Package MariaDB-server.x86_64 0:10.4.6-1.el7.centos will be installed
--> Processing Dependency: galera-4 for package: MariaDB-server-10.4.6-1.el7.centos.x86_64
---> Package MariaDB-shared.x86_64 0:10.3.16-1.el7.centos will be updated
---> Package MariaDB-shared.x86_64 0:10.4.6-1.el7.centos will be an update
--> Running transaction check
---> Package galera-4.x86_64 0:26.4.2-1.rhel7.el7.centos will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package            Arch       Version                        Repository   Size
================================================================================
Installing:
 MariaDB-server     x86_64     10.4.6-1.el7.centos            mariadb      25 M
Updating:
 MariaDB-client     x86_64     10.4.6-1.el7.centos            mariadb      12 M
 MariaDB-common     x86_64     10.4.6-1.el7.centos            mariadb      81 k
 MariaDB-compat     x86_64     10.4.6-1.el7.centos            mariadb     2.8 M
 MariaDB-devel      x86_64     10.4.6-1.el7.centos            mariadb     7.5 M
 MariaDB-shared     x86_64     10.4.6-1.el7.centos            mariadb     112 k
Installing for dependencies:
 galera-4           x86_64     26.4.2-1.rhel7.el7.centos      mariadb     9.4 M

Transaction Summary
================================================================================
Install  1 Package  (+1 Dependent package)
Upgrade  5 Packages

Total download size: 57 M
Downloading packages:
No Presto metadata available for mariadb
--------------------------------------------------------------------------------
Total                                              6.4 MB/s |  57 MB  00:08  
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Updating   : MariaDB-compat-10.4.6-1.el7.centos.x86_64                   1/12
  Updating   : MariaDB-common-10.4.6-1.el7.centos.x86_64                   2/12
  Updating   : MariaDB-client-10.4.6-1.el7.centos.x86_64                   3/12
  Installing : galera-4-26.4.2-1.rhel7.el7.centos.x86_64                   4/12
  Installing : MariaDB-server-10.4.6-1.el7.centos.x86_64                   5/12
  Updating   : MariaDB-devel-10.4.6-1.el7.centos.x86_64                    6/12
  Updating   : MariaDB-shared-10.4.6-1.el7.centos.x86_64                   7/12
  Cleanup    : MariaDB-shared-10.3.16-1.el7.centos.x86_64                  8/12
  Cleanup    : MariaDB-client-10.3.16-1.el7.centos.x86_64                  9/12
  Cleanup    : MariaDB-devel-10.3.16-1.el7.centos.x86_64                  10/12
  Cleanup    : MariaDB-compat-10.3.16-1.el7.centos.x86_64                 11/12
  Cleanup    : MariaDB-common-10.3.16-1.el7.centos.x86_64                 12/12
  Verifying  : galera-4-26.4.2-1.rhel7.el7.centos.x86_64                   1/12
  Verifying  : MariaDB-server-10.4.6-1.el7.centos.x86_64                   2/12
  Verifying  : MariaDB-devel-10.4.6-1.el7.centos.x86_64                    3/12
  Verifying  : MariaDB-client-10.4.6-1.el7.centos.x86_64                   4/12
  Verifying  : MariaDB-common-10.4.6-1.el7.centos.x86_64                   5/12
  Verifying  : MariaDB-compat-10.4.6-1.el7.centos.x86_64                   6/12
  Verifying  : MariaDB-shared-10.4.6-1.el7.centos.x86_64                   7/12
  Verifying  : MariaDB-shared-10.3.16-1.el7.centos.x86_64                  8/12
  Verifying  : MariaDB-common-10.3.16-1.el7.centos.x86_64                  9/12
  Verifying  : MariaDB-devel-10.3.16-1.el7.centos.x86_64                  10/12
  Verifying  : MariaDB-client-10.3.16-1.el7.centos.x86_64                 11/12
  Verifying  : MariaDB-compat-10.3.16-1.el7.centos.x86_64                 12/12

Installed:
  MariaDB-server.x86_64 0:10.4.6-1.el7.centos                                

Dependency Installed:
  galera-4.x86_64 0:26.4.2-1.rhel7.el7.centos                                

Updated:
  MariaDB-client.x86_64 0:10.4.6-1.el7.centos                                
  MariaDB-common.x86_64 0:10.4.6-1.el7.centos                                
  MariaDB-compat.x86_64 0:10.4.6-1.el7.centos                                
  MariaDB-devel.x86_64 0:10.4.6-1.el7.centos                                
  MariaDB-shared.x86_64 0:10.4.6-1.el7.centos                                

Complete!

real    0m32.659s
user    0m17.665s
sys     0m4.977s

Code (Text):

*************************************************
* Adjust old MariaDB 10.x /etc/my.cnf
  for MariaDB 10.4.x my.cnf compatibility
*************************************************
    __  __               _         ____   ____    _   ___    _  _        
   |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \  | || |    __  __
   | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | | | || |_   \ \/ /
   | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_|__   _|_  >  <
   |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)  |_| (_)/_/\_\
                                                                        
            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/                  
         _        _   _              _                            _    
        / \    __| | (_) _   _  ___ | |_  _ __ ___    ___  _ __  | |_  ___
       / _ \  / _` | | || | | |/ __|| __|| '_ ` _ \  / _ \| '_ \ | __|/ __|
      / ___ \| (_| | | || |_| |\__ \| |_ | | | | | ||  __/| | | || |_ \__ \
     /_/   \_\\__,_|_/ | \__,_||___/ \__||_| |_| |_| \___||_| |_| \__||___/
                   |__/                                                

service mysql start
Redirecting to /bin/systemctl start mysql.service
service mysql restart
Redirecting to /bin/systemctl restart mysql.service

total 599M
-rw-rw----. 1 mysql mysql    0 Nov 27  2018 multi-master.info
drwxr-xr-x. 2 mysql mysql 4.0K Nov 27  2018 cmsetiofiotest
-rw-rw----. 1 mysql mysql  11K Jun 21 00:38 host.domain.com.err
-rw-rw----. 1 mysql mysql 128M Jun 21 00:39 ib_logfile1.bak
drwx--x--x. 2 mysql mysql 4.0K Jun 21 00:39 mysql
drwx------. 2 mysql mysql 4.0K Jun 21 00:39 performance_schema
-rw-r--r--. 1 mysql mysql   16 Jun 21 00:39 mysql_upgrade_info
-rw-rw----. 1 mysql mysql 128M Jun 21 00:44 ib_logfile0.bak
-rw-rw----. 1 mysql mysql 128M Jun 21 00:45 ib_logfile1
-rw-rw----. 1 mysql mysql 1.1K Jun 21 00:45 ib_buffer_pool
-rw-rw----. 1 mysql mysql  74M Jun 21 00:45 ibdata1
-rw-rw----. 1 mysql mysql   52 Jun 21 00:45 aria_log_control
-rw-rw----. 1 mysql mysql  16K Jun 21 00:45 aria_log.00000001
-rw-rw----. 1 mysql mysql 128M Jun 21 00:45 ib_logfile0
-rw-rw----. 1 mysql mysql  12M Jun 21 00:45 ibtmp1
-rw-rw----. 1 mysql mysql    5 Jun 21 00:45 host.pid
srwxrwxrwx. 1 mysql mysql    0 Jun 21 00:45 mysql.sock
mysql_upgrade --verbose
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
mysql.user                                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
Processing databases
information_schema
mysql
performance_schema
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Processing databases
information_schema
mysql
performance_schema
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
performance_schema
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
------------------------------------------------
Installing MariaDB 10 plugins
------------------------------------------------
mysql -e "INSTALL SONAME 'metadata_lock_info';"
mysql -e "INSTALL SONAME 'query_cache_info';"
mysql -e "INSTALL SONAME 'query_response_time';"
mysql -t -e "SELECT * FROM mysql.plugin;"
+---------------------------+------------------------+
| name                      | dl                     |
+---------------------------+------------------------+
| METADATA_LOCK_INFO        | metadata_lock_info.so  |
| QUERY_CACHE_INFO          | query_cache_info.so    |
| QUERY_RESPONSE_TIME       | query_response_time.so |
| QUERY_RESPONSE_TIME_AUDIT | query_response_time.so |
+---------------------------+------------------------+
mysql -t -e "SHOW PLUGINS;"
+-------------------------------+----------+--------------------+------------------------+---------+
| Name                          | Status   | Type               | Library                | License |
+-------------------------------+----------+--------------------+------------------------+---------+
| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| wsrep                         | ACTIVE   | REPLICATION        | NULL                   | GPL     |
| CSV                           | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| SQL_SEQUENCE                  | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL                   | BSD     |
| PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| unix_socket                   | ACTIVE   | AUTHENTICATION     | NULL                   | GPL     |
| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL                   | GPL     |
| user_variables                | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
| partition                     | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
| METADATA_LOCK_INFO            | ACTIVE   | INFORMATION SCHEMA | metadata_lock_info.so  | GPL     |
| QUERY_CACHE_INFO              | ACTIVE   | INFORMATION SCHEMA | query_cache_info.so    | BSD     |
| QUERY_RESPONSE_TIME           | ACTIVE   | INFORMATION SCHEMA | query_response_time.so | GPL     |
| QUERY_RESPONSE_TIME_AUDIT     | ACTIVE   | AUDIT              | query_response_time.so | GPL     |
+-------------------------------+----------+--------------------+------------------------+---------+
mysql -t -e "SHOW ENGINES;"
+--------------------+---------+-------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                                         | Transactions | XA   | Savepoints |
+--------------------+---------+-------------------------------------------------------------------------------------------------+--------------+------+------------+
| CSV                | YES     | Stores tables as CSV files                                                                      | NO           | NO   | NO         |
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                           | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                       | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege tables | NO           | NO   | NO         |
| MyISAM             | YES     | Non-transactional engine with good performance and small data footprint                         | NO           | NO   | NO         |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                                  | YES          | NO   | YES        |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables                | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                              | NO           | NO   | NO         |
+--------------------+---------+-------------------------------------------------------------------------------------------------+--------------+------+------------+
service mysql restart
Redirecting to /bin/systemctl restart mysql.service
systemctl enable mariadb.service

Code (Text):

mysqladmin  Ver 9.1 Distrib 10.4.6-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.4.6-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 0 sec

Threads: 4  Questions: 1  Slow queries: 0  Opens: 16  Flush tables: 1  Open tables: 10  Queries per second avg: 0.000

------------------------------------------------
MariaDB 10.4.x Upgrade completed
------------------------------------------------

eva2000 · Apr 22, 2023

Created thread to discuss MariaDB 10.3 EOL on May 25, 2023 at Official MariaDB 10.3 YUM repo EOL May 25, 2023

eva2000 · Dec 15, 2024

Centmin Mod 131.00stable and 140.00beta01 also support Mariadb 10.6 as outlined at https://community.centminmod.com/threads/mariadb-10-4-upgrades-testing.23277/. For existing Centmin Mod installs upgrade to Mariadb 10.6, you have to enable the following 3 variables to be set in the persistent config file /etc/centminmod/custom_config.inc BEFORE running centmin.sh menu option 11.

Code (Text):

ENABLE_MARIADBTENFOURUPGRADE='y'
ENABLE_MARIADBTENFIVEUPGRADE='y'
ENABLE_MARIADBTENSIXUPGRADE='y'

You can't skip major versions when upgrading. So to upgrade to MariaDB 10.6, you need to upgrade from 10.3 to 10.4, then 10.4 to 10.5 and then 10.5 to 10.6.

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 ]

I am currently testing in 140.00beta01 privately, MariaDB 10.11 support if you're on EL8/EL9 OSes, so centmin.sh menu option 11 would be like below. But most folks will only see up to MariaDB 10.6 support for now

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 ]
--------------------------------------------------------

Log in / Register

Forums

Learn about Centmin Mod LEMP Stack today

MariaDB MariaDB 10.1 upgrades to MariaDB 10.2, 10.3, 10.4, 10.5, 10.6

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB Upgrade Submenu

Upgrade MariaDB 10.1 To 10.2 & 10.2 To 10.3 To 10.4 Differences

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB 10.1 to MariaDB 10.2 Upgrade

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB 10.2 to MariaDB 10.3 Upgrade

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB 10.3 to MariaDB 10.4 Upgrade

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Learn about Centmin Mod LEMP Stack today

MariaDB MariaDB 10.1 upgrades to MariaDB 10.2, 10.3, 10.4, 10.5, 10.6

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB Upgrade Submenu

Upgrade MariaDB 10.1 To 10.2 & 10.2 To 10.3 To 10.4 Differences

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB 10.1 to MariaDB 10.2 Upgrade

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB 10.2 to MariaDB 10.3 Upgrade

eva2000 Administrator Staff Member

Centmin Mod 123.09beta01 MariaDB 10.3 to MariaDB 10.4 Upgrade

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

.