InnoDB is a storage engine for MySQL relational databases, which is used by famous PHP-driven apps such as Joomla 3.x and Magento. It’s perfect for scalable apps, since it performs amazingly well when managing huge amounts of data. Rather than locking the whole database table to add new information to a database as many other engines do, InnoDB locks only one row, so it can perform much more tasks for the same period of time. Moreover, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – rules that define how data inserts and modifications should be treated. In case a specific task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be retained intact and will not be partially merged with newly imported content.
InnoDB in Shared Hosting
InnoDB is offered with all our shared hosting service by default, not upon request or as a paid upgrade, so you can activate and run any script-driven web application which needs the InnoDB storage engine without the need to deal with any complication once you activate your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation, irrespective of whether you take advantage of our single-click installation tool or create the database and activate the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll carry out daily MySQL database backups, so you can be sure that you will never lose any data if you erase a database by accident or you overwrite some important information – you will just need to contact us and we will restore your data the way it was.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database through the hosting Control Panel included with each of our semi-dedicated server plans and you start installing a PHP script-based application either manually or using our single-click application installer tool, the storage engine for the MySQL database will be picked automatically depending on the prerequisites of the given application. As InnoDB is present on the cloud 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 required on your end at any point. To prevent any risk of losing data if you update an application or if you remove a database accidentally, we’ll carry out a backup of all your MySQL databases every day, so if something happens, we can retrieve your content.
InnoDB in VPS Servers
In case our in-house developed Hepsia Control Panel is picked during the signup process for a new VPS servers , InnoDB will be installed on the VPS server together with other necessary pieces of software, so you won’t need to do anything if you choose to use PHP-driven applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a brand new database and start installing the application manually or using our one-click installer tool. The system will recognize which engine the particular app needs and will assign it to the specific database, so the installation will continue impeccably and the app can dump its data in that database. Thus, you can install apps with various prerequisites regarding the MySQL engine without having to make any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
When you purchase a new dedicated server, you will be able to pick one of the three hosting Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to add this storage engine manually in order to be able to use script-driven apps that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the resources that you need in order to manage very large Internet sites, it’s rather possible that you will resort to InnoDB. You will be able to make use of other engines too, so in case a certain application requires MyISAM instead of InnoDB, you will not need to deal with any impediment while running it. The engine that will be used will be automatically recognized once the app installation starts, so you won’t need to alter any settings manually at any moment.