InnoDB is a storage engine for MySQL relational databases, which is used by famous open-source script-powered web applications such as Magento and Joomla 3.x. It’s perfect for scalable apps, as it works exceptionally well when managing huge volumes of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same period of time. Furthermore, InnoDB offers a much faster database failure recovery and supports transactions and foreign keys – rules that define how data inserts and updates should be treated. In case a given task hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved intact and will not be partially merged with newly inserted content.

InnoDB in Cloud Hosting

You will be able to make use of any script-powered web app that needs InnoDB in case you’ve got a cloud hosting with our company, as the database engine is present on our advanced cloud website hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate apps which require the MyISAM engine without any difficulty as well and, again, the engine will be selected automatically, so you won’t have to edit any setting manually at any time. In addition, we’ll also make regular backups of all the MySQL databases that you have in the account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-powered web app that needs InnoDB with all of our semi-dedicated server plans, because all the accounts are created on our advanced cloud web hosting platform where the database engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click app installer. In either case, the needed engine will be chosen automatically the moment the application’s activation starts, so you will not have to modify anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases in case you erase one by mistake, as we carry out several backups every day, each of which is kept for 1 week.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the software pack that will be installed on your Virtual Private Server before we hand it over to you. You won’t have to activate anything manually and you’ll be able to install and use any PHP-powered software app that requires InnoDB once your VPS is ready, which takes no more than sixty minutes after the order submission itself. A couple of engines are offered, so anytime you set up a MySQL database via the Hepsia hosting Control Panel, a particular engine will be picked when the app installation begins and our system will automatically recognize the engine that is required by the application in question. If you need MyISAM, for example, you will not have to do anything different from installing the chosen app, whether manually or using our app installer.

InnoDB in Dedicated Servers

All Linux dedicated service ordered with our custom-developed Hepsia hosting Control Panel include a software package that is pre-activated and among everything else, you’ll get the InnoDB database engine, so you won’t need to install it manually if you need to activate open-source scripts that require it. All it takes to activate such a script is to create a new MySQL database and to begin the installation – as soon as the installation wizard gets access to the database and begins importing content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You’ll also be able to run scripts that need the other widely used MySQL engine, MyISAM, so you won’t have to change any settings on the server. This will allow you to activate different scripts on a single server and to use the latter to its fullest capabilities.