InnoDB is a database engine for MySQL databases, which is used by famous script-based web applications such as Joomla™ v3 and Magento. It’s ideal for scalable apps, since it performs astonishingly well when managing immense volumes of data. Rather than locking the whole table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same period of time. What’s more, InnoDB offers a much faster database crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data inserts and updates should be treated. If a given operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will stay intact and will not be partially mixed with newly appended content.

InnoDB in Website Hosting

InnoDB is available with all our website hosting plans by default, not as a paid upgrade or upon request, so you can activate and run any PHP-based app which requires the InnoDB storage engine without having to deal with any obstacle once you activate your account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation process, irrespective 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 famous MyISAM engine. We’ll make regular MySQL database backups, so you can rest assured that you won’t ever lose any content in case you delete a database by mistake or you overwrite some crucial info – you will simply need to inform us and we will restore your content back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans support InnoDB and you can take advantage of all the features offered by this MySQL database engine with any PHP-based software application that needs it. It is one of the engines that we have on our cloud web hosting platform, so the one that will be used depends on the prerequisites of the app in question. You will not have to do anything manually to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our 1-click app installer tool. To avoid any risk, we will keep regular backups of all your databases, so if something goes wrong following some update or if you delete some content unintentionally, we will be able to get your database back to the way it was on any of the previous seven days.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house built Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t have to activate it manually if you’d like to activate open-source scripts that need it. All it takes to run such a script is to set up a new MySQL database and to start the setup process – as soon as the script installation wizard gets access to the database in question and starts inserting 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 particular script. You will also be able to activate scripts that require MyISAM – the other widely used MySQL engine, so you will not have to change any settings on the dedicated server. This will enable you to install a variety of scripts on a single server and to use it to its fullest potential.