InnoDB is a storage engine for MySQL databases, which is used by widely used script-driven apps like Magento and Joomla™ 3.x. It’s ideal for scalable apps, because it works really well when handling immense amounts of data. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same length of time. What’s more, InnoDB offers a much faster database failure recovery and supports transactions and foreign keys – a set of rules that determine how data inserts and updates should be handled. In case a specific task hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will be retained intact and won’t be partially merged with new content.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our cloud website hosting by default, not as a paid upgrade or upon request, so you will be able to activate and run any script-driven software app which needs the MySQL database storage engine without any impediments as soon as you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, irrespective of whether you use our one-click installation tool or create the database and activate the application manually, provided that the application requires it instead of the more popular MyISAM engine. We will keep daily backups of all your MySQL databases, so you can be certain that you will never lose any content in case you erase a database accidentally or you overwrite some vital information – you’ll simply have to touch base with us and we will restore your content the way it was.

InnoDB in Dedicated Servers

When you order a new dedicated server, you will be able to select one of the three Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t have to add this MySQL storage engine manually so as to be able to use script-driven web apps that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you require to run large-size websites, it’s pretty possible that you’ll use InnoDB. You will be able to use other engines as well, so if a specific application requires MyISAM instead of InnoDB, you won’t experience any impediment while running it. The engine that will be used will be recognized automatically the moment the app installation procedure commences, so you won’t have to modify any settings manually at any time.