InnoDB is a very popular storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has a lot of pluses that have made it the preferred engine for a lot of PHP-powered software applications, including Magento and Joomla™, which have shifted over to InnoDB permanently. For instance, importing huge amounts of data will be much faster with InnoDB, due to the fact that it locks only one database row to perform a certain operation, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is treated. Put simply, adding new or editing existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case a given issue shows up in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

Every open-source script-driven software application that needs InnoDB will run flawlessly on our innovative cloud website hosting platform and the MySQL storage engine is available with all our shared hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected based on the app’s requirements without having to edit any setting in your account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We’ll store daily backups of your content, so in case you unintentionally delete a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore your database the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the Control Panel offered with each of our semi-dedicated server accounts and you start installing a PHP-driven app either manually or using our one-click app installer tool, the storage engine for the database will be selected automatically depending on the given app’s requirements. Since InnoDB is available on the cloud hosting platform where your new account will be created, it will be set as the default engine for any application that requires it without any manual action needed on your end at any point. To avoid any chance of losing information if you update an application or if you remove a database by mistake, we’ll generate backups of all your databases every day, so if anything happens, we can rescue your data.

InnoDB in VPS

If you order a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an integral part of the default software bundle that will be pre-installed on your VPS server before we hand it over to you. You won’t need to configure anything manually and you will be able to enable and use any PHP-based app that requires InnoDB when your VPS is set up, which takes no more than 60 minutes after the order submission itself. A couple of engines are offered, so every time you create a database using the Hepsia hosting Control Panel, a particular engine will be selected once the app activation starts and our system will automatically detect which engine is required by the application in question. If you need to use MyISAM, for instance, you won’t have to do anything different than installing the preferred application, whether manually or using our app installer.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our custom-built Hepsia Control Panel include a software package that is pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t have to add it manually in case you want to run open-source PHP scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to initiate the installation – as soon as the installation wizard accesses the database and begins entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You will also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to modify any settings on the dedicated server. This will enable you to install various scripts on one single physical machine and to use the latter to its maximum potential.