InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP script-driven software apps such as Magento and Joomla 3. It’s perfect for scalable applications, as it works astonishingly well when handling immense amounts of data. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more operations for the same length of time. Also, InnoDB offers a better database crash recovery and supports transactions and foreign keys – rules that determine how data inserts and updates should be treated. If a certain operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved safe and sound and won’t be partially merged with newly entered content.

InnoDB in Web Hosting

InnoDB is offered with all our Linux web hosting packages by default, not upon request or as a paid upgrade, so you will be able to activate and run any PHP script-based software app that needs the storage engine without having to deal with any obstacle as soon as you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation process, no matter if you take advantage of our 1-click installer or create the MySQL database and set up the application manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We will store regular backups of all your databases, so you can be sure that you won’t ever lose any content in case you erase a database accidentally or you overwrite some essential info – you will simply need to get in touch with us and we will restore your data the way it was.

InnoDB in Semi-dedicated Hosting

You can run a PHP script-based web application that needs InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our leading-edge cloud hosting platform where the storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our one-click app installer. In either case, the needed engine will be chosen automatically as soon as the app’s activation starts, so you won’t have to modify anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. In addition, we’ll always be able to restore any of your databases in case you accidentally remove one, as we perform several database backups every day, each of which is kept for one week.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you will not have to install it manually in case you’d like to activate open-source PHP scripts that require it. All it takes to activate such a script is to set up a new database and to initiate the setup – as soon as the installer wizard gains access to the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You’ll also be able to use scripts that need MyISAM – the other popular MySQL engine, so you will not need to edit any settings on the server. This will enable you to use various scripts on one single machine and to use the latter to its maximum capacity.