InnoDB is a storage engine for MySQL databases, which is used by popular script-driven software applications like Magento and Joomla 3. It is perfect for scalable apps, as it works very well when processing immense amounts of data. Rather than locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more operations for the same period of time. Additionally, InnoDB offers a much faster database crash recovery and supports database transactions and foreign keys – rules that determine how data inserts and updates should be treated. If a given task hasn’t been fully completed for some reason, the action will be rolled back. In this way, the database content will be retained intact and will not be partially merged with newly appended content.

InnoDB in Website Hosting

You’ll be able to run any PHP script-powered software application that requires InnoDB if you have a Linux website hosting with us, as the database storage engine is present on our cutting-edge cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can activate apps which need the MyISAM engine without any difficulties as well and, again, the engine will be selected automatically, so you will not need to update any setting manually at any time. On top of that, we will also generate regular backups of all the MySQL databases that you have in your shared web hosting account, so in case you delete or overwrite anything, we can easily get it back to the way it was on any of the previous 7 days.