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.