InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it provides a better overall performance and a faster database failure recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by plenty of developers that write highly scalable apps, since it works more effectively with enormous amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single row in the database if anything should be modified, whereas lots of other engines lock the entire table and therefore require much more time to complete several consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest Joomla versions are two examples of famous open-source script-based web applications that have switched to InnoDB.
InnoDB in Cloud Hosting
InnoDB is offered with all our Linux cloud hosting packages by default, not as a paid upgrade or upon request, so you can activate and manage any PHP-driven web app that needs the InnoDB database engine without any obstacles as soon as you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation, regardless of whether you make use of our one-click installer or create the MySQL database and activate the application manually, provided that the app requires it instead of the more popular MyISAM engine. We’ll maintain daily backups of all your databases, so you can be sure that you’ll never lose any data if you delete a database accidentally or you overwrite some key information – you’ll just have to notify us and we’ll restore your database the way it was.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting packages come with InnoDB and you can take full advantage of all the features of this database storage engine with any open-source script-driven web app that needs it. It’s one of the engines that we have on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the specific app. You will not need to do anything manually to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To avoid any risk, we will keep regular database backups, so if something goes wrong following an update or if you remove some content accidentally, we’ll be able to get the database back to the way it was on any of the previous 7 days.
InnoDB in Dedicated Hosting
All Linux dedicated servers hosting packages ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually if you need to use open-source scripts that require it. All it takes to use such a script is to create a new database and to start the installation process – as soon as the script setup wizard accesses the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You’ll also be able to activate scripts that need the other very popular MySQL engine, MyISAM, so you will not need to edit any settings on the dedicated server. This will enable you to use different scripts on a single machine and to use the latter to its fullest capabilities.