InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a better overall performance and an improved crash recovery compared with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is preferred by plenty of programmers that write highly scalable apps, as it works much more efficiently with enormous amounts of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking in case any info should be modified, whereas lots of other engines lock the entire table and thus need more time to perform multiple consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for some reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest editions of Joomla are two examples of popular open-source script-based web apps which have moved to InnoDB.
InnoDB in Cloud Hosting
Any script-powered web application that needs InnoDB will function impeccably on our advanced cloud web hosting platform and the storage engine is available with all our cloud hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected on the basis of the app’s specifications without the need to change any setting in your account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to take advantage of its full potential. We will make regular content backups, so if you accidentally remove a database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your database the way it was just several hours earlier.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers come with InnoDB and you’ll be able to make the most of all the options offered by this MySQL database storage engine with any open-source script-based software application that needs it. It is among the engines that we have on our cloud platform, so the one that will be selected depends on the requirements of the given app. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click application installer tool. To avoid any risk, we’ll make daily database backups, so if something goes wrong after some update or if you erase some content by mistake, we will be able to get your database back to the way it was on any of the previous seven days.
InnoDB in Dedicated Servers
All dedicated servers ordered with our in-house developed Hepsia Control Panel come with a software package that is pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually if you need to run PHP scripts that require it. All it takes to install such a script is to set up a new database and to initiate the setup process – once the script setup wizard obtains access to the database in question and starts importing content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to install scripts that need the other very popular MySQL engine – MyISAM, so you won’t have to change any settings on the dedicated server. This will enable you to use various scripts on a single machine and to use the latter to its fullest capabilities.