InnoDB is a database engine for MySQL databases, which is used by popular PHP-powered web apps such as Magento and Joomla™ 3. It’s excellent for scalable apps, because it excels in processing immense volumes of data. Instead of locking the whole 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 tasks for the same period of time. Additionally, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – a set of rules that define how data imports and updates should be handled. If a given operation hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will be preserved undamaged and will not be partially merged with new content.

InnoDB in Cloud Hosting

Any script-powered web app that requires InnoDB will function flawlessly on our leading-edge cloud web hosting platform and the MySQL storage engine comes with all our cloud hosting plans. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected on the basis of the app’s requirements without the need to change any setting in your shared account. InnoDB will be chosen automatically for any app that requires this specific engine and you’ll be able to get the most out of its full potential. We’ll make daily backups of your content, so if you accidentally erase a database that is important to you or you overwrite specific parts of it, we’ll be able to restore your data the way it was just a few hours earlier.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database through the hosting Control Panel coming with all our semi-dedicated server packages and you begin installing a PHP-driven software application either manually or using our 1-click app installer tool, the storage engine for the database will be set automatically on the basis of the prerequisites of the particular app. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each application that needs it without the need for any manual action on your end at any time. To avoid any risk of losing data if you update an application or if you remove a database accidentally, we’ll perform a backup of all your MySQL databases each and every day, so if anything happens, we can restore your content.

InnoDB in VPS Web Hosting

If you select a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the default software package that will be installed on your VPS server before we hand it over to you. You will not need to activate anything manually and you’ll be able to install and use any script-powered software application that needs InnoDB once your VPS server is ready, which takes no more than 60 minutes after the order submission procedure itself. Several engines are offered, so every time you set up a MySQL database via the Hepsia hosting Control Panel, a specific engine will be activated once the app activation process commences and our system will automatically detect which engine is required by the app in question. In case you have to use MyISAM, for example, you won’t have to do anything different from installing the chosen application, whether manually or using our app installer tool.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting that are ordered with our custom Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually if you wish to run scripts that need it. All it takes to use such a script is to set up a new MySQL database and to start the setup – as soon as the setup wizard acquires access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to activate scripts that require MyISAM, the other widely used MySQL engine, so you won’t have to configure any settings on the dedicated server. This will permit you to run a variety of scripts on one single physical machine and to use the latter to its fullest capabilities.