Magento without InnoDB

Question

I am trying to install Magento Community Edition for my last project on our server, however the hosting platform we are currently using does not and will not allow us to install or use InnoDB.

Does anyone know of any configuration / changes that can be made to make it work in any other way?

Answer 1

Magento was designed and should be used in a secure transaction.

You can try switching to another database that is safe for transactions (for example, Oracle), but then you will need to write PDO adapters and resource models for Oracle yourself (they are not part of Magento). But if your provider doesn’t even support InnoDB , I don’t believe that it will support Oracle or similar ^^

Another possibility would be for Magento to work with the mySQL engine without transactions, such as MyISAM . You will need to rewrite many processes, core models, and controllers in order to change Magento from transactional to non-transactional behavior.

Not only will this be a lot of work, but I'm pretty sure you will get a lot of pleasure every time you try to upgrade the version of Magento. I would highly recommend never changing this kernel this way.

The only transactional mySQL engines are InnoDB and NDB . Magento only submits resource models to InnoDB . So, if you ask me if your provider does not allow InnoDB for any reason, I would recommend just switching to another provider that does this.

Answer 2

I tried to install Magento 1.9 CE on my own development server. In the end, Magento Downloader incorrectly indicated that InnoDB is not the default database engine. This was a problem that arose when installing Magento CE.

Yes, it’s true that MariaDB, a binary compatible MySQL replacement, uses xtradb and not innodb as its engine.

https://mariadb.com/kb/en/mariadb/xtradb-and-innodb/

However, I am tempted to conclude that the problem is Magento: Installation of Magento complains about the lack of InnoDB when it is available