InnoDB is a database engine for MySQL databases, which is used by popular script-powered apps such as Magento and Joomla™ 3. It’s excellent for scalable applications, since it works very well when processing large data volumes. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same length of time. Furthermore, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be handled. In case a given task hasn’t been fully completed for any reason, the action will be rolled back. Thus, the content in the database will remain intact and will not be partially merged with newly appended content.

InnoDB in Website Hosting

InnoDB is available with all our Linux website hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to install and run any PHP-driven software app that requires the MySQL storage engine without any problem once you activate your account. InnoDB will be pre-selected as the default engine for a specific database during the app activation process, regardless of whether you take advantage of our 1-click installer or create the MySQL database and set up the application manually, as long as the application requires it instead of the more popular MyISAM engine. We will keep daily MySQL database backups, so you can rest assured that you’ll never lose any content in case you erase a database by accident or you overwrite some vital information – you simply need to get in touch with us and we will restore the database the way it was.

InnoDB in Semi-dedicated Hosting

InnoDB comes with each of our Linux semi-dedicated packages by default, so the moment you purchase a new semi-dedicated account, you can go ahead and activate any PHP script-driven app that requires this particular MySQL database storage engine. A few engines are installed on our cloud website hosting platform, so when you create a new MySQL database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be chosen in accordance with the specific app’s requirements. This will permit you to activate and run InnoDB-specific applications without the need to cope with any complication and without modifying any settings in your semi-dedicated account. To be on the safe side, we will always keep a 7-day-old backup of all your MySQL databases, so if you delete or alter any content accidentally, we can easily recover it.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house built Hepsia Control Panel come with a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not have to add it manually if you’d like to use scripts that require it. All it takes to activate such a script is to set up a new database and to begin the setup – once the script configuration wizard gets access to the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You will also be able to install scripts that need MyISAM – the other widely used MySQL engine, so you won’t need to edit any settings on the server. This will permit you to use various scripts on one single physical server and to use it to its fullest potential.