InnoDB is a database engine for MySQL databases, which is used by widely used PHP script-based software apps like Magento and Joomla v3. It is perfect for scalable apps, because it works really well when handling immense volumes of data. Rather than locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can process a lot more operations for the same length of time. In addition, InnoDB offers a much better database failure recovery and supports database transactions and foreign key constraints – rules that specify how data inserts and modifications should be treated. If a specific task has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will remain intact and will not be partially merged with newly imported content.

InnoDB in Shared Website Hosting

InnoDB is offered with all our shared website hosting plans by default, not as a paid upgrade or upon request, so you can activate and run any script-based application that requires the InnoDB database engine without having to deal with any obstacle once you activate your account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation process, regardless of whether you take advantage of our 1-click installer or create the database and activate the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll generate daily database backups, so you can rest assured that you won’t ever lose any content in case you delete a database accidentally or you overwrite some essential information – you’ll simply have to alert us and we will restore everything back to normal.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually in case you wish to activate PHP scripts that need it. All it takes to install such a script is to set up a new database and to begin the installation – as soon as the script setup wizard accesses the database and begins entering data into 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 run scripts that require the other widely used MySQL engine, MyISAM, so you will not need to modify any settings on the server. This will permit you to activate different scripts on a single physical machine and to use it to its fullest capabilities.