The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Installing innodb on an existing server

Discussion in 'General Discussion' started by Ashioni, Mar 16, 2010.

?

Do you use innodb?

Poll closed May 15, 2010.
  1. Yes

    5 vote(s)
    71.4%
  2. No

    2 vote(s)
    28.6%
  3. Not sure

    0 vote(s)
    0.0%
  1. Ashioni

    Ashioni Member

    Joined:
    Apr 6, 2009
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Howdy.

    I was wondering if anyone could shed some light on this for me. Have you installed innodb or do you know if installing innodb on a server that already has customer sites on it will cause an derogatory effects on those account? IE can I expect customer databases to be corrupted or anything like that?

    Thanks as always for any and all help.
     
  2. nimrodx

    nimrodx Active Member

    Joined:
    Jul 24, 2005
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Edinburgh, Scotland
    InnoDB is just the engine and it wont cause any problems for the databases currently running on the server :)

    FYI - I don't use it and encourage customers to avoid it as things tend to get corrupt (just through experience, Imo!)
     
  3. Ashioni

    Ashioni Member

    Joined:
    Apr 6, 2009
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Ive had a hand full of request by customers to be able to run/use Magento, and it appears that Magento requires that innodb be available.

    I guess I'll run a backup and install it and see how it goes.

    More feedback from others that have used it would be helpful.
     
  4. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Actually innodb is not required for Magento ...

    Run it with clients all the time without innodb and without problems.
    (disabled for performance and stability reasons)
     
  5. Ashioni

    Ashioni Member

    Joined:
    Apr 6, 2009
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    I went ahead and downloaded it, and then tried to install it. This is the result.

    Database server does not support InnoDB storage engine
    Database connection error

    Ideas?
     
  6. Ashioni

    Ashioni Member

    Joined:
    Apr 6, 2009
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    It appears that Magento has always required InnoDB be installed but never started inforcing it until version 1.2.1.
     
  7. DomineauX

    DomineauX Well-Known Member
    PartnerNOC

    Joined:
    Apr 12, 2003
    Messages:
    414
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Yes Magento does require InnoDB (at least by default) and so we have to enable InnoDB on servers. While I would rather not have to enable InnoDB support, it is currently necessary for us purely for Magento (I wonder if InnoDB use is part of why Magento is so heavy).

    I would love to see the option in WHM to enable or disable MySQL options such as this and query/slow-query logging.
     
Loading...

Share This Page