Discover Centmin Mod today
Register Now

MariaDB MariaDB 10.2.6 Stable now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, May 24, 2017.

  1. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.6 Stable (GA). This is the first stable (GA) release in the MariaDB 10.2 series. See the What is MariaDB 10.2? page for more details on the new features in MariaDB 10.2. Download MariaDB 10.2.6 Release Notes Changelog What is MariaDB 10.2? MariaDB […]

    The post MariaDB 10.2.6 Stable now available appeared first on MariaDB.org.

    Continue reading...
     
  2. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    So looks like MariaDB 10.2.26 is GA stable release. Centmin Mod 123.09beta01 will probably wait another 4-6 releases before making it optionally available upgrade via centmin.sh menu option 11, submenu option 6
    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: 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). Back to Main menu
    --------------------------------------------------------
    Enter option [ 0 - 7 ] 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
    
    !!  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):
        __  __               _         ____   ____    _   ___     ____          
       |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ \    __  __
       | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    __) |   \ \/ /
       | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  / __/  _  >  < 
       |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|_____|(_)/_/\_\
                                                                                 
               ____                       ____         _                
              |  _ \  ___  _ __    ___   / ___|   ___ | |_  _   _  _ __  
              | |_) |/ _ \| '_ \  / _ \  \___ \  / _ \| __|| | | || '_ \ 
              |  _ <|  __/| |_) || (_) |  ___) ||  __/| |_ | |_| || |_) |
              |_| \_\\___|| .__/  \___/  |____/  \___| \__| \__,_|| .__/ 
                          |_|                                     |_|    
    *************************************************
    MariaDB 10.2.x Repo setup...
    *************************************************
    
    Loaded plugins: fastestmirror, priorities
    Cleaning repos: base epel extras mariadb rpmforge updates varnish-4.1
    Cleaning up everything
    Cleaning up list of fastest mirrors
    rpm --import http://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
    *************************************************
    
    Installed Packages
    MariaDB-client.x86_64               10.1.23-1.el7.centos                @mariadb
    MariaDB-common.x86_64               10.1.23-1.el7.centos                @mariadb
    MariaDB-compat.x86_64               10.1.23-1.el7.centos                @mariadb
    MariaDB-devel.x86_64                10.1.23-1.el7.centos                @mariadb
    MariaDB-shared.x86_64               10.1.23-1.el7.centos                @mariadb
    Available Packages
    MariaDB-client.x86_64               10.2.6-1.el7.centos                 mariadb 
    MariaDB-common.x86_64               10.2.6-1.el7.centos                 mariadb 
    MariaDB-compat.x86_64               10.2.6-1.el7.centos                 mariadb 
    MariaDB-devel.x86_64                10.2.6-1.el7.centos                 mariadb 
    MariaDB-server.x86_64               10.2.6-1.el7.centos                 mariadb 
    MariaDB-shared.x86_64               10.2.6-1.el7.centos                 mariadb 
    mariadb-devel.x86_64                1:5.5.52-1.el7                      base    
    mariadb-server.x86_64               1:5.5.52-1.el7                      base    
    
    real    0m21.621s
    user    0m4.872s
    sys     0m0.932s
        __  __               _         ____   ____    _   ___     ____          
       |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   |___ \    __  __
       | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |    __) |   \ \/ /
       | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_  / __/  _  >  < 
       |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|_____|(_)/_/\_\
                                                                                 
                            ___              _          _  _ 
                           |_ _| _ __   ___ | |_  __ _ | || |
                            | | | '_ \ / __|| __|/ _` || || |
                            | | | | | |\__ \| |_| (_| || || |
                           |___||_| |_||___/ \__|\__,_||_||_|
                                                             
    
    *************************************************
    MariaDB 10.2.x YUM install...
    yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel
    *************************************************
    
    Loaded plugins: fastestmirror, priorities
    Loading mirror speeds from cached hostfile
     * base: mirror.aarnet.edu.au
     * extras: centos.mirror.digitalpacific.com.au
     * rpmforge: mirror.ventraip.net.au
     * updates: mirror.aarnet.edu.au
    17 packages excluded due to repository priority protections
    Resolving Dependencies
    --> Running transaction check
    ---> Package MariaDB-client.x86_64 0:10.1.23-1.el7.centos will be updated
    ---> Package MariaDB-client.x86_64 0:10.2.6-1.el7.centos will be an update
    ---> Package MariaDB-common.x86_64 0:10.1.23-1.el7.centos will be updated
    ---> Package MariaDB-common.x86_64 0:10.2.6-1.el7.centos will be an update
    ---> Package MariaDB-compat.x86_64 0:10.1.23-1.el7.centos will be updated
    ---> Package MariaDB-compat.x86_64 0:10.2.6-1.el7.centos will be an update
    ---> Package MariaDB-devel.x86_64 0:10.1.23-1.el7.centos will be updated
    ---> Package MariaDB-devel.x86_64 0:10.2.6-1.el7.centos will be an update
    ---> Package MariaDB-server.x86_64 0:10.2.6-1.el7.centos will be installed
    ---> Package MariaDB-shared.x86_64 0:10.1.23-1.el7.centos will be updated
    ---> Package MariaDB-shared.x86_64 0:10.2.6-1.el7.centos will be an update
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ================================================================================
     Package             Arch        Version                     Repository    Size
    ================================================================================
    Installing:
     MariaDB-server      x86_64      10.2.6-1.el7.centos         mariadb      108 M
    Updating:
     MariaDB-client      x86_64      10.2.6-1.el7.centos         mariadb       48 M
     MariaDB-common      x86_64      10.2.6-1.el7.centos         mariadb      197 k
     MariaDB-compat      x86_64      10.2.6-1.el7.centos         mariadb      2.8 M
     MariaDB-devel       x86_64      10.2.6-1.el7.centos         mariadb      6.7 M
     MariaDB-shared      x86_64      10.2.6-1.el7.centos         mariadb      387 k
    
    Transaction Summary
    ================================================================================
    Install  1 Package
    Upgrade  5 Packages
    
    Total download size: 166 M
    Downloading packages:
    No Presto metadata available for mariadb
    --------------------------------------------------------------------------------
    Total                                              7.3 MB/s | 166 MB  00:22    
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    Warning: RPMDB altered outside of yum.
      Updating   : MariaDB-common-10.2.6-1.el7.centos.x86_64                   1/11 
      Updating   : MariaDB-compat-10.2.6-1.el7.centos.x86_64                   2/11 
      Updating   : MariaDB-client-10.2.6-1.el7.centos.x86_64                   3/11 
      Installing : MariaDB-server-10.2.6-1.el7.centos.x86_64                   4/11 
      Updating   : MariaDB-shared-10.2.6-1.el7.centos.x86_64                   5/11 
      Updating   : MariaDB-devel-10.2.6-1.el7.centos.x86_64                    6/11 
      Cleanup    : MariaDB-devel-10.1.23-1.el7.centos.x86_64                   7/11 
      Cleanup    : MariaDB-client-10.1.23-1.el7.centos.x86_64                  8/11 
      Cleanup    : MariaDB-compat-10.1.23-1.el7.centos.x86_64                  9/11 
      Cleanup    : MariaDB-shared-10.1.23-1.el7.centos.x86_64                 10/11 
      Cleanup    : MariaDB-common-10.1.23-1.el7.centos.x86_64                 11/11 
      Verifying  : MariaDB-shared-10.2.6-1.el7.centos.x86_64                   1/11 
      Verifying  : MariaDB-compat-10.2.6-1.el7.centos.x86_64                   2/11 
      Verifying  : MariaDB-client-10.2.6-1.el7.centos.x86_64                   3/11 
      Verifying  : MariaDB-devel-10.2.6-1.el7.centos.x86_64                    4/11 
      Verifying  : MariaDB-common-10.2.6-1.el7.centos.x86_64                   5/11 
      Verifying  : MariaDB-server-10.2.6-1.el7.centos.x86_64                   6/11 
      Verifying  : MariaDB-shared-10.1.23-1.el7.centos.x86_64                  7/11 
      Verifying  : MariaDB-compat-10.1.23-1.el7.centos.x86_64                  8/11 
      Verifying  : MariaDB-common-10.1.23-1.el7.centos.x86_64                  9/11 
      Verifying  : MariaDB-client-10.1.23-1.el7.centos.x86_64                 10/11 
      Verifying  : MariaDB-devel-10.1.23-1.el7.centos.x86_64                  11/11 
    
    Installed:
      MariaDB-server.x86_64 0:10.2.6-1.el7.centos                                  
    
    Updated:
      MariaDB-client.x86_64 0:10.2.6-1.el7.centos                                  
      MariaDB-common.x86_64 0:10.2.6-1.el7.centos                                  
      MariaDB-compat.x86_64 0:10.2.6-1.el7.centos                                  
      MariaDB-devel.x86_64 0:10.2.6-1.el7.centos                                    
      MariaDB-shared.x86_64 0:10.2.6-1.el7.centos                                  
    
    Complete!
    
    real    1m14.316s
    user    0m53.758s
    sys     0m6.295s
    
    *************************************************
    * Adjust old MariaDB 10.x /etc/my.cnf 
      for MariaDB 10.2.x my.cnf compatibility 
    *************************************************
    

    Code (Text):
    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     |
    | SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | Aria                          | ACTIVE   | STORAGE ENGINE     | NULL                   | GPL     |
    | user_variables                | ACTIVE   | INFORMATION SCHEMA | 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 (Text):
    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             | YES     | MyISAM storage engine                                                            | 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        |
    | SEQUENCE           | YES     | Generated tables filled with sequential values                                   | YES          | NO   | YES        |
    | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                               | NO           | NO   | NO         |
    +--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
    

    Code (Text):
    mysqladmin  Ver 9.1 Distrib 10.2.6-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.2.6-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 0 sec
    
    Threads: 5  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 11  Queries per second avg: 0.000
    

     
    Last edited: May 24, 2017
    • Winner Winner x 1
  3. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    FYI, fixed bugs for MariaDB 10.2.7 and 10.2.8 next 2 releases just to give you an idea of bug fixes to come after MariaDB 10.2.26 GA stable release. MariaDB 10.2.7 & 10.2.8 Fixed
     
  4. Revenge

    Revenge Active Member

    398
    84
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +297
    Local Time:
    4:16 AM
    1.9.x
    10.1.x
    Most of those bugs are also present in the current 5.5, 10.0 and 10.1 branch.

    Already updated my test server and its running really fine with IPS. Im going to upgrade my live server since its stable branch now.
     
    • Informative Informative x 1
  5. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Yeah just being cautious, as pretty sure 99.99% of Centmin Mod users don't fully know how to rollback MariaDB versions if they did come across critical show stopper bugs :)
     
    • Agree Agree x 1
  6. pamamolf

    pamamolf Well-Known Member

    3,108
    294
    83
    May 31, 2014
    Ratings:
    +529
    Local Time:
    6:16 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    MyRocks anyone on this? :)
     
  7. Revenge

    Revenge Active Member

    398
    84
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +297
    Local Time:
    4:16 AM
    1.9.x
    10.1.x
    MariaDB 10.2.7 is available to update in the official repo.
    They did not made the announcement yet.
     
    • Informative Informative x 1
  8. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    cheers @Revenge :)
     
  9. Simon Brown

    Simon Brown Premium Member Premium Member

    25
    2
    3
    Feb 9, 2017
    Ratings:
    +10
    Local Time:
    4:16 AM
    1.11.9
    FYI everyone. If you've setup a Galera Cluster and use xtrabackup it's no longer compatible MeriaDB 10.1. You'll have to use mariabackup (MariaDB-backup).

    *cough* the sooner Centmin makes the jump to 10.2 the better.. At least give people the option to upgrade while still using the 10.1 as default :)
     
    • Informative Informative x 1
  10. pamamolf

    pamamolf Well-Known Member

    3,108
    294
    83
    May 31, 2014
    Ratings:
    +529
    Local Time:
    6:16 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    MariaDB backup tool instructions on the net (at least most of them) are wrong as they provide info to get a simple database backup and then they recommend to delete the mysql folder and when you restore the default mysql database is missing and it doesn't work.....

    For full backup of all databases it works.....

    But that's a test that i did a few months ago and there was not many working tutorials online :)

    It should be easy as backup, prepare and restore..... but that's not was the case at least for me... :(
     
  11. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    thanks for heads up
    if you want to test on test server you can enable the centmin mod 123.09beta01 mariadb 10.2 upgrade routine submenu - still undergoing testing and tuning for the mariadb 10.2 upgrade routine though
    makes sense if you think about it, if you delete /var/lib/mysql data directory the default mysql system tables will be gone so restoring just a database backup won't have mysql system database tables
     
  12. pamamolf

    pamamolf Well-Known Member

    3,108
    294
    83
    May 31, 2014
    Ratings:
    +529
    Local Time:
    6:16 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Ok i will try it again and see by deleting only the database folder name....

    Should i delete the ibdata1, ib_logfile0, ib_logfile1 files from mysql path or the backup is only related to the files inside the database folder name?
     
  13. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    No no don't delete individual databases data files as it's a sure way of corrupting your databases and screwing up mysql server
     
  14. pamamolf

    pamamolf Well-Known Member

    3,108
    294
    83
    May 31, 2014
    Ratings:
    +529
    Local Time:
    6:16 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Ok i got it for the mysql files like ibdata1, ib_logfile0, ib_logfile1 but it will restore the database without clearing first the old files from ?

    Don't know why this one is confusing me so much ....

    I thought it was like mysqldump that you must delete the existing data first to restore.....

    I am using for backup:
    then:
    and i am confused about the restore part.... :(
     
    Last edited: Mar 10, 2018
  15. eva2000

    eva2000 Administrator Staff Member

    34,591
    7,653
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,770
    Local Time:
    1:16 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Don't touch that you will wipe your innodb database data or screw stuff up too. InnoDB databases unlike MyISAM do not like to have their data files in /var/lib/mysql messed with manually outside of proper handling procedures outlined in official manual at MySQL :: MySQL 5.6 Reference Manual :: 14 The InnoDB Storage Engine

    understanding and using MariaBackup is left up to end users to figure out. You should check official manual/documentation linked to at MariaDB Backup

    As MariaBackup is a fork of XtraBackup you might also want to read Percona official XtraBackup documentation at Percona XtraBackup - Documentation

    You may want to start your own MariaBackup thread in this sub forum to discuss with other forum users.

    FYI, both MariaBackup and XtraBackup are ideally made for full all databases and mysql system database backup and restores - it's all or nothing approach. While individual databases maybe supported, these tools are made for all databases backup and restore due to nature of InnoDB databases. If one InnoDB database has real issues that repairing can't fix, then usually only solution is you have backed up all databases frequently so need to restore all databases on the server and not just the InnoDB based database itself.
     
    • Informative Informative x 1
..