Want more timely Centmin Mod News Updates?
Become a Member

AXIVO Repository Maintainer

Discussion in 'Introductions' started by Floren, Jun 12, 2014.

  1. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    11:51 AM
    Hi all,

    I just wanted to introduce myself as the AXIVO repo maintainer. I see that it was added recently into Centminmod loop.
     
    • Like Like x 3
  2. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    Hey @Floren welcome and thanks for AXIVO repo (y)
     
  3. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    11:51 PM
    latest
    latest
  4. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    @dorobo, it's okay to have a personal preference in how you want to setup your environment, some folks like a pure RPM setup while others like myself don't mind mixing it up (source compile + RPM when better suited i.e. MariaDB) :)
     
  5. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    11:51 PM
    latest
    latest
    @eva2000 this is interesting
     
    • Like Like x 1
  6. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    11:51 AM
    Those tests were done by George aka @eva2000. I remember the days we worked together to get those stats out, althought he did all the heavy lifting, I simply provided the compile options. George knows his stuff related to MySQL. :)
    Mariadb 10 is the way to go though, I did few days ago some basic benchmarks related to cache and the results are amazing in 10. George, any plans to implement 10 into your project? If yes, be aware that you will need cmake 2.8.12.2, jemalloc 3.6.0, PCRE 8.35 and OpenSSL 1.0.1h as requirements.
     
    Last edited: Jun 12, 2014
    • Like Like x 1
  7. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    11:51 PM
    latest
    latest
    I'm going to try this.
     
  8. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    Oh that reference from @Floren is based on the benchmarks I did 3+ years ago with MariaDB 5.2 branch at the time at http://vbtechsupport.com/715/ and doesn't necessarily translate to MariaDB 5.5/10 nor does the comparison of improvement to newer Percona 5.5/5.6.

    Only way to be 100% sure is to redo all comparison tests across MariaDB 5.5/10, Percona 5.5/5.6 and Oracle MySQL 5.5/5.6 for official RPM packages and Intel/compiler optimised packages. The reason being as there have been HEAPS of performance improvements across MariaDB, Percona and Oracle (i.e. 5.6) in the last 3yrs so performance improvements found in my benchmarks at http://vbtechsupport.com/715/ would only be applicable to the versions tested at that time :)

    But yes MariaDB 10 is the future. Just waiting till around 10.0.13 before it becomes Centmin Mod default version
     
    • Like Like x 1
  9. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    11:51 AM
    If you have time, please do a comparison between MariaDB 10 (AXIVO build) and official rpm's, I'm sure it will be a big difference like last time. I will provide you my compile specs so you can use them in your Centminmod project for testing and implementation. It will be great if we can work again together on this. :)

    The jemalloc implementation I have makes MariaDB roll on steroids, you will see. If you have time, check also the XtraBackup package I built specifically for MariaDB 10.
     
    • Like Like x 1
  10. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah need to find the time to revisit comparison tests as it's been a long time since those benchmarks were done. So yeah if you can provide the compile specs and can look into this. Just need to find the time as it was a huge undertaking the last time I did this and I got a bit obsessed with testing as it went on LOL.

    AFAIK, MariaDB 5.5.33 and onwards already used jemalloc https://blog.mariadb.org/mariadb-5-5-33-now-available/. From MariaDB 5.5.33 release notes

     
    Last edited: Jun 12, 2014
  11. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    11:51 AM
    Ya, they have their own bundled package. However, if you use the system jemalloc (available on AXIVO) you can further enhance MariaDB performance in 2 places: build time (cmake) and executable in production. Contact me when you are ready to work on this, I will provide you all details.
     
    • Like Like x 1
  12. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah I'm waiting till MariaDB 10.0.13 for some of the additional fixes before I use it as default for Centmin Mod https://mariadb.atlassian.net/issues/?filter=16602. So will hit you up sooner rather than later for details in preparation :)

    Regarding Xtrabackup, specifically asked Percona folks about Xtrabackup compiled against XtraDB engine as opposed to the default InnoDB plugin and whether there are any functional/feature related improvements or differences and they said there is none, it's just a personal preference as to which to compile against - the features and functions of Xtrabackup themselves are the same regardless if it's compiled against XtraDB or InnoDB plugin.
     
    • Like Like x 1
  13. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    Missed that question, yeah next .07 release has the menu option placeholder already in place and some folks can test the upgrade process https://community.centminmod.com/threads/mariadb-5-5-to-10-upgrade-beta-testing.454/ but Centmin Mod won't have MariaDB 10 default installed until MariaDB 10.0.13 is released at least.
     
  14. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    11:51 AM
    For MariaDB 10, the required compile option is innodb56 in XtraBackup. Since I only provide MariaDB 10 into repository, I deleted the other XtraBackup binaries to avoid confusion:
    Code:
    rpm -qpl xtrabackup-2.1.9-1.el6.x86_64.rpm
    /usr/bin/innobackupex
    /usr/bin/innobackupex-1.5.1
    /usr/bin/xbcrypt
    /usr/bin/xbstream
    /usr/bin/xtrabackup
    /usr/share/doc/xtrabackup-2.1.9
    /usr/share/doc/xtrabackup-2.1.9/COPYING
     
  15. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    oh so you removed MariaDB 5.5 completely from your repo ?
     
  16. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    11:51 AM
    • Like Like x 1
  17. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
  18. Floren

    Floren Active Member

    148
    76
    28
    Jun 6, 2014
    Ratings:
    +76
    Local Time:
    11:51 AM
    Ya, I installed RHEL7 yesterday at work (mostly for Docker) but did not fiddled with it. Looks like it will blow everyone's mind, performance wise... at least on Proliant G8's. I know you are addicted on this. :D
    https://www.axivo.com/articles/red-hat-7-released.18/
     
    • Like Like x 1
  19. eva2000

    eva2000 Administrator Staff Member

    27,811
    6,347
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,365
    Local Time:
    1:51 AM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah performance is always on my mind :D