Join the community today
Become a Member

MariaDB MariaDB 10.1.13 and Connector/J 1.3.7 now available

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Mar 26, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.13, and MariaDB Connector/J 1.3.7. See the release notes and changelogs for details on these releases. Download MariaDB 10.1.13 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 1.3.7 Release Notes Changelog About MariaDB Connector/J […]

    The post MariaDB 10.1.13 and Connector/J 1.3.7 now available appeared first on MariaDB.org.


    Continue reading...
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Ah MariaDB 10.1.13 is upon us MariaDB 10.1.13 Release Notes - MariaDB Knowledge Base
     
  3. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    10:20 AM
    1.9.10
    10.1.11
    Upgraded, thanks!
     
  4. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    3:20 PM
    Mainline
    10.2
    Well I have a bad luck this time, I am updating my own server running this command:
    Code:
    yum clean all
    yum update -y
    systemctl daemon-reload
    service mysql restart
    On the 1st,2nd stage of still downloading the updated RPMs, suddenly my Electricity suddenly switch off for 1-2 minutes.
    Then when it came back, I login again to SSH and try to restart Mysql and it restart fine though with 10.1.13 version.

    I'm still worried as some packages might be corrupt?
    I tried to run yum update again and there's no more update to download.
    Any advice? :|
     
  5. eva2000

    eva2000 Administrator Staff Member

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    check your yum history list
    Code (Text):
    yum history list MariaDB-server
    Loaded plugins: fastestmirror, priorities, security
    ID     | Login user               | Date and time    | Action(s)      | Altered
    -------------------------------------------------------------------------------
        23 | root <root>              | 2016-03-25 23:57 | Update         |    7 EE
        11 | root <root>              | 2016-03-25 07:41 | I, O           |    8 EE
    history list

    Code (Text):
    yum history info 23
    Loaded plugins: fastestmirror, priorities, security
    Transaction ID : 23
    Begin time     : Fri Mar 25 23:57:58 2016
    Begin rpmdb    : 525:f57b84d6e75afcbcd5dcae58448c082f45f24ca5
    End time       :            23:58:31 2016 (33 seconds)
    End rpmdb      : 525:ae0d9193be628ffd13a0ae91ab0b34fd27aa9304
    User           : root <root>
    Return-Code    : Success
    Command Line   : -y update
    Transaction performed with:
        Installed     rpm-4.8.0-47.el6.x86_64                       installed
        Installed     yum-3.2.29-69.el6.centos.noarch               installed
        Installed     yum-plugin-fastestmirror-1.1.30-30.el6.noarch installed
    Packages Altered:
        Updated MariaDB-client-10.1.12-1.el6.x86_64 @mariadb
        Update                 10.1.13-1.el6.x86_64 @mariadb
        Updated MariaDB-common-10.1.12-1.el6.x86_64 @mariadb
        Update                 10.1.13-1.el6.x86_64 @mariadb
        Updated MariaDB-compat-10.1.12-1.el6.x86_64 @mariadb
        Update                 10.1.13-1.el6.x86_64 @mariadb
        Updated MariaDB-devel-10.1.12-1.el6.x86_64  @mariadb
        Update                10.1.13-1.el6.x86_64  @mariadb
        Updated MariaDB-server-10.1.12-1.el6.x86_64 @mariadb
        Update                 10.1.13-1.el6.x86_64 @mariadb
        Updated MariaDB-shared-10.1.12-1.el6.x86_64 @mariadb
        Update                 10.1.13-1.el6.x86_64 @mariadb
        Updated galera-25.3.14-1.rhel6.el6.x86_64   @mariadb
        Update         25.3.15-1.rhel6.el6.x86_64   @mariadb
    Scriptlet output:
       1 Shutting down MySQL.. SUCCESS!
       2 Starting MySQL. SUCCESS!
    history info
     
  6. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    10:20 AM
    1.9.10
    10.1.11
    SSH jobs run in background. So, it is free from your personal computer. I think it upgraded.
     
  7. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    3:20 PM
    Mainline
    10.2
     
  8. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    10:20 AM
    1.9.10
    10.1.11
    It says 16 upgraded component so it has upgraded :)
     
  9. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    3:20 PM
    Mainline
    10.2
    My Wife Sister suddenly switch off the extension which has the modem injected... woohh!

    Thanks Guys, I'm relieve now :)
     
  10. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    3:20 PM
    Mainline
    10.2
    Thanks @eva2000 an @negative :)
     
  11. Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    2:20 AM
    my mariaDB is still at 10.0.24-1 even after yum clean/update :(
     
  12. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    10:20 AM
    1.9.10
    10.1.11
    You must switch first to mariadb 10.1 from 10.0 with centmin menu #11 then #5
     
  13. eva2000

    eva2000 Administrator Staff Member

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yes 123.09beta01 only later defaulted to MariaDB 10.1, so you need to use upgrade submenu option like @negative mentioned

    see post listed here
    Code (Text):
    --------------------------------------------------------
            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 (Text):
    --------------------------------------------------------------------------------
    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
     
  14. negative

    negative Active Member

    415
    50
    28
    Apr 11, 2015
    Ratings:
    +98
    Local Time:
    10:20 AM
    1.9.10
    10.1.11
    And don't worry while moving! It will switch your databases without any problem.

    @eva2000 build it perfectly same as everything on centmin :D:ROFLMAO:
     
  15. eva2000

    eva2000 Administrator Staff Member

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    still backup mysql database via mysqldump - never can be too safe for data :D
     
  16. Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    2:20 AM
    Do you want to continue with upgrade to MariaDB 10.1.x ? [y/n] y

    checking mysql root password works in /root/.my.cnf
    mysqladmin ver
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'

    mysql root user password in /root/.my.cnf is not correct
     
  17. eva2000

    eva2000 Administrator Staff Member

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    did you change your mysql root pass from one listed in /root/.my.cnf ?

    in SSH command line does this command work ?
    Code (Text):
    mysqladmin ver

    example output
    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.1.13-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.1.13-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 12 hours 51 min 49 sec
    
     
  18. Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    2:20 AM
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'

    I don't remember changing it since I use a different pass to connect to my XF database.
     
  19. eva2000

    eva2000 Administrator Staff Member

    55,163
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    5:20 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Probably best to reset mysql root password - instructions at Recovering a lost mysql root password | Centmin Mod Community (just remove the sudo command) and then change password listed in /root/.my.cnf after you followed those instructions.

    confirm with command should return output without need for mysql root details
    Code (Text):
    mysqladmin ver