InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has plenty of upsides that make it the engine of choice for a lot of open-source script-powered apps, among them Joomla™ and Magento, which have switched to InnoDB for good. For instance, importing immense data volumes will be faster with InnoDB, since it locks only a single database row to perform a specific task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is handled. Simply put, adding new or editing existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back if any problem shows up in the meantime, which is why the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

InnoDB is available with all our cloud hosting plans by default, not as a paid upgrade or upon request, so you will be able to activate and run any PHP script-driven web application that requires the MySQL database storage engine without the need to deal with any problem as soon as you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app activation, no matter if you take advantage of our one-click installer or create the MySQL database and activate the application manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll perform regular backups of all your databases, so you can be sure that you won’t ever lose any data in case you delete a database unintentionally or you overwrite some vital info – you just have to notify us and we’ll restore the database back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans support InnoDB and you will be able to take advantage of all the features of this database storage engine with any open-source script-powered software application that requires it. It is among the engines that we have on our cloud web hosting platform, so the one that will be used depends on the requirements of the specific 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 app – whether manually or using our single-click application installer tool. To avoid any risk, we will perform daily MySQL database backups, so if anything goes wrong following an update or if you delete some content by mistake, we’ll be able to get the database back to the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

If you purchase a new dedicated server, you will be able to choose one of the three hosting Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to add this MySQL storage engine manually in order to be able to run PHP-powered web applications that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you require in order to run large-size sites, it’s very likely that you will use InnoDB. You’ll be able to use other engines too, so in case a specific application requires MyISAM rather than InnoDB, you will not have to deal with any predicament while running it. The engine that will be used will be automatically recognized as soon as the app installation procedure commences, so you will not need to tweak any settings manually at any point.