InnoDB is a database storage engine for MySQL relational databases, which is used by widely used script-based web applications such as Magento and Joomla™ 3. It is ideal for scalable apps, because it performs unbelievably well when managing large data volumes. 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 operations for the same period of time. What’s more, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – rules that define how data inserts and updates should be treated. In case a particular operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be preserved safe and sound and won’t be partially merged with newly inserted content.

InnoDB in Cloud Hosting

Any PHP-based application that needs InnoDB will run flawlessly on our advanced cloud hosting platform and the MySQL database engine comes with all our cloud hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected on the basis of the app’s specifications without having to configure any setting in your web hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to get the most out of its full potential. We’ll maintain regular content backups, so if you accidentally erase a database that’s important to you or you overwrite some part of it, we will be able to restore everything the way it was only a few hours earlier.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-driven web application that needs InnoDB with any of our semi-dedicated server plans, because all the accounts are created on our advanced cloud hosting platform where the MySQL storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you make use of our one-click application installer. Either way, the required engine will be selected automatically the moment the activation of the application starts, so you will not need to change anything manually, irrespective of whether the application needs InnoDB or the more widely used MyISAM. Also, we will always be able to recover any of your databases in case you delete one by mistake, as we make a couple of MySQL database backups every day, each of which is stored for 1 week.

InnoDB in VPS Servers

When you order a VPS server from us, you’ll be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to activate any PHP-based software app that needs InnoDB, as this MySQL database storage engine is part of the default software bundle that will be pre-installed on your server during its configuration. When you create a brand new database using the Control Panel, you just have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine in case the application in question needs it, so you will not have to do anything else in your account. Correspondingly, if an app needs MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-developed Hepsia Control Panel come with a software bundle that is pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to install it manually in case you need to activate scripts that require it. All it takes to activate such a script is to set up a new database and to begin the installation – once the installer wizard obtains access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to run scripts that require the other popular MySQL engine, MyISAM, so you will not have to edit any settings on the dedicated server. This will permit you to use a variety of scripts on a single machine and to use the latter to its fullest capacity.