Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SOLVED MariaDB 10.2 new install, missing tokudb and jemalloc

Discussion in 'Database Discussion' started by iso99, Jun 27, 2018.

  1. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    112
    Likes Received:
    7
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    I got a new server provisioned and upgraded to MariaDB10.2, however it seems that tokudb is not included by default.

    I had to install MariaDB-tokudb-engine first. It worked for a few days.

    Also, I'm now getting a "TokuDB is not initialized because jemalloc is not loaded".

    ------ EDIT

    cPanel upcp update somehow broke it with

    [2018-06-27 02:10:13 +0800] [/usr/local/cpanel/scripts/rpmup] ---> Package MariaDB-tokudb-engine.x86_64 0:10.2.15-1.el7.centos will be updated
    [2018-06-27 02:10:13 +0800] [/usr/local/cpanel/scripts/rpmup] ---> Package MariaDB-tokudb-engine.x86_64 0:10.2.16-1.el7.centos will be an update

    Thank you.
     
    #1 iso99, Jun 27, 2018
    Last edited: Jun 27, 2018
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,888
    Likes Received:
    90
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    Can you try the below command on your server:
    # yum install jemalloc*
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    112
    Likes Received:
    7
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Package jemalloc-3.6.0-1.el7.x86_64 already installed and latest version
    Resolving Dependencies
    --> Running transaction check
    ---> Package jemalloc-devel.x86_64 0:3.6.0-1.el7 will be installed


     
  4. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,530
    Likes Received:
    253
    Trophy Points:
    193
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @iso99

    Can you walk me through the steps you took to install mariadb and tokudb? I'd like to try to replicate the issues you experienced on a test server.

    Also can you let me know if installing jemalloc resolved the issue for you?

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    112
    Likes Received:
    7
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Hi,

    I used the MySQL upgrade in WHM to install MariaDB. 10.2 was the only option in Centos 7.

    It turns out Tokudb is not supported by default, so I had to use install by yum ("yum install MariaDB-tokudb-engine").

    Working properly before the update mentioned.

    It's now working but I had a 3rd-party did it, will ask on the procedures so you can replicate.

    Thank you.
     
  6. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,756
    Likes Received:
    87
    Trophy Points:
    353
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    112
    Likes Received:
    7
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Yep, that's correct. Just to be clear, installing tokudb made TokuDB work. But after the update, the jemalloc issue appeared. Installing jemalloc did not fix since it was there already.

    I'm not sure yet on how to replicate the fix though,I asked someone to do it.

    ----- EDIT

    OK we found it,

    Added this

    Code:
    [Service]
    Environment="LD_PRELOAD=/usr/lib64/libjemalloc.so.1"
    
    on /etc/systemd/system/mariadb.service.d/tokudb.conf


    Reference: https://mariadb.com/kb/en/library/systemd/
     
    #7 iso99, Jul 21, 2018
    Last edited: Jul 21, 2018
  8. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,530
    Likes Received:
    253
    Trophy Points:
    193
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @iso99

    Thank you very much for your explanation on how you resolved this issue. I'm glad to see it's working as intended for you now.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice