InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it provides a significantly better overall performance and a faster database crash recovery in comparison with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is used by numerous developers that create highly scalable software apps, since it works much better with large volumes of data, while it keeps the server processing load low. Furthermore, it it locks only one row in the database if any info should be updated, whereas lots of other engines lock the entire database table and hence require much more time to accomplish several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – 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 latest versions of Joomla are two instances of famous open-source script-powered software platforms that have moved to InnoDB.
InnoDB in Web Hosting
InnoDB is offered with all our Linux web hosting by default, not as a paid upgrade or upon request, so you can install and run any PHP script-powered web app that requires the MySQL storage engine without having to deal with any difficulty as soon as you open your account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, regardless of whether you use our 1-click installation tool or create the database and set up the app manually, provided that the application requires it instead of the more popular MyISAM engine. We will generate regular database backups, so you can be certain that you’ll never lose any data if you erase a database unintentionally or you overwrite some vital information – you’ll simply have to touch base with us and we’ll restore your content back to normal.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our Linux semi-dedicated service by default, so once you get a new semi-dedicated account, you can go ahead and activate any PHP-powered application that requires this MySQL storage engine. A few engines are pre-installed on our cloud website hosting platform, so when you set up a new MySQL database and begin installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be chosen in accordance with the prerequisites of the respective application. This will permit you to activate and run InnoDB-specific applications without the need to deal with any problem and without the need to modify any settings in your semi-dedicated account. To avoid any risk, we will always keep a seven-day-old backup of all your databases, so if you remove or alter any content unintentionally, we can quickly recover it.
InnoDB in VPS Servers
If you get a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the software bundle that will be pre-installed on your server before we give it to you. You will not need to set up anything manually and you will be able to enable and manage any script-powered application that needs InnoDB when your Virtual Private Server is up and running, which takes no more than one hour after the order procedure itself. A number of engines are offered, so anytime you create a MySQL database through the Hepsia Control Panel, a specific engine will be selected when the app activation process begins and our system will automatically detect which engine is required by the application in question. In case you need MyISAM, for example, you won’t have to do anything different than installing the chosen application, whether manually or using our application installer.
InnoDB in Dedicated Servers
When you acquire a new dedicated server, you’ll be able to select any of the 3 Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to enable this database engine manually in order to be able to manage script-powered web applications that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you require in order to run large-scale sites, it’s pretty possible that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so if a given application needs MyISAM instead of InnoDB, you won’t come across any impediment while managing it. The engine that will be used will be detected automatically once the app installation starts, so you won’t need to configure any settings manually at any point.