InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a better overall performance and an improved database failure recovery compared to the default engine used by MySQL – MyISAM. InnoDB is endorsed by lots of web developers that write highly scalable software applications, since it works much better with large volumes of data, while it keeps the server load at a minimum. Furthermore, it locks only a single row in the database if any info should be modified, while many other engines lock the entire table and thus require much more time to complete several consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla releases are two instances of famous PHP-powered software apps that have switched over to InnoDB.

InnoDB in Cloud Hosting

You’ll be able to activate any open-source script-driven software application that requires InnoDB if you’ve got a cloud hosting with our company, as the MySQL storage engine is present on our advanced cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can run applications that need the MyISAM engine without having to deal with any problem as well and, once again, the engine will be pre-selected, so you won’t have to change anything manually at any point. What’s more, we will also make daily backups of all the MySQL databases that you have in your shared web hosting account, so in case you delete or overwrite anything, we can easily get it back to the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you’ll be able to pick any of the three Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to install this MySQL storage engine manually to be able to use PHP script-driven web apps that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the server resources that you require to manage very large websites, it is pretty possible that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so if a specific app requires MyISAM rather than InnoDB, you will not need to deal with any predicament while using it. The engine that will be used will be automatically detected as soon as the app installation starts, so you won’t need to modify any setting manually whatsoever.