/ Register

Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB MariaDB 10.2.6 Stable now available

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

Tags:
Previous Thread Next Thread
Loading...
  1. May 24, 2017 #1
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. May 24, 2017 #2
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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
  3. May 24, 2017 #3
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. May 24, 2017 #4
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    3:59 PM
    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.
     
  5. May 24, 2017 #5
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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 :)
     
  6. Jun 1, 2017 #6
    pamamolf

    pamamolf Premium Member Premium Member

    4,077
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    5:59 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    MyRocks anyone on this? :)
     
  7. Jul 12, 2017 #7
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    3:59 PM
    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.
     
  8. Jul 13, 2017 #8
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    cheers @Revenge :)
     
  9. Mar 10, 2018 #9
    Simon Brown

    Simon Brown Member

    55
    6
    8
    Feb 9, 2017
    Ratings:
    +18
    Local Time:
    3:59 PM
    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 :)
     
  10. Mar 10, 2018 #10
    pamamolf

    pamamolf Premium Member Premium Member

    4,077
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    5:59 PM
    Nginx-1.25.x
    MariaDB 10.3.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. Mar 10, 2018 #11
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Mar 10, 2018 #12
    pamamolf

    pamamolf Premium Member Premium Member

    4,077
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    5:59 PM
    Nginx-1.25.x
    MariaDB 10.3.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. Mar 10, 2018 #13
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Mar 10, 2018 #14
    pamamolf

    pamamolf Premium Member Premium Member

    4,077
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    5:59 PM
    Nginx-1.25.x
    MariaDB 10.3.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. Mar 11, 2018 #15
    eva2000

    eva2000 Administrator Staff Member

    54,389
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    1:59 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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.
     
Previous Thread Next Thread
Loading...

.