InnoDB is a database storage engine for MySQL relational databases, which is used by widespread open-source script-powered web applications like Magento and Joomla 3. It’s perfect for scalable applications, since it performs amazingly well when managing immense volumes of data. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same period of time. Plus, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – a set of rules that specify how data inserts and updates should be handled. If a given task has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved intact and will not be partially mixed with new content.

InnoDB in Shared Web Hosting

Any script-based application that requires InnoDB will function flawlessly on our innovative cloud hosting platform and the MySQL database storage engine is available with all our shared web hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to modify any setting in your shared account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We’ll maintain regular content backups, so if you accidentally erase a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore your data the way it was only a few hours earlier.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database through the hosting Control Panel offered with all our semi-dedicated server packages and you begin installing a PHP script-powered application either manually or using our 1-click app installer, the database storage engine will be picked automatically on the basis of the prerequisites of the given application. As InnoDB is available on the cloud platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any moment. To prevent any risk of losing information if you update an application or if you erase a database accidentally, we’ll carry out backups of all your databases each and every day, so if something happens, we can rescue your content.

InnoDB in VPS Servers

In case our in-house built Hepsia hosting Control Panel is chosen during the registration process for a new VPS web hosting plans , InnoDB will be activated on the VPS server along with other needed pieces of software, so you won’t need to do anything if you choose to use open-source script-driven web apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand new database and begin installing the application manually or through our 1-click installer tool. The system will detect the engine that the application in question needs and will set it for the specific MySQL database, so the installation will proceed impeccably and the app can insert its content into that database. In this way, you can activate apps with various prerequisites in regard to the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels that we are offering – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to add this MySQL storage engine manually to be able to manage PHP-powered web applications that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you require in order to run large-size Internet sites, it is quite possible that you’ll use InnoDB. You’ll be able to make use of other engines as well, so in case a given application requires MyISAM rather than InnoDB, you will not have any problem while running it. The engine that will be used will be recognized automatically once the app installation commences, so you will not need to configure any settings manually at any time.