InnoDB is a storage engine for MySQL databases, which is used by famous open-source script-based web apps like Magento and Joomla v3. It is ideal for scalable applications, because it works remarkably well when handling large data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can execute much more tasks for the same period of time. Moreover, InnoDB offers a much better crash recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and modifications should be handled. In case a given task has not been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will remain intact and won’t be partially mixed with newly entered content.

InnoDB in Web Hosting

InnoDB is offered with all our web hosting by default, not as a paid upgrade or upon request, so you can activate and run any script-based application which requires the InnoDB storage engine without any problems as soon as you order your shared account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation process, irrespective of whether you use our one-click installation tool or create the MySQL database and install the app manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We will store daily database backups, so you can rest assured that you won’t ever lose any content if you erase a database accidentally or you overwrite some vital info – you’ll simply need to alert us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Servers

You can run a script-based application that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our advanced cloud platform where the MySQL storage engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our single-click app installer. Either way, the needed engine will be chosen automatically the moment the app’s installation starts, so you won’t have to edit anything manually, no matter if the application requires InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases in case you erase one by accident, as we create a couple of MySQL database backups every day, each of which is kept for one week.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia hosting Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you won’t have to install it manually in case you need to run open-source scripts that require it. All it takes to install such a script is to set up a new database and to begin the setup process – once the installer wizard obtains access to the database and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to use scripts that need the other popular MySQL engine, MyISAM, so you won’t have to edit any settings on the dedicated server. This will permit you to use various scripts on a single machine and to use it to its maximum potential.