InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a better overall performance and an improved crash recovery in comparison to the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by numerous devs that run scalable applications, since it works more effectively with enormous amounts of data, while it keeps the server processing load at a minimum. What’s more, it locks only one database row in case any info should be modified, while many other engines lock the entire database table and hence need more time to fulfill multiple consecutive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification process cannot be completed for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest editions of Joomla are two examples of popular open-source script-powered applications that have moved to InnoDB.
InnoDB in Shared Hosting
InnoDB is offered with all our Linux shared hosting packages by default, not as a paid upgrade or upon request, so you will be able to activate and manage any script-based web app that requires the database storage engine without having to deal with any problem as soon as you activate your account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation, regardless of whether you take advantage of our single-click installation tool or create the database and install the app manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll make daily backups of all your databases, so you can rest assured that you won’t ever lose any data if you delete a database accidentally or you overwrite some vital info – you’ll simply need to contact us and we’ll restore your data back to normal.
InnoDB in Semi-dedicated Hosting
You can run a PHP script-driven software application that needs InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our leading-edge cloud platform where the MySQL database engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our one-click app installer. Either way, the needed engine will be selected automatically as soon as the app’s installation starts, so you won’t need to update anything manually, irrespective of whether the application requires InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to retrieve any of your databases if you delete one by accident, as we create a few database backups every day, each of which is stored for 7 days.
InnoDB in VPS
If you get a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the software package that will be installed on your Virtual Private Server before we hand it over to you. You will not have to configure anything manually and you’ll be able to enable and use any PHP script-driven app that needs InnoDB once your VPS server is set up, which takes no more than 1 hour after the order procedure itself. A couple of engines are available, so anytime you set up a MySQL database through the Hepsia hosting Control Panel, a particular engine will be activated when the app activation process starts and our system will automatically recognize the engine that is required by the application in question. In case you need to use MyISAM, for example, you won’t have to do anything different than installing the preferred application, whether manually or using our application installer.
InnoDB in Dedicated Hosting
If you purchase a new dedicated server, you’ll be able to choose any of the 3 Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to install this MySQL storage engine manually to be able to manage PHP-powered apps that require it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the system resources that you need in order to manage large-scale Internet sites, it’s pretty possible that you will use InnoDB. You will be able to use other engines as well, so if a given application requires MyISAM rather than InnoDB, you won’t encounter any difficulty while running it. The engine that will be used will be automatically recognized when the app installation process begins, so you won’t need to change any settings manually at any moment.