InnoDB is a storage engine for MySQL relational databases, which is used by well known script-powered web applications like Joomla™ 3.x and Magento. It is perfect for scalable applications, as it performs incredibly well when handling enormous volumes of data. Rather than locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same period of time. Furthermore, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – a set of rules that define how data inserts and modifications should be handled. If a particular operation has not been fully completed for any reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and will not be partially mixed with newly appended content.

InnoDB in Web Hosting

InnoDB is offered with all our Linux web hosting by default, not as a paid upgrade or upon request, so you can activate and manage any open-source script-powered web app which requires the InnoDB database storage engine without encountering any difficulty once you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, regardless of whether you take advantage of our 1-click installer or create the MySQL database and install the application manually, as long as the application requires it instead of the more famous MyISAM engine. We will store daily MySQL database backups, so you can rest assured that you will never lose any content if you delete a database accidentally or you overwrite some essential information – you will just have to touch base with us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database from the hosting Control Panel provided with all our semi-dedicated server accounts and you start installing a script-powered software application either manually or using our 1-click app installer tool, the MySQL database storage engine will be picked automatically based on the requirements of the given app. Since InnoDB is available on the cloud platform where your new account will be created, it will be set as the default engine for any app that requires it without any manual intervention required on your end at any point. To prevent any chance of losing data if you update an app or if you remove a database by accident, we’ll carry out backups of all your MySQL databases every day, so if anything happens, we can restore your data.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting that are ordered with our in-house built Hepsia Control Panel come with a software bundle that’s 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 want to use open-source scripts that require it. All it takes to use such a script is to set up a new MySQL database and to start the installation – as soon as the script setup wizard accesses the database and begins importing data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You will also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you will not need to edit any settings on the server. This will enable you to use different scripts on one single machine and to use it to its full capabilities.