InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has lots of pluses which have made it the engine of choice for lots of open-source script-based apps, including Joomla™ and Magento, which have moved to InnoDB for good. For example, adding immense amounts of data will be much faster with InnoDB, because it locks only one database row to perform a specific task, 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 modifying existing data will either be entirely completed, or will be aborted and the operation will be rolled back in case some problem occurs during the process, hence the content that remains in the database won’t be lost.

InnoDB in Cloud Website Hosting

InnoDB is available with all our cloud website hosting service by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP script-powered app which requires the MySQL storage engine without any difficulties as soon as you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, no matter if you make use of our single-click installer or create the MySQL database and install the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll make daily backups of all your databases, so you can rest assured that you won’t ever lose any content if you erase a database accidentally or you overwrite some crucial information – you’ll just have to notify us and we’ll restore your data the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you can take advantage of all the options offered by this database engine with any script-driven software application that requires it. It is among the engines that are available on our cloud web hosting platform, so the one that will be used depends on the requirements of the application in question. You will not have to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer. To avoid any risk, we’ll maintain regular MySQL database backups, so if something goes wrong following an upgrade or if you erase some content by accident, we will be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS Servers

If you get a VPS server from us, you will be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to run any PHP script-powered application which needs InnoDB, as the database engine is included in the software bundle that will be installed on the server during its configuration. When you set up a brand new database via the hosting Control Panel, you will simply have to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you won’t have to do anything else in your account. Analogously, if an app needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you will be able to pick one of the three hosting Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to activate this storage engine manually so as to be able to run script-driven software applications that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the resources that you need in order to run very large sites, it is very likely that you’ll resort to InnoDB. You’ll be able to use other engines as well, so in case a particular application needs MyISAM instead of InnoDB, you won’t have to deal with any predicament while running it. The engine that will be used will be recognized automatically the moment the app installation procedure starts, so you won’t have to modify any settings manually at any time.