What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a better overall performance and a faster database crash recovery in comparison with the default engine that is used by the MySQL database management system – MyISAM. InnoDB is preferred by lots of web developers that write highly scalable web apps, due to the fact that it works more efficiently with immense volumes of data, while it keeps the server load low. Additionally, it locks only one database row if anything should be edited, while lots of other engines lock the entire table and hence require much more time to carry out several sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed successfully for some reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla™ versions are two instances of widely used open-source script-driven software platforms which have shifted over to InnoDB.
InnoDB in Cloud Hosting
Any PHP-based application that requires InnoDB will run flawlessly on our cutting-edge cloud web hosting platform and the MySQL database storage engine is offered with all our cloud hosting
plans. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without the need to configure any setting in your web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to take advantage of its full capacity. We will generate daily content backups, so in case you unintentionally delete a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore your content the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting packages
support InnoDB and you will be able to get the most out of all the features offered by this database engine with any PHP script-based software app that requires it. It’s one of the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the prerequisites of the given application. You won’t need to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our 1-click application installer. To avoid any risk, we will perform daily backups of all your MySQL databases, so if anything goes wrong following some update or if you erase some data accidentally, we will be able to restore your database the way it was on any of the past 7 days.
InnoDB in Dedicated Hosting
InnoDB is available by default with all Linux dedicated servers hosting packages
ordered with the Hepsia Control Panel. It’s part of the standard software package that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is up and running, you will be able to sign in and to install a various open-source script-driven application that needs this storage engine. When you create a new MySQL database through the hosting Control Panel, there won’t be any active engine till you start installing an app. Once the app setup wizard starts importing information into the newly created database, the engine will be chosen automatically based on the requirements of the given app, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any moment. Thus, you can use an extensive variety of applications for your websites.