InnoDB is a popular database engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got plenty of advantages which make it the preferred engine for plenty of open-source script-driven apps, among them Joomla™ and Magento, which have moved to InnoDB permanently. For example, importing immense volumes of data will be faster with InnoDB, because it locks only one database row to complete a particular operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is tackled. In simpler words, importing new or modifying existing data will either be fully completed, or will be canceled and the operation will be rolled back if a certain problem appears during the process, which means that the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

While InnoDB is either not available or a paid upgrade with other web hosting providers, it is part of the default set of features offered with our shared website hosting packages. In case you would like to make use of a script-driven app that needs InnoDB particularly, in order to be installed and to perform correctly, you won’t have any impediments because the MySQL storage engine is available on our custom-developed cloud platform. No matter if you set up a new database and activate an app manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the app needs InnoDB rather than MyISAM. In addition to the excellent crash recovery that InnoDB offers, we also carry out regular backups of all databases, so that we can swiftly restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers include InnoDB and you can use all the options offered by this MySQL storage engine with any open-source script-driven web app that requires it. InnoDB is among the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the respective app. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To avoid any risk, we’ll perform daily backups of all your databases, so if something goes wrong following some update or if you delete some data accidentally, we’ll be able to restore the database the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you obtain a VPS server from us, you’ll be able to use our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will allow you to activate any PHP-powered app that requires InnoDB, as this MySQL storage engine is included in the default software bundle that will be pre-installed on your Virtual Private Server during its configuration. When you set up a new database using the hosting Control Panel, you’ll just need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine if the application in question requires it, so you will not need to do anything else in your account. Analogously, if an app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you will be able to choose one of the three hosting Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to enable this database engine manually in order to be able to use script-based web apps that require it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you need in order to run large-scale websites, it’s pretty likely that you will resort to InnoDB. You will be able to use other engines too, so in case a specific app requires MyISAM rather than InnoDB, you will not need to deal with any problem while using it. The engine that will be used will be automatically recognized as soon as the app installation procedure begins, so you will not need to change any setting manually whatsoever.