InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it offers a better overall performance and a faster crash recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by plenty of web developers that write scalable web apps, as it works much more efficiently with enormous amounts of data, while it keeps the server load low. Also, it locks only a single row in the database in case any information should be modified, while lots of other engines lock the entire database table and therefore require more time to complete multiple successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla versions are two instances of widely used script-powered web apps that have moved to InnoDB.
InnoDB in Shared Hosting
Any PHP script-powered application that needs InnoDB will run flawlessly on our avant-garde cloud website hosting platform and the MySQL database storage engine is offered with all our shared hosting plans. Every time you create a 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 requirements without having to edit any setting in your account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We’ll carry out daily backups of your content, so if you unintentionally erase a database that you need or you overwrite some part of it, we will be able to restore everything the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our semi-dedicated plans by default, so the moment you obtain a new account, you can move on and activate any open-source script-based software application that needs the MySQL storage engine. A few engines are installed on our cloud website hosting platform, so when you set up a new database and start installing an application manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be picked depending on the respective app’s requirements. This will allow you to install and run InnoDB-specific applications without having to cope with any difficulty and without having to edit any settings in your semi-dedicated account. To take no chances, we will always keep a one-week-old backup of all your databases, so if you remove or edit any content accidentally, we can easily recover it.
InnoDB in VPS Servers
If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an integral part of the standard software bundle that will be installed on your VPS server before we hand it over to you. You will not need to configure anything manually and you’ll be able to install and use any script-driven software app that requires InnoDB when your Virtual Private Server is ready, which takes no more than one hour after the order procedure itself. Several engines are offered, so whenever you create a MySQL database through the Hepsia Control Panel, a specific engine will be picked once the app installation process commences and our system will automatically detect the engine that is required by the application in question. In case you need MyISAM, for instance, you won’t need to do anything different from installing the preferred app, whether manually or using our app installer.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s part of the default software package that we install on all Hepsia-equipped servers, so once your physical machine is assembled, you’ll be able to sign in and to activate any PHP script-driven web app that needs this database engine. When you create a new MySQL database via the Control Panel, there won’t be any activated engine till you start installing an app. Once the app setup wizard starts importing information into the database, the engine will be set automatically depending on the given app’s prerequisites, so you can use both MyISAM and InnoDB without having to select either one of them explicitly at any point. Therefore, you can make use of a huge collection of applications for your sites.