InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a better overall performance and a faster database failure recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is endorsed by many developers that write highly scalable software applications, since it works more efficiently with enormous amounts of data, while it keeps the server processing load low. Furthermore, it it locks only one row in the database if any info should be modified, while lots of other engines lock the entire table and therefore need much more time to perform several consecutive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or the loss of data. Magento and the newest editions of Joomla™ are two instances of popular PHP-powered software apps that have switched to InnoDB.

InnoDB in Hosting

You will be able to use any script-powered application that needs InnoDB in case you have a Linux hosting with our company, as the storage engine is available on our cutting-edge cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is needed. You can install apps that need the MyISAM engine without any difficulty as well and, once again, the engine will be selected automatically, so you will not need to modify anything manually at any time. What’s more, we’ll also create daily backups of all the MySQL databases that you have in your shared web hosting account, so in case you erase or overwrite anything, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you will be able to make use of all the features offered by this MySQL storage engine with any script-powered software app that requires it. It is one of the engines that we have on our cloud web hosting platform, so the one that will be used depends on the prerequisites of the app in question. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click application installer. To be on the safe side, we’ll make regular MySQL database backups, so if anything goes wrong following an update or if you delete some content accidentally, we will be able to get your database back to the way it was on any of the past seven days.

InnoDB in VPS Servers

When you acquire a VPS server from our company, you’ll be able to take advantage of our custom-built Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to use any PHP script-driven web app which requires InnoDB, as the storage engine is included in the software bundle that will be installed on the Virtual Private Server during its setup. When you set up a brand new database via the hosting Control Panel, you will simply have to start installing an app – manually or using our app installer. InnoDB will be set as the default engine given that the application in question requires it, so you will not have to do anything else in your account. Equivalently, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you’ll be able to select any of the three hosting Control Panels offered by us – cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to enable this MySQL storage engine manually so as to be able to run script-driven web applications that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the system resources that you need to manage large-size sites, it’s rather likely that you will use InnoDB. You’ll be able to use other engines as well, so if a given app needs MyISAM rather than InnoDB, you will not have any complication while running it. The engine that will be used will be automatically detected once the app installation begins, so you will not need to edit any setting manually whatsoever.