InnoDB is a database engine for MySQL databases, which is used by popular script-based software applications like Magento and Joomla™ 3.x. It’s ideal for scalable apps, since it works astonishingly well when processing huge amounts of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same length of time. Plus, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that prescribe how data inserts and updates should be treated. If a specific operation hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the content in the database will be kept undamaged and won’t be partially merged with newly inserted content.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many hosting providers, it’s an essential part of the standard set of features that we are offering with our shared hosting packages. In case you wish to make use of an open-source script-driven web app that requires InnoDB in particular, in order to be activated and to perform correctly, you won’t have to deal with any problems as the database storage engine is available on our custom-developed cloud platform. No matter if you set up a brand new database and install an app manually or make use of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given application requires InnoDB instead of MyISAM. Besides the incredible crash recovery offered by InnoDB, we also store regular backups of all databases, so we can quickly restore any database in your shared account.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our Linux semi-dedicated hosting packages by default, so as soon as you purchase a new semi-dedicated account, you can go on and activate any PHP-powered web application that requires this particular MySQL database engine. A number of engines are installed on our cloud web hosting platform, so when you create a brand-new database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set depending on the prerequisites of the particular app. This will allow you to activate and manage InnoDB-specific applications without having any complication and without the need to modify any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a 1-week-old backup of all your databases, so if you remove or alter any content by accident, we can swiftly retrieve it.
InnoDB in VPS
If you order a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the standard software pack that will be installed on your server before we hand it over to you. You will not have to set up anything manually and you’ll be able to install and run any PHP script-based web application that needs InnoDB when your VPS is up and running, which takes no more than 1 hour after the order submission itself. Several engines are offered, so whenever you set up a database using the Hepsia hosting Control Panel, a specific engine will be activated once the app installation starts and our system will automatically recognize the engine that is required by the application in question. If 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 obtain a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to add this MySQL database engine manually so as to be able to run PHP-based software applications that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the server resources that you require in order to manage very large websites, it’s very possible that you will resort to InnoDB. You will be able to make use of other engines as well, so if a given application needs MyISAM rather than InnoDB, you will not experience any problem while using it. The engine that will be used will be automatically recognized as soon as the app installation begins, so you won’t need to alter any setting manually at any time.