InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is used by a lot of developers that write highly scalable software apps, since it works much more effectively with huge data volumes, while it keeps the server load low. Also, it locks only one database row if any info should be updated, while lots of other engines lock the entire table and thus need much more time to accomplish multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification cannot be completed for some reason, the action is rolled back to prevent confusion or data loss. Magento and the newest releases of Joomla™ are two examples of widely used PHP-based apps which have moved to InnoDB.

InnoDB in Hosting

InnoDB is offered with all our Linux hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any open-source script-driven software application that requires the storage engine without having to deal with any impediment once you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation, no matter if you take advantage of our one-click installer or create the MySQL database and set up the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll keep daily backups of all your databases, so you can be certain that you will never lose any content if you erase a database by accident or you overwrite some key information – you just have to touch base with us and we will restore everything back to normal.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting packages include InnoDB and you’ll be able to use all the features of this MySQL database storage engine with any PHP-powered application that requires it. It is among the engines that we have on our cloud hosting platform, so the one that will be picked depends on the given app’s prerequisites. You won’t need to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click app installer tool. To be on the safe side, we’ll keep daily MySQL database backups, so if something goes wrong after an update or if you delete some data accidentally, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in Dedicated Hosting

If you get a new dedicated server, you will be able to choose one of the 3 hosting Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to enable this MySQL database engine manually to be able to use open-source script-driven software apps that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you need in order to manage large-scale websites, it’s rather likely that you will use InnoDB. You’ll be able to make use of other engines too, so if a particular application needs MyISAM rather than InnoDB, you won’t need to deal with any difficulty while managing it. The engine that will be used will be automatically detected the moment the app installation procedure commences, so you will not need to configure any setting manually whatsoever.