InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a much better overall performance and a faster database failure recovery in comparison to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by plenty of developers that write scalable web applications, since it works much better with large data volumes, while it keeps the server load low. What’s more, it locks only a single database row in case any info should be edited, whereas lots of other engines lock the entire database table and hence require much more time to process multiple successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for some reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest editions of Joomla are two examples of popular open-source script-based software applications which have switched over to InnoDB.
InnoDB in Web Hosting
Every PHP script-powered app that needs InnoDB will function flawlessly on our avant-garde cloud web hosting platform and the storage engine is offered with all our web 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 in accordance with the app’s requirements without the need to modify any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We will store regular content backups, so in case you accidentally remove a database that you need or you overwrite a specific part of it, we’ll be able to restore your database the way it was only several hours earlier.
InnoDB in Semi-dedicated Hosting
If you create a brand new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server plans and you start installing a PHP-powered web application either manually or using our 1-click app installer, the storage engine for the MySQL database will be picked automatically on the basis of the requirements of the app in question. As InnoDB is present on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without the need for any manual intervention on your end at any point. To prevent any chance of losing info if you update an app or if you remove a database accidentally, we will carry out a backup of all your databases each and every day, so if anything happens, we can retrieve your data.
InnoDB in VPS Web Hosting
If you order a virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an essential part of the standard software bundle that will be installed on your VPS server before we hand it over to you. You will not need to set up anything manually and you will be able to install and use any open-source script-based web application that requires InnoDB once your VPS is ready, which takes no more than one hour after the order procedure itself. A number of engines are available, so every time you create a MySQL database via the Hepsia Control Panel, a specific engine will be selected when the app activation begins and our system will automatically detect which engine is required by the application in question. If you need MyISAM, for example, you won’t need to do anything different from installing the chosen application, whether manually or using our app installer.
InnoDB in Dedicated Servers Hosting
InnoDB is included as standard with all dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It’s part of the standard software bundle that will be installed on all Hepsia-equipped dedicated servers, so once your machine is up and running, you will be able to sign in and to activate any kind of PHP-powered application that requires this storage engine. When you create a new database through the Control Panel, there won’t be any activated engine until you start installing an application. Once the app activation wizard starts importing data into the newly created database, the engine will be picked automatically in accordance with the particular app’s prerequisites, so you can run both InnoDB and MyISAM without having to select either of them specifically at any time. Therefore, you can make use of a vast collection of apps for your Internet sites.