InnoDB is a database storage engine for MySQL databases, which is used by widespread open-source script-powered apps like Magento and Joomla v3. It is ideal for scalable apps, as it works stunningly well when processing enormous amounts of data. Rather than locking the whole table to add new information to a database like many other engines do, InnoDB locks only one row, so it can process much more operations for the same length of time. Besides, InnoDB offers a much better database failure recovery and supports database transactions and foreign key constraints – a set of rules that specify how data imports and modifications should be treated. In case a particular 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 Website Hosting

You can activate any script-based application that requires InnoDB if you’ve got a Linux website hosting with us, as the database storage engine is present on our leading-edge cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is needed. You can install applications which require the MyISAM engine without encountering any impediment as well and, once again, the engine will be pre-selected, so you will not need to change anything manually at any time. Furthermore, we’ll also make regular backups of all the MySQL databases that you have in your shared web hosting account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB comes with each of our Linux semi-dedicated hosting by default, so as soon as you buy a new account, you can move on and install any PHP script-powered web app that needs this particular MySQL storage engine. Several engines are installed on our cloud website hosting platform, so when you create a new database and start installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen based on the requirements of the specific app. This will permit you to activate and manage InnoDB-specific applications without the need to cope with any impediment and without the need to change any settings in your semi-dedicated account. To take no chances, we’ll always keep a one-week-old backup of all your MySQL databases, so if you delete or edit any content by accident, we can quickly retrieve it.

InnoDB in VPS

If our custom Hepsia Control Panel is picked during the signup process for your new Linux virtual private servers , InnoDB will be activated on the VPS server together with other necessary software, so you will not have to do anything if you choose to make use of PHP script-powered software applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can create a brand-new database and begin the app installation process manually or using our 1-click installer. The system will recognize the engine that the application in question requires and will assign it to the specific database, so the installation process will proceed flawlessly and the app can dump its content in that database. Therefore, you can use applications with different requirements regarding the MySQL engine without making any modifications on your VPS.

InnoDB in Dedicated Hosting

When you get a new dedicated server, you will be able to choose one of the 3 Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to add this MySQL database storage engine manually to be able to use script-driven apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the resources that you require to run large-scale sites, it is pretty possible that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a given app needs MyISAM instead of InnoDB, you will not experience any problem while using it. The engine that will be used will be automatically recognized the moment the app installation commences, so you will not have to alter any setting manually at any moment.