InnoDB is a database engine for MySQL databases, which is used by famous script-powered apps like Joomla v3 and Magento. It’s excellent for scalable apps, since it works really well when managing immense data volumes. Rather than locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can execute much more tasks for the same length of time. Moreover, InnoDB offers a much better database crash recovery and supports transactions and foreign keys – a set of rules that specify how data imports and modifications should be handled. In case a certain task has not been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved intact and will not be partially merged with newly appended content.
InnoDB in Shared Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many other web hosting companies, it’s an essential part of the default set of services offered with our shared web hosting plans. If you would like to make use of an open-source script-based software application that needs InnoDB in particular, in order to be activated and to operate properly, you will not have to deal with any difficulties since the InnoDB database engine is available on our custom cloud web hosting platform. No matter if you create a brand new MySQL database and install an application manually or make use of our 1-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app requires it instead of MyISAM. In addition to the remarkable database failure recovery offered by InnoDB, we also carry out regular database backups, so we can easily recover any database in your shared web hosting account.