InnoDB is a storage engine for MySQL relational databases, which is used by widely used script-powered software apps such as Joomla 3 and Magento. It is excellent for scalable apps, since it works exceptionally well when processing huge volumes of data. Rather than locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same length of time. Plus, InnoDB offers an improved crash recovery and supports database transactions and foreign key constraints – rules that specify how data inserts and modifications should be treated. In case a specific operation hasn’t been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will remain safe and sound and won’t be partially mixed with new content.

InnoDB in Shared Hosting

InnoDB is available with all our Linux shared hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP-powered software application which needs the database engine without any problem once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app activation, irrespective of whether you make use of our single-click installation tool or create the MySQL database and activate the app manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We’ll carry out daily database backups, so you can be certain that you won’t ever lose any content if you erase a database accidentally or you overwrite some important info – you simply need to get in touch with us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated plans come with InnoDB and you will be able to take full advantage of all the features offered by this database storage engine with any PHP script-based web app that requires it. It is one of the engines that we have on our cloud hosting platform, so the one that will be selected depends on the given app’s requirements. You won’t have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To avoid any risk, we’ll store daily MySQL database backups, so if something goes wrong after an upgrade or if you delete some data accidentally, we’ll be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you purchase a VPS server from us, you’ll be able to make use of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to manage any PHP-based software app that requires InnoDB, as this particular storage engine is an integral part of the default software bundle that will be installed on your server during its setup. When you set up a new database using the hosting Control Panel, you’ll just need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you will not have to do anything else in your account. Likewise, if a given application needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Servers

When you get a new dedicated server, you will be able to pick one of the 3 Control Panels that we are offering – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to add this storage engine manually so as to be able to manage open-source script-based applications that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the resources that you require in order to run very large Internet sites, it is very likely that you will use InnoDB. You’ll be able to make use of other engines too, so in case a particular application needs MyISAM rather than InnoDB, you will not run into any difficulty while using it. The engine that will be used will be automatically recognized the moment the app installation process commences, so you won’t need to update any settings manually at any moment.