InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is used by numerous web developers that create highly scalable web applications, due to the fact that it works better with huge amounts of data, while it keeps the server load low. Also, it locks only a single database row in case any information should be edited, whereas lots of other engines lock the entire table and hence need more time to handle multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the newest Joomla editions are two examples of famous open-source script-driven software applications that have shifted over to InnoDB.
InnoDB in Shared Hosting
Every open-source script-driven software application that requires InnoDB will run flawlessly on our advanced cloud hosting platform and the MySQL storage engine is available with all our shared hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to update any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll carry out daily backups of your content, so in case you unintentionally remove a MySQL database that you need or you overwrite a specific part of it, we’ll be able to restore your content the way it was just a few hours earlier.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers include InnoDB and you will be able to use all the options offered by this database engine with any script-based application that requires it. It is one of the engines that we have on our cloud website hosting platform, so the one that will be selected depends on the requirements of the specific app. You won’t have to do anything manually in order to enable InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we’ll carry out daily database backups, so if anything goes wrong after an update or if you delete some content by accident, we’ll be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS Servers
If you get a VPS server from our company, you will be able to use our custom Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to run any script-powered web application that requires InnoDB, as the database engine is an integral part of the standard software package that will be installed on the VPS server during its setup. When you set up a brand new database using the hosting Control Panel, you will simply need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine in case the application in question requires it, so you will not need to do anything else in your account. Likewise, if a given application requires MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Servers
When you purchase a new dedicated server, you will be able to select one of the three Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to activate this MySQL storage engine manually to be able to use open-source script-driven web apps that require it. InnoDB is used by scalable applications and since a dedicated server will give you all the system resources that you need to run large-size sites, it is very likely that you will resort to InnoDB. You’ll be able to make use of other engines as well, so if a certain app needs MyISAM instead of InnoDB, you will not experience any complication while running it. The engine that will be used will be detected automatically when the app installation process commences, so you will not have to alter any settings manually whatsoever.