Magento Installation: Database server does not support InnoDB storage engine

March 24, 2009

If you have recently hit a brick wall when installing Magento 1.2.1 on a shared hosting service with the error: Database server does not support InnoDB storage engine then you’re not alone. I came across this today while helping with a Magento install (one of my 5 Free Professional Magento installs). There is not a lot you can do, short of installing an old Magento version and not upgrading in the future, which is not a really good solution at all.

My recommendation was to either:

A) Request that your hosting provider enables InnoDB, which may or may not be possible. I notice shared hosting providers find all sorts of excuses for not supporting InnoDB, there looks to be plenty of reasons to have InnoDB enabled to me. This is really easily done by simply not having the skip-innodb line your mysql server configuration. Sadly though if it is in there, they probably opted to put it in there, and may not be willing to take it out.

or B) Move to a hosting provider that does support the new 1.2.x Magento and modern Mysql storage engines properly. That’s not always as easily done as it’s said though unfortunately. Of course if you are on a VPS, or semi-dedicated/dedicated hos t(not on a shared hosting service), then you can control what storage engines are enabled and can easily take steps to enable innodb on your own mysql server. Lucky you!

This whole episode has left me thinking the best thing to do would be to start a simple Magento compatible/certified/optimized free hosting service, it seems far too many people are being caught up in poor quality hosts, with hard-to-use control panels. I’d be interested in hearing thoughts on the viability of such a service. I think there are a few ways I could sustain the costs of a free hosting service:

Sell Services to Free Hosting Customers

To help with Magento configuration, inventory uploading, backup scheduling, payment gateway integration or to simply assist with custom development. This wouldn’t really scale well because I’d run out of time in a day.

Advertise on the Free Stores

Though that would make the stores ugly, and wouldn’t be really very valuable until you had 100’s of stores up and running getting 1000’s of daily impressions. Plus who wants to run ads on their webstore, not me , and probably not you.

Make a bit of money on a premium hosting service

Hope that a small portion of the stores really take off and need extra hosting space/traffic/performance, then help with an upgrade to paid hosting. Though this relies on the stores getting big, and on the stores that get big wanting to stay with you. Not ideal odds really.

Implement my own decimal Rounding Extension for Magento

If you have seen Office Space, you know what I mean! Though this might border on the illegal, and would probably be difficult to implement without anyone noticing! On balance it doesn’t really look all that workable does it? If anyone has any bright ideas, I’d like to hear them. I would really like to start such a service, if anyone is willing to donate the server resources, then perhaps I can take care of the technical side of things.

Ashley

Posts

Hi! I'm Ashley Schroder, a Software Engineer from New Zealand - this is a collection of notes on my experiences with Ecommerce Web Development, particularly Magento Development.

Are Your Customers Getting The Magento Emails You Send?

MageSend Magento Email sending with Amazon SES

I have made a premium Magento Extension called MageSend. MageSend makes it simple and easy to send using Amazon's highly reliable SES email service.

The extension is $99, and comes with a complete money back guarantee, please check it out, I am confident it will resolve any email sending problems with your Magento store.

7 responses to Magento Installation: Database server does not support InnoDB storage engine

  1. HA! I ran into this problem. I have a hosting reseller account which is much like a VPS, but you know that. The whole reason I started selling hosting is because I wanted to streamline my process a bit more and not be so spread out with my clients hosting “who knows where.” Anyway I was also looking for a good place to launch my Magento world take-over from. A week later after I migrated my clients Magento release the new version and my hosting company announce they would no longer support Magento. To make a long story short, I crafted a very pointed email saying I would have no choice but to move on to a new hosting company. The next morning the Linux rep emailed me and said innoDB was installed on my server…fhew I am no heavyweight either, I have a rather basic reselling plan with about 10 clients on it. Magento is the future. No scratch that, Magento is future….I think that makes sense. I like you block, you are my first RSS subscription. Nice Work

  2. Hi, this just happened to me as well. I rented a hosting and didn’t quite check if they have innoDB enabled (checked everything else). So after few months we were ready to install Magento to live server, when it became clear we need InnoDB. And our host just won’t enable it (“due to security reasons”). Now we have to find and move to another hosting provider, and take everything (hosting, static IP, certificate and domains) with us…

  3. Oh damn that is terrible! Feel free to name and shame the host because honestly there is no excuse, security or otherwise, for mysql to not have innoDB enabled! Why don’t you talk to the guys at Nexcess, they’re a helpful bunch they may be willing to help you do some of those steps if you move your hosting to their servers. I wrote a review of their Magento hosting and it’s the one I recommend to everyone who contacts me with hosting related problems.

  4. I can’t use magento by this problem

  5. i really have this problem, but when i done like this, starting mysql ,it’s say :”Starting MySQL. ERROR! Manager of pid-file quit without updating file”

  6. I had the same problem, my hosting provider disabled InnoDB. They had suggested I purchase a VPS, which is a complete sham considering it is the current default database engine in MySQL. I decided to try Magento using MyISAM instead of InnoDB, I upgraded from version 1.5.1 to 1.7 without incident, using MyISAM. I do not know of any detriment to site stability, but it is working.

  7. I had the same problem,In the local installation and testing, installation, this step this problem.We look forward to solve this problem.