Want to subscribe to topics you're interested in?
Become a Member

MariaDB MariaDB 5.5 to 10 upgrade beta testing

Discussion in 'Beta release code' started by eva2000, Jun 12, 2014.

  1. eva2000

    eva2000 Administrator Staff Member

    50,455
    11,659
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,078
    Local Time:
    7:05 AM
    Nginx 1.25.x
    MariaDB 10.x
    Up until 1.2.3-eva2000.06 stable release the default MariaDB version is MariaDB 5.5 branch. MariaDB 10 branch will not be the default until at least MariaDB 10.0.13 release.

    However, for folks impatiently waiting for testing out MariaDB 10 Mysql, 1.2.3-eva2000.07 beta builds already have a new sub menu ready with a placeholder for MariaDB 5.5 to 10 upgrade process with an added option to re-enable the upgrade process.

    centminmod07_menurevision_11_mariadbupgrade.png

    I've added a switch variable just for testing MariaDB 5.5 to MariaDB 10 upgrade process. So yes default install is MariaDB 5.5 still, but you can test out the MariaDB 10 upgrade process by doing following steps:

    1. Ensure to test on test server and NOT live production site/server. Install centmin.sh menu #1 run to install

    2. After install, edit .07 beta's inc/mariadb_submenu.inc file and change variable ENABLE_MARIADBTENUPGRADE='n' to ENABLE_MARIADBTENUPGRADE='y'. Save file

    3. run centmin.sh again and now select menu option [HASHTAG]#11[/HASHTAG] to open the sub-menu and select sub-menu option #3 to do an upgrade from MariaDB 5.5 to 10. You will get a reminder prompt to backup all MySQL databases before starting. If you have no databases to backup or if it's a test server with data, just hit 'y' when asked if you have done your backups to proceed. Then the process will uninstall previous MariaDB 5.5 and install MariaDB 10 repo.

    Notes:
    1. The new process no longer installs MariaDB-test rpm package for the test database.
    2. On completion, you will be shown output for your MariaDB 10 plugin list etc and your /etc/my.cnf will have a new group [mariadb-10.0] with MariaDB 10 specific relevant mysql settings.
    3. MariaDB 10 is installed via official YUM repository so yum update can be used for updates i.e.
      Code:
      yum update MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared
      
    4. Again try this on test server with a copy of your site MySQL data and not live server first. I am still testing and will eventually have MariaDB 10 as default installed version for Centmin Mod.
    5. Full MariaDB 10 feature comparison at https://mariadb.com/blog/mariadb-10-vs-mysql-56-feature-comparison-update


     
    Last edited: Jun 12, 2014
  2. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    10:05 PM
    1.5.15
    MariaDB 10.2
    Or like me, test it a few times, and just bite the bullet and do it on the live server in the end ;)
     
  3. eva2000

    eva2000 Administrator Staff Member

    50,455
    11,659
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,078
    Local Time:
    7:05 AM
    Nginx 1.25.x
    MariaDB 10.x
    I tested on wable.com test VPS server fine

    Code:
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.0.11-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
    
    Server version          10.0.11-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 32 min 26 sec
    
    Threads: 1  Questions: 302  Slow queries: 0  Opens: 20  Flush tables: 1  Open tables: 83  Queries per second avg: 0.155
     
  4. Floren

    Floren Active Member

    148
    77
    28
    Jun 6, 2014
    Ratings:
    +77
    Local Time:
    5:05 PM
  5. eva2000

    eva2000 Administrator Staff Member

    50,455
    11,659
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,078
    Local Time:
    7:05 AM
    Nginx 1.25.x
    MariaDB 10.x
    Personally, I would like to see some of the critical, blocker and major bugs prior to 10.0.12/10.0.13 dealt with first https://mariadb.atlassian.net/issues/?filter=16602. Some are performance and scalability related :) I believe 10.0.12 will take care of a majority of them, but will see what 10.0.12 might introduce bug wise first.

    Basically, just me being overly cautious :unsure::LOL:
     
  6. eva2000

    eva2000 Administrator Staff Member

    50,455
    11,659
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,078
    Local Time:
    7:05 AM
    Nginx 1.25.x
    MariaDB 10.x
  7. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    12:05 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Do you plan to do a benchmark test on 10.0.13 vs 5.x ?
     
  8. eva2000

    eva2000 Administrator Staff Member

    50,455
    11,659
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,078
    Local Time:
    7:05 AM
    Nginx 1.25.x
    MariaDB 10.x
    Not anytime soon.. maybe if I have some more extended free time I eventually will. Proper benchmarks take along time to do.

    But MariaDB 10 is faster than MariaDB 5.5 from most tests I've seen depending on how MariaDB settings are tuned.
     
  9. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    5:05 AM
    Mainline
    10.2
    Hang on this step:
    upload_2014-10-7_14-23-1.png

    What could be the problem?
    This is DO Singapore server.
     
  10. eva2000

    eva2000 Administrator Staff Member

    50,455
    11,659
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,078
    Local Time:
    7:05 AM
    Nginx 1.25.x
    MariaDB 10.x
  11. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    5:05 AM
    Mainline
    10.2
    I cancel it it by pressing Ctrl+Z :D
    Then just re-run menu #11 > #3 :)
    Works now.
     
  12. eva2000

    eva2000 Administrator Staff Member

    50,455
    11,659
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,078
    Local Time:
    7:05 AM
    Nginx 1.25.x
    MariaDB 10.x
    ah yes that would work too :D