InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a better overall performance and an improved database crash recovery compared with the default engine that is used by MySQL – MyISAM. InnoDB is used by a lot of devs that build scalable applications, as it works much more efficiently with large amounts of data, while it keeps the server processing load low. Moreover, it it locks only one row in the database if anything should be edited, whereas many other engines lock the entire database table and thus require much more time to execute several sequential tasks. Last, but not least, InnoDB follows 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™ editions are two instances of widespread script-driven web applications which have shifted over to InnoDB.
InnoDB in Shared Hosting
Any script-powered software app that requires InnoDB will function flawlessly on our avant-garde cloud hosting platform and the MySQL storage engine comes with all our shared hosting packages. Every time you create a MySQL 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 prerequisites without having to change any setting in your shared account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to make the most of its full potential. We’ll create regular backups of your content, so in case you accidentally remove a database that’s important to you or you overwrite some part of it, we will be able to restore everything the way it was only several hours earlier.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our semi-dedicated servers by default, so once you buy a new account, you can move on and install any script-powered software app that requires this particular MySQL database storage engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you create a new MySQL database and start installing an application manually, or opt to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen based on the requirements of the app in question. This will permit you to install and manage InnoDB-specific apps without needing to cope with any problem and without needing to modify any settings in your semi-dedicated account. To take no chances, we’ll always have a 7-day-old backup of all your MySQL databases, so if you remove or change any content by accident, we can swiftly retrieve it.
InnoDB in VPS Servers
If you get a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be part of the default software pack that will be pre-installed on your Virtual Private Server before we hand it over to you. You will not need to configure anything manually and you’ll be able to install and manage any script-driven software app that requires InnoDB once your Virtual Private Server is ready, which takes no more than 60 minutes after the order procedure itself. A couple of engines are available, so whenever you set up a database through the Hepsia hosting Control Panel, a specific engine will be selected when the app activation process commences and our system will automatically detect which engine is required by the app in question. If you need MyISAM, for instance, you won’t need to do anything different than installing the app of your preference, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
When you obtain a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to activate this database engine manually in order to be able to run script-based applications that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the server resources that you need to run large-size Internet sites, it is quite possible that you’ll resort to InnoDB. You will be able to use other engines as well, so in case a specific app needs MyISAM instead of InnoDB, you won’t need to deal with any predicament while using it. The engine that will be used will be automatically detected the moment the app installation procedure commences, so you won’t have to fine-tune any setting manually at any moment.