InnoDB is a storage engine for MySQL databases, which is used by popular script-driven software apps like Joomla v3 and Magento. It is excellent for scalable apps, since it performs stunningly well when processing enormous data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same period of time. Moreover, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that determine how data imports and modifications should be handled. In case a certain task has not been fully completed for some reason, the action will be rolled back. Thus, the database content will be kept intact and won’t be partially mixed with newly appended content.

InnoDB in Web Hosting

You can install any PHP-powered app that requires InnoDB if you’ve got a web hosting with our company, as the database storage engine is present on our advanced cloud website hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can run applications which need the MyISAM engine without encountering any obstacle as well and, again, the engine will be pre-selected, so you will not need to change any setting manually at any moment. In addition, we’ll also carry out daily backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can easily restore it the way it was on any of the previous 7 days.