InnoDB is a database engine for MySQL databases, which is used by popular PHP-based web applications such as Joomla™ 3 and Magento. It’s perfect for scalable applications, because it performs very well when handling huge amounts of data. Rather than locking the entire database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can execute much more tasks for the same length of time. In addition, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be treated. If a certain task hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be retained safe and sound and won’t be partially mixed with newly imported content.

InnoDB in Cloud Hosting

InnoDB is offered with all our Linux cloud hosting by default, not upon request or as a paid upgrade, so you can activate and run any script-based application which needs the MySQL storage engine without encountering any obstacle once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app installation, regardless of whether you use our 1-click installation tool or create the MySQL database and activate the app manually, provided that the app requires InnoDB instead of the more famous MyISAM engine. We’ll maintain daily MySQL database backups, so you can rest assured that you’ll never lose any content if you erase a database by accident or you overwrite some important information – you will simply need to inform us and we will restore your data the way it was.

InnoDB in Dedicated Web Hosting

If you order a new dedicated server, you will be able to pick one of the three hosting Control Panels that we are offering – Hepsia and cPanel. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to activate this storage engine manually to be able to run script-driven applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require to manage large-size Internet sites, it is very likely that you will use InnoDB. You’ll be able to use other engines too, so in case a certain application needs MyISAM instead of InnoDB, you won’t have to deal with any predicament while running it. The engine that will be used will be automatically recognized as soon as the app installation process begins, so you will not need to configure any settings manually at any point.