InnoDB is a storage engine for MySQL databases, which is used by famous open-source script-powered web applications such as Joomla™ 3.x and Magento. It’s excellent for scalable apps, since it performs really well when managing enormous volumes of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same period of time. Moreover, InnoDB offers a much better crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and modifications should be treated. In case a given task hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be kept undamaged and won’t be partially merged with newly inserted content.
InnoDB in Hosting
InnoDB is offered with all our hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP script-based web application which requires the database engine without having to deal with any difficulty once you open your shared website hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, regardless of whether you use our single-click installation tool or create the MySQL database and set up the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll keep regular database backups, so you can be certain that you won’t ever lose any data if you delete a database accidentally or you overwrite some crucial info – you just have to notify us and we’ll restore your data the way it was.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated servers that are ordered with the Hepsia Control Panel. It’s an essential part of the software package that will be pre-installed on all Hepsia-equipped dedicated servers, so once your machine is ready, you’ll be able to log in and to install a various PHP script-driven software application that requires this database storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you start installing an application. Once the app setup wizard starts importing information into the database, the engine will be picked automatically depending on the prerequisites of the specific application, so you can run both MyISAM and InnoDB without having to select either of them specifically at any moment. In this way, you can use a huge selection of applications for your sites.