Welcome to Centmin Mod Community
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

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:06 PM
    Nginx 1.13.x
    MariaDB 5.5
    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
    • Like Like x 2
  2. Matt

    Matt Moderator Staff Member

    697
    322
    63
    May 25, 2014
    Sheffield, UK
    Ratings:
    +449
    Local Time:
    10:06 AM
    1.7.1
    MariaDB 10
    Or like me, test it a few times, and just bite the bullet and do it on the live server in the end ;)
     
    • Like Like x 2
  3. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:06 PM
    Nginx 1.13.x
    MariaDB 5.5
    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
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    5:06 AM
  5. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:06 PM
    Nginx 1.13.x
    MariaDB 5.5
    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:
     
    • Like Like x 2
  6. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:06 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1
  7. pamamolf

    pamamolf Well-Known Member

    2,820
    253
    83
    May 31, 2014
    Ratings:
    +447
    Local Time:
    12:06 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Do you plan to do a benchmark test on 10.0.13 vs 5.x ?
     
  8. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:06 PM
    Nginx 1.13.x
    MariaDB 5.5
    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.
     
    • Like Like x 1
  9. RoldanLT

    RoldanLT Well-Known Member

    3,978
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    6:06 PM
    1.11
    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

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:06 PM
    Nginx 1.13.x
    MariaDB 5.5
  11. RoldanLT

    RoldanLT Well-Known Member

    3,978
    965
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,329
    Local Time:
    6:06 PM
    1.11
    10.2
    I cancel it it by pressing Ctrl+Z :D
    Then just re-run menu #11 > #3 :)
    Works now.
     
    • Like Like x 1
  12. eva2000

    eva2000 Administrator Staff Member

    30,953
    6,917
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,416
    Local Time:
    8:06 PM
    Nginx 1.13.x
    MariaDB 5.5
    ah yes that would work too :D