InnoDB is a storage engine for MySQL databases, which is used by popular PHP-driven web apps such as Joomla™ v3 and Magento. It’s perfect for scalable apps, since it performs amazingly well when managing immense volumes of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can process much more tasks for the same period of time. In addition, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that specify how data inserts and updates should be treated. If a particular task hasn’t been entirely completed for whatever reason, the action will be rolled back. In this way, the information in the database will stay safe and sound and won’t be partially merged with new content.

InnoDB in Hosting

InnoDB is offered with all our hosting plans by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any script-powered app that needs the MySQL database storage engine without having to deal with any obstacle once you open your shared account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation process, regardless of whether you take advantage of our 1-click installer or create the database and set up the application manually, on the condition that the app requires it instead of the more popular MyISAM engine. We will keep regular backups of all your MySQL databases, so you can be certain that you won’t ever lose any content in case you erase a database by mistake or you overwrite some vital information – you simply need to touch base with us and we will restore the database the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our Linux semi-dedicated servers by default, so once you create a new account, you can go ahead and install any script-based app that needs this particular MySQL database engine. Several engines are installed on our cloud website hosting platform, so when you set up a new MySQL database and start installing an application manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen in accordance with the prerequisites of the specific app. This will allow you to install and manage InnoDB-specific applications without experiencing any complication and without the need to edit any settings in your semi-dedicated account. To be on the safe side, we’ll always keep a one-week-old backup of all your MySQL databases, so if you delete or change any content accidentally, we can easily retrieve it.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an indivisible part of the standard software bundle that will be pre-installed on your server before we hand it over to you. You won’t need to activate anything manually and you’ll be able to enable and manage any open-source script-based software application that needs InnoDB once your VPS is set up, which takes no more than one hour after the order process itself. Several engines are offered, so every time you create a database via the Hepsia Control Panel, a particular engine will be selected when the app activation process starts and our system will automatically detect the engine that is required by the application in question. In case you have to use MyISAM, for example, you will not need to do anything different from installing the preferred application, whether manually or using our app installer.

InnoDB in Dedicated Servers

InnoDB is included by default with all Linux dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It is included in the standard software package that will be installed on all Hepsia-equipped servers, so once your machine is up and running, you’ll be able to sign in and to install any PHP script-based web application that needs this particular database storage engine. If you create a new database via the hosting Control Panel, there won’t be any active engine till you start installing an application. As soon as the app activation wizard begins entering data into the database, the engine will be set automatically based on the specific app’s requirements, so you can run both InnoDB and MyISAM without the need to select either of them specifically at any time. In this way, you can make use of a vast collection of apps for your websites.