InnoDB is a storage engine for MySQL databases, which is used by well known script-driven apps such as Magento and Joomla™ 3. It’s perfect for scalable apps, because it performs remarkably well when processing immense volumes of data. Rather than locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can execute much more operations for the same period of time. Plus, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – rules that determine how data imports and updates should be treated. If a particular operation has not been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and will not be partially merged with new content.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting by default, not upon request or as a paid upgrade, so you can install and run any open-source script-based web application that needs the storage engine without encountering any obstacle once you activate your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app activation process, regardless of whether you take advantage of our one-click installation tool or create the MySQL database and activate the application manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We will keep regular database backups, so you can rest assured that you’ll never lose any content if you erase a database by mistake or you overwrite some essential info – you simply need to alert us and we will restore everything the way it was.
InnoDB in Dedicated Web Hosting
When you buy a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels that we offer – cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to add this storage engine manually in order to be able to use script-driven web applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the server resources that you require in order to run large-size Internet sites, it is pretty likely that you’ll use InnoDB. You’ll be able to use other engines as well, so if a specific app needs MyISAM instead of InnoDB, you won’t run into any complication while running it. The engine that will be used will be automatically detected the moment the app installation process commences, so you will not have to fine-tune any settings manually whatsoever.