InnoDB is a database storage engine for MySQL relational databases, which is used by widespread script-powered web applications like Magento and Joomla 3.x. It is perfect for scalable applications, as it performs really well when processing large data volumes. Rather than locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can handle much more operations for the same period of time. What’s more, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that indicate how data inserts and updates should be treated. If a specific operation has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will be kept undamaged and won’t be partially mixed with newly imported content.

InnoDB in Shared Web Hosting

You’ll be able to use any script-based web app that requires InnoDB if you’ve got a shared web hosting with our company, as the MySQL database storage engine is available on our innovative cloud web hosting platform as standard. Throughout 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 run apps that require the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you won’t have to change anything manually at any time. Furthermore, we’ll also create daily backups of all the MySQL databases that you have in the shared account, so if you delete 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 Servers

All our Linux semi-dedicated servers include InnoDB and you will be able to make the most of all the features of this MySQL database engine with any script-driven application that needs it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the given application. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our one-click app installer. To be on the safe side, we’ll carry out regular database backups, so if something goes wrong after some update or if you delete some data by mistake, we will be able to get your database back to the way it was on any of the past seven days.

InnoDB in VPS Servers

All Linux VPS service that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you will be able to take advantage of any PHP script-powered web app that needs this particular MySQL database engine without having to activate anything manually. You can pick Hepsia on the VPS order form and your new server will be ready within 60 minutes, so you can log in and begin creating your Internet sites straight away. When you create a new MySQL database and begin the app installation process, our system will choose the engine for that MySQL database automatically. In this way, you can make use of different apps simultaneously without updating anything on the VPS server. You can have a WordPress-based personal blog that uses the default MySQL engine – MyISAM, and a Magento-based e-store that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers

All dedicated service ordered with our custom Hepsia Control Panel come with a software package that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you will not need to install it manually in case you need to run open-source PHP scripts that need it. All it takes to activate such a script is to create a new MySQL database and to start the installation – once the script configuration wizard gets access to the database in question and starts importing data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to use scripts that need MyISAM, the other very popular MySQL engine, so you won’t need to configure any settings on the server. This will enable you to run different scripts on a single server and to use it to its full capacity.