InnoDB is a popular database engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has plenty of strengths that have made it the preferred engine for plenty of PHP script-based apps, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, adding large volumes of data will be faster with InnoDB, as it locks only a single database row to carry out a particular task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is treated. In simpler words, appending new or updating existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case a certain issue appears during the process, so the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many other hosting service providers, it is an essential part of the standard set of features that we offer with our shared hosting packages. In case you wish to use a PHP script-powered app that needs InnoDB specifically, in order to be activated and to work properly, you won’t come across any impediments since the MySQL database engine is available on our in-house built cloud hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an app manually or use our one-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app needs it rather than MyISAM. Besides the excellent crash recovery that InnoDB offers, we also perform regular backups of all databases, so that we can easily restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting support InnoDB and you can take full advantage of all the features offered by this storage engine with any open-source script-based web app that needs it. It is among the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the prerequisites of the given application. You will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our single-click app installer. To avoid any risk, we’ll generate daily backups of all your databases, so if anything goes wrong following an upgrade or if you erase some content accidentally, we will be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS Hosting

If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the standard software bundle that will be installed on your Virtual Private Server before we give it to you. You won’t need to activate anything manually and you’ll be able to install and manage any script-based app that needs InnoDB as soon as your VPS is ready, which takes no more than sixty minutes after the order submission procedure itself. Several engines are available, so whenever you create a MySQL database via the Hepsia Control Panel, a particular engine will be activated when the app activation starts and our system will detect which engine is required by the application in question. If you have to use MyISAM, for example, you won’t have to do anything different from installing the desired app, whether manually or using our app installer tool.

InnoDB in Dedicated Web Hosting

If you acquire a new dedicated server, you’ll be able to pick any of the three Control Panels that we offer – cPanel, Hepsia and DirectAdmin. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to install this database engine manually so as to be able to run open-source script-driven software applications that require it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you require to manage large-scale Internet sites, it is rather possible that you’ll use InnoDB. You’ll be able to make use of other engines as well, so if a certain application requires MyISAM instead of InnoDB, you will not experience any complication while managing it. The engine that will be used will be automatically recognized the moment the app installation procedure starts, so you won’t need to update any settings manually at any point.