InnoDB is a popular database storage engine for MySQL. It is an alternative to the default MyISAM engine and it has numerous strong sides that make it the preferred engine for plenty of PHP-powered software apps, such as Joomla and Magento, which have moved to InnoDB for good. For example, adding immense volumes of data will be much faster with InnoDB, because it locks only a single database row to execute a certain task, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is handled. Put simply, adding new or editing existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case some problem appears in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

Any PHP-driven app that requires InnoDB will run impeccably on our cutting-edge cloud platform and the storage engine is offered with all our cloud hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected based on the app’s prerequisites without having to configure any setting in your shared 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 capacity. We’ll keep regular backups of your content, so if you accidentally remove a MySQL database that you need or you overwrite some part of it, we’ll be able to restore your database the way it was just several hours earlier.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers support InnoDB and you’ll be able to use all the options offered by this storage engine with any PHP script-driven software app that needs it. It’s among the engines that we have on our cloud hosting platform, so the one that will be used depends on the requirements of the specific application. You won’t have to do anything manually to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To be on the safe side, we’ll store regular MySQL database backups, so if anything goes wrong after an upgrade or if you remove some content unintentionally, we’ll be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS Servers

In case our custom-built Hepsia hosting Control Panel is picked during the signup process for a new VPS hosting plans , InnoDB will be installed on the server together with other necessary pieces of software, so you will not have to do anything if you decide to use PHP script-driven apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be activated too. You can create a brand-new database and start installing the app manually or using our one-click installer tool. The system will automatically detect which engine the particular application requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can dump its data in that database. Therefore, you can activate applications with various requirements regarding the MySQL engine without having to make any modifications on your VPS.

InnoDB in Dedicated Servers

If you get a new dedicated server, you will be able to pick any of the 3 hosting Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Any server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to add this MySQL database engine manually in order to be able to use script-driven applications that need it. InnoDB is used for scalable applications and since a dedicated server will give you all the system resources that you need in order to manage large-size Internet sites, it is very possible that you’ll resort to InnoDB. You will be able to make use of other engines too, so in case a certain app needs MyISAM instead of InnoDB, you won’t experience any complication while using it. The engine that will be used will be automatically detected once the app installation commences, so you will not have to update any setting manually at any moment.