InnoDB is a popular storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has numerous strong sides which have made it the preferred engine for lots of open-source script-based web applications, such as Magento and Joomla™, which have moved to InnoDB permanently. For instance, importing large volumes of data will be faster with InnoDB, as it locks only one database row to carry out a given operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is handled. To put it simply, importing new or updating existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case any problem shows up during the process, which is why the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

InnoDB is available with all our shared website hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP script-based app that needs the InnoDB storage engine without the need to deal with any problem once you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation, regardless of whether you use our 1-click installation tool or create the MySQL database and activate the app manually, on the condition that the app requires it instead of the more famous MyISAM engine. We will carry out daily backups of all your databases, so you can rest assured that you’ll never lose any data in case you delete a database by accident or you overwrite some key info – you will simply need to notify us and we’ll restore the database back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is offered with each of our semi-dedicated servers by default, so as soon as you obtain a new account, you can go ahead and install any open-source script-powered web application that needs this particular MySQL storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you create a new MySQL database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated app installer, the engine for the database will be set based on the requirements of the respective app. This will allow you to install and run InnoDB-specific applications without having to deal with any impediment and without needing to modify any settings in your semi-dedicated account. To take no chances, we will always have a seven-day-old backup of all your databases, so if you remove or alter any content accidentally, we can swiftly restore it.

InnoDB in VPS Servers

When you get a VPS server from us, you will be able to use our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will allow you to run any PHP script-based web app which needs InnoDB, as this storage engine is included in the default software package that will be installed on your VPS server during its configuration. When you create a new MySQL database through the hosting Control Panel, you just need to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine if the app in question needs it, so you won’t have to do anything else in your VPS account. Likewise, if a given application needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database engine, so you will not need to install it manually if you wish to activate scripts that need it. All it takes to activate such a script is to create a new database and to initiate the setup – as soon as the script installation wizard accesses the database in question and starts entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to run scripts that need MyISAM – the other widely used MySQL engine, so you will not have to edit any settings on the server. This will enable you to run various scripts on one single server and to use the latter to its full potential.