InnoDB is a database storage engine for MySQL relational databases, which is used by widely used PHP-based applications such as Joomla 3 and Magento. It’s perfect for scalable apps, since it works astonishingly well when handling immense data volumes. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can process much more operations for the same length of time. Besides, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and updates should be treated. In case a specific task hasn’t been fully completed for some reason, the action will be rolled back. In this way, the database content will be retained undamaged and will not be partially mixed with new content.

InnoDB in Cloud Hosting

InnoDB is offered with all our Linux cloud hosting packages by default, not upon request or as a paid upgrade, so you can install and manage any script-driven web app that needs the database storage engine without encountering any impediment as soon as you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation process, irrespective of whether you take advantage of our single-click installation tool or create the MySQL database and activate the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll perform regular backups of all your MySQL databases, so you can rest assured that you will never lose any data in case you erase a database unintentionally or you overwrite some crucial information – you just need to inform us and we will restore your content the way it was.

InnoDB in Semi-dedicated Hosting

You can use a PHP script-based software app that needs InnoDB with any of our semi-dedicated server plans, since all the accounts are set up on our advanced cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our one-click application installer tool. Either way, the needed engine will be selected automatically as soon as the application’s activation begins, so you won’t have to configure anything manually, no matter if the application needs InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to restore any of your databases in case you accidentally remove one, as we generate a couple of MySQL database backups every day, each of which is kept for 7 days.

InnoDB in VPS Web Hosting

If our in-house built Hepsia Control Panel is picked during the registration process for a new Linux VPS web hosting packages , InnoDB will be installed on the VPS server together with other required pieces of software, so you won’t have to do anything if you choose to make use of script-driven software apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand new database and begin the app installation manually or through our one-click installer tool. The system will automatically recognize which engine the particular app requires and will assign it to the specific database, so the installation will proceed flawlessly and the app can import its content into that database. Therefore, you can activate apps with various prerequisites in regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers Hosting

When you acquire a new dedicated server, you will be able to choose any of the three Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to install this MySQL database storage engine manually to be able to run PHP-based web apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the resources that you need to manage large-scale websites, it’s pretty possible that you will resort to InnoDB. You’ll be able to make use of other engines as well, so if a given app needs MyISAM instead of InnoDB, you will not run into any difficulty while running it. The engine that will be used will be recognized automatically the moment the app installation starts, so you won’t have to alter any settings manually whatsoever.