Want more timely Centmin Mod News Updates?
Become a Member

MariaDB MariaDB 10.1.7 now available - upgrade for Centmin Mod LEMP stack

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Sep 10, 2015.

  1. eva2000

    eva2000 Administrator Staff Member

    29,035
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    6:41 AM
    Nginx 1.13.x
    MariaDB 5.5



    [​IMG]The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.7. This is a Release Candidate (RC) release.

    See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.1? page in the MariaDB Knowledge Base for general information about the MariaDB 10.1 series.

    Thanks, and enjoy MariaDB!

    Continue reading...
     
  2. eva2000

    eva2000 Administrator Staff Member

    29,035
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    6:41 AM
    Nginx 1.13.x
    MariaDB 5.5
    finally first RC release for MariaDB 10.1 branch What is MariaDB 10.1? - MariaDB Knowledge Base :)

    Been looking forward to MariaDB 10.1 for it's Facebook WebScale MySQL patches [MDEV-6039] WebScaleSQL patches - JIRA + MySQL 5.7 backports

    Code:
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.1.7-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.7-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 1 min 48 sec
    
    Threads: 1  Questions: 1  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 11  Queries per second avg: 0.009
     
    Last edited: Sep 10, 2015
  3. pamamolf

    pamamolf Well-Known Member

    2,533
    231
    63
    May 31, 2014
    Ratings:
    +394
    Local Time:
    11:41 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Is there any release date for the final version?
     
  4. eva2000

    eva2000 Administrator Staff Member

    29,035
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    6:41 AM
    Nginx 1.13.x
    MariaDB 5.5
    haven't check TBH

    testing 123.09beta01 test branch for mariadb 10.0 to 10.1.7 update :)

    Code:
    --------------------------------------------------------
    Centmin Mod 1.2.3-eva2000.09 - http://centminmod.com
    --------------------------------------------------------
                       Centmin Mod Menu                
    --------------------------------------------------------
    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 5.2/5.5 & 10.x Upgrade Sub-Menu
    12). Zend OpCache Install/Re-install
    13). Install ioping.sh vbtechsupport.com/1239/
    14). SELinux disable
    15). Install/Reinstall ImagicK PHP Extension
    16). Change SSHD Port Number
    17). Multi-thread compression: pigz,pbzip2,lbzip2...
    18). Suhosin PHP Extension install
    19). Install FFMPEG and FFMPEG PHP Extension
    20). NSD Re-install
    21). Update - Nginx + PHP-FPM + Siege
    22). Add Wordpress Nginx vhost + WP Super Cache
    23). Update Centmin Mod Code Base
    24). Exit
    --------------------------------------------------------
    Enter option [ 1 - 24 ] 11
    --------------------------------------------------------
    
    Code:
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu           
    --------------------------------------------------------
    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). Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 6 ] 4
    --------------------------------------------------------
    Place holder for now until MariaDB 10.1.x is ready to be added
    
    Code:
    --------------------------------------------------------
            MariaDB MySQL Upgrade Sub-Menu           
    --------------------------------------------------------
    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). Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 6 ] 5
    --------------------------------------------------------
    
    Code:
    --------------------------------------------------------------------------------
    This script's MariaDB 10.1.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.1 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
    
    MariaDB 10.1.x no longer works with mydumper
    MySQL backup tool. But still works with MariaDB 5.2.x
    Do you want to continue with upgrade to MariaDB 10.1.x ? [y/n] y
    
    Code:
    *************************************************
    MariaDB 10.1.x Repo setup...
    *************************************************
    
    Loaded plugins: fastestmirror, priorities
    Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
    Cleaning repos: base epel extras mariadb rpmforge updates
    Cleaning up everything
    Cleaning up list of fastest mirrors
    rpm --import http://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    
    *************************************************
    MariaDB 10.1.x check available packages
    yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Installed Packages
    MariaDB-client.x86_64               10.0.17-1.el7.centos                @mariadb
    MariaDB-common.x86_64               10.0.17-1.el7.centos                @mariadb
    MariaDB-compat.x86_64               10.0.17-1.el7.centos                @mariadb
    MariaDB-devel.x86_64                10.0.17-1.el7.centos                @mariadb
    MariaDB-shared.x86_64               10.0.17-1.el7.centos                @mariadb
    Available Packages
    MariaDB-client.x86_64               10.1.7-1.el7.centos                 mariadb
    MariaDB-common.x86_64               10.1.7-1.el7.centos                 mariadb
    MariaDB-compat.x86_64               10.1.7-1.el7.centos                 mariadb
    MariaDB-devel.x86_64                10.1.7-1.el7.centos                 mariadb
    MariaDB-server.x86_64               10.1.7-1.el7.centos                 mariadb
    MariaDB-shared.x86_64               10.1.7-1.el7.centos                 mariadb
    mariadb-devel.x86_64                1:5.5.44-1.el7_1                    updates
    mariadb-server.x86_64               1:5.5.44-1.el7_1                    updates
    
    real    0m16.967s
    user    0m5.146s
    sys     0m0.559s
    
    *************************************************
    MariaDB 10.1.x YUM install...
    yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
    *************************************************
    
    Loaded plugins: fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    * base: centos.mirror.serversaustralia.com.au
    * epel: fedora.mirror.serversaustralia.com.au
    * extras: mirror.aarnet.edu.au
    * rpmforge: mirror.ventraip.net.au
    * updates: mirror.aarnet.edu.au
    152 packages excluded due to repository priority protections
    Resolving Dependencies
    --> Running transaction check
    ---> Package MariaDB-client.x86_64 0:10.0.17-1.el7.centos will be updated
    ---> Package MariaDB-client.x86_64 0:10.1.7-1.el7.centos will be an update
    ---> Package MariaDB-common.x86_64 0:10.0.17-1.el7.centos will be updated
    ---> Package MariaDB-common.x86_64 0:10.1.7-1.el7.centos will be an update
    ---> Package MariaDB-compat.x86_64 0:10.0.17-1.el7.centos will be updated
    ---> Package MariaDB-compat.x86_64 0:10.1.7-1.el7.centos will be an update
    ---> Package MariaDB-devel.x86_64 0:10.0.17-1.el7.centos will be updated
    ---> Package MariaDB-devel.x86_64 0:10.1.7-1.el7.centos will be an update
    ---> Package MariaDB-server.x86_64 0:10.1.7-1.el7.centos will be installed
    --> Processing Dependency: libjemalloc.so.1()(64bit) for package: MariaDB-server-10.1.7-1.el7.centos.x86_64
    ---> Package MariaDB-shared.x86_64 0:10.0.17-1.el7.centos will be updated
    ---> Package MariaDB-shared.x86_64 0:10.1.7-1.el7.centos will be an update
    --> Running transaction check
    ---> Package jemalloc.x86_64 0:3.6.0-1.el7 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ================================================================================
    Package             Arch        Version                     Repository    Size
    ================================================================================
    Installing:
    MariaDB-server      x86_64      10.1.7-1.el7.centos         mariadb       96 M
    Updating:
    MariaDB-client      x86_64      10.1.7-1.el7.centos         mariadb       38 M
    MariaDB-common      x86_64      10.1.7-1.el7.centos         mariadb       43 k
    MariaDB-compat      x86_64      10.1.7-1.el7.centos         mariadb      1.4 M
    MariaDB-devel       x86_64      10.1.7-1.el7.centos         mariadb      6.5 M
    MariaDB-shared      x86_64      10.1.7-1.el7.centos         mariadb      1.3 M
    Installing for dependencies:
    jemalloc            x86_64      3.6.0-1.el7                 epel         105 k
    
    Transaction Summary
    ================================================================================
    Install  1 Package  (+1 Dependent package)
    Upgrade  5 Packages
    
    Total download size: 143 M
    Downloading packages:
    Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
    --------------------------------------------------------------------------------
    Total                                              3.5 MB/s | 143 MB  00:41  
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    Warning: RPMDB altered outside of yum.
      Updating   : MariaDB-common-10.1.7-1.el7.centos.x86_64                   1/12
      Updating   : MariaDB-client-10.1.7-1.el7.centos.x86_64                   2/12
      Installing : jemalloc-3.6.0-1.el7.x86_64                                 3/12
      Installing : MariaDB-server-10.1.7-1.el7.centos.x86_64                   4/12
      Updating   : MariaDB-devel-10.1.7-1.el7.centos.x86_64                    5/12
      Updating   : MariaDB-compat-10.1.7-1.el7.centos.x86_64                   6/12
      Updating   : MariaDB-shared-10.1.7-1.el7.centos.x86_64                   7/12
      Cleanup    : MariaDB-devel-10.0.17-1.el7.centos.x86_64                   8/12
      Cleanup    : MariaDB-shared-10.0.17-1.el7.centos.x86_64                  9/12
      Cleanup    : MariaDB-compat-10.0.17-1.el7.centos.x86_64                 10/12
      Cleanup    : MariaDB-client-10.0.17-1.el7.centos.x86_64                 11/12
      Cleanup    : MariaDB-common-10.0.17-1.el7.centos.x86_64                 12/12
      Verifying  : MariaDB-server-10.1.7-1.el7.centos.x86_64                   1/12
      Verifying  : MariaDB-devel-10.1.7-1.el7.centos.x86_64                    2/12
      Verifying  : MariaDB-client-10.1.7-1.el7.centos.x86_64                   3/12
      Verifying  : MariaDB-common-10.1.7-1.el7.centos.x86_64                   4/12
      Verifying  : jemalloc-3.6.0-1.el7.x86_64                                 5/12
      Verifying  : MariaDB-compat-10.1.7-1.el7.centos.x86_64                   6/12
      Verifying  : MariaDB-shared-10.1.7-1.el7.centos.x86_64                   7/12
      Verifying  : MariaDB-common-10.0.17-1.el7.centos.x86_64                  8/12
      Verifying  : MariaDB-shared-10.0.17-1.el7.centos.x86_64                  9/12
      Verifying  : MariaDB-compat-10.0.17-1.el7.centos.x86_64                 10/12
      Verifying  : MariaDB-devel-10.0.17-1.el7.centos.x86_64                  11/12
      Verifying  : MariaDB-client-10.0.17-1.el7.centos.x86_64                 12/12
    
    Installed:
      MariaDB-server.x86_64 0:10.1.7-1.el7.centos                                
    
    Dependency Installed:
      jemalloc.x86_64 0:3.6.0-1.el7                                              
    
    Updated:
      MariaDB-client.x86_64 0:10.1.7-1.el7.centos                                
      MariaDB-common.x86_64 0:10.1.7-1.el7.centos                                
      MariaDB-compat.x86_64 0:10.1.7-1.el7.centos                                
      MariaDB-devel.x86_64 0:10.1.7-1.el7.centos                                 
      MariaDB-shared.x86_64 0:10.1.7-1.el7.centos                                
    
    Complete!
    
    real    1m11.911s
    user    0m31.329s
    sys     0m3.876s
    
    Code:
    *************************************************
    * Adjust old MariaDB 10.x /etc/my.cnf
      for MariaDB 10.1.x my.cnf compatibility
    *************************************************
    
    systemctl start mysql.service
    systemctl restart mysql.service
    total 269M
    -rw-rw----. 1 mysql mysql    0 Apr  3 02:00 multi-master.info
    drwx--x--x. 2 mysql mysql 4.0K Apr  3 02:00 mysql
    drwx------. 2 mysql mysql 4.0K Apr  3 02:00 performance_schema
    -rw-r--r--. 1 mysql mysql   15 Apr  3 02:00 mysql_upgrade_info
    -rw-r-----. 1 mysql mysql 1.8K Apr  3 02:00 centos7.localdomain.err
    -rw-rw----. 1 mysql mysql 128K Apr  3 02:00 ib_logfile1.gz
    -rw-rw----. 1 mysql mysql 128K Apr  3 02:00 ib_logfile0.gz
    -rw-rw----. 1 mysql mysql 128M Apr  3 02:00 ib_logfile1
    -rw-rw----. 1 mysql mysql   52 Sep  9 22:12 aria_log_control
    -rw-rw----. 1 mysql mysql  16K Sep  9 22:12 aria_log.00000001
    -rw-rw----  1 mysql mysql  872 Sep  9 22:12 ib_buffer_pool
    -rw-rw----. 1 mysql mysql  12M Sep  9 22:14 ibdata1
    -rw-rw----. 1 mysql mysql 128M Sep  9 22:14 ib_logfile0
    -rw-rw----  1 mysql mysql  24K Sep  9 22:14 tc.log
    srwxrwxrwx  1 mysql mysql    0 Sep  9 22:14 mysql.sock
    -rw-rw----  1 mysql mysql    5 Sep  9 22:14 centos7.localdomain.pid
    
    Code:
    mysql_upgrade --verbose
    Looking for 'mysql' as: mysql
    Looking for 'mysqlcheck' as: mysqlcheck
    Phase 1/6: 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/6: Fixing views
    Processing databases
    information_schema
    mysql
    performance_schema
    Phase 3/6: Running 'mysql_fix_privilege_tables'
    Phase 4/6: Fixing table and database names
    Processing databases
    information_schema
    mysql
    performance_schema
    Phase 5/6: Checking and upgrading tables
    Processing databases
    information_schema
    performance_schema
    Phase 6/6: Running 'FLUSH PRIVILEGES'
    OK
    
    Code:
    ------------------------------------------------
    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 |
    +---------------------------+------------------------+
    
    Code:
    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     |
    | XTRADB_READ_VIEW              | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | XTRADB_INTERNAL_HASH_TABLES   | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | XTRADB_RSEG                   | ACTIVE   | INFORMATION SCHEMA | 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_CHANGED_PAGES          | 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     |
    | CHANGED_PAGE_BITMAPS          | ACTIVE   | INFORMATION SCHEMA | NULL                   | GPL     |
    | SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | FEEDBACK                      | DISABLED | 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     |
    +-------------------------------+----------+--------------------+------------------------+---------+
    
    Code:
    mysql -t -e "SHOW ENGINES;"
    +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
    | Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
    +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
    | MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |
    | CSV                | YES     | CSV storage engine                                                                               | NO           | NO   | NO         |
    | Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
    | MyISAM             | DEFAULT | MyISAM storage engine                                                                            | NO           | NO   | NO         |
    | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
    | InnoDB             | YES     | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
    | SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | YES  | YES        |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
    +--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
    systemctl restart mysql.service
    
    
    ------------------------------------------------
    MariaDB 10.1.x Upgrade completed
    ------------------------------------------------
    
    Code:
    mysqladmin  ver
    mysqladmin  Ver 9.1 Distrib 10.1.7-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.7-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 6 min 47 sec
    
    Threads: 1  Questions: 1  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 11  Queries per second avg: 0.002
    Once updated to MariaDB 10.1, you can use regular yum update to update minor versions within MariaDB 10.1.x branch
    Code:
    yum update MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
     
    Last edited: Sep 10, 2015
    • Like Like x 1
    • Winner Winner x 1
  5. pamamolf

    pamamolf Well-Known Member

    2,533
    231
    63
    May 31, 2014
    Ratings:
    +394
    Local Time:
    11:41 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    • Like Like x 1
  6. eva2000

    eva2000 Administrator Staff Member

    29,035
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    6:41 AM
    Nginx 1.13.x
    MariaDB 5.5
    • Informative Informative x 1
  7. pamamolf

    pamamolf Well-Known Member

    2,533
    231
    63
    May 31, 2014
    Ratings:
    +394
    Local Time:
    11:41 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    No automated tricks for this using Centminmod? :)
     
  8. eva2000

    eva2000 Administrator Staff Member

    29,035
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    6:41 AM
    Nginx 1.13.x
    MariaDB 5.5
    all manual !