InnoDB is a database storage engine for MySQL databases, which is used by well known open-source script-driven web apps such as Joomla 3 and Magento. It is ideal for scalable applications, as it performs very well when managing large amounts of data. Rather than locking the whole table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can process a lot more operations for the same length of time. Plus, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that indicate how data inserts and modifications should be handled. If a specific task has not been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will remain intact and won’t be partially merged with newly appended content.

InnoDB in Shared Website Hosting

You will be able to run any open-source script-based software application that requires InnoDB if you’ve got a Linux shared website hosting package with our company, as the MySQL storage engine is present on our avant-garde cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is required. You can install applications which require the MyISAM engine without having to deal with any problem as well and, once again, the engine will be selected automatically, so you will not have to modify any setting manually at any moment. On top of that, we’ll also generate regular backups of all the databases that you’ve got in your shared account, so if you erase or overwrite anything, we can easily restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the hosting Control Panel provided with each of our semi-dedicated server packages and you begin installing a script-driven application either manually or using our 1-click application installer, the database storage engine will be picked automatically based on the requirements of the particular application. As InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that needs it without any manual action needed on your end at any moment. To prevent any risk of losing information if you update an app or if you erase a database unintentionally, we will make backups of all your MySQL databases each and every day, so if anything happens, we can retrieve your data.