InnoDB is a database engine for MySQL relational databases, which is used by famous script-based applications such as Magento and Joomla™ 3. It’s excellent for scalable applications, since it works incredibly well when handling huge volumes of data. Rather than 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 execute a lot more operations for the same length of time. Moreover, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that define how data imports and updates should be handled. If a given operation hasn’t been entirely completed for any reason, the action will be rolled back. Thus, the content in the database will be kept intact and won’t be partially mixed with newly appended content.

InnoDB in Hosting

InnoDB is available with all our Linux hosting by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP-powered web application that needs the InnoDB storage engine without any obstacles as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app activation, irrespective of whether you make use of our 1-click installer or create the MySQL database and activate the application manually, as long as the app requires it instead of the more famous MyISAM engine. We will keep regular backups of all your databases, so you can rest assured that you’ll never lose any content if you erase a database by mistake or you overwrite some crucial info – you will just have to alert us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting include InnoDB and you’ll be able to make use of all the features of this MySQL storage engine with any PHP script-driven web application that requires it. It is among the engines that we have on our cloud hosting platform, so the one that will be used depends on the requirements of the app in question. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To avoid any risk, we will carry out daily database backups, so if something goes wrong following some update or if you erase some content accidentally, we will be able to get your database back to the way it was on any of the previous seven days.

InnoDB in VPS

If our custom Hepsia Control Panel is selected during the registration process for your new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server along with other essential software, so you will not need to do anything if you choose to make use of PHP-based software applications that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand-new database and start installing the application manually or using our one-click installer. The system will automatically detect the engine that the app in question requires and will set it for the specific database, so the installation will continue impeccably and the application can import its content into that database. Thus, you can manage applications with different requirements about the MySQL engine without making any modifications on your Virtual Private Server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting services ordered with our custom Hepsia hosting Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not have to activate it manually if you’d like to run open-source scripts that need it. All it takes to use such a script is to create a new MySQL database and to initiate the installation – as soon as the script configuration wizard receives access to the database in question and begins entering 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 run scripts that require MyISAM – the other popular MySQL engine, so you will not need to edit any settings on the dedicated server. This will permit you to run different scripts on one single physical machine and to use the latter to its full capacity.