InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got a number of advantages which make it the engine of choice for many script-driven apps, among them Joomla and Magento, which have moved to InnoDB permanently. For example, adding enormous amounts of data will be much faster with InnoDB, since it locks only a single database row to carry out a particular task, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is tackled. Put simply, importing new or modifying existing data will either be fully completed, or will be aborted and the procedure will be rolled back if some issue appears in the meantime, which is why the content that remains in the database will not be damaged.
InnoDB in Shared Hosting
InnoDB is available with all our shared plans by default, not as a paid upgrade or upon request, so you can install and manage any open-source script-powered web app which requires the MySQL database storage engine without encountering any problem once you order your shared hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation, regardless of whether you make use of our single-click installer or create the database and activate the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll keep regular backups of all your databases, so you can rest assured that you won’t ever lose any content in case you delete a database accidentally or you overwrite some essential info – you’ll simply have to inform us and we’ll restore your content back to normal.
InnoDB in Semi-dedicated Servers
All our semi-dedicated plans include InnoDB and you can use all the features of this storage engine with any PHP script-driven software application that requires it. InnoDB is among the engines that are available on our cloud platform, so the one that will be picked depends on the particular app’s requirements. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer. To be on the safe side, we’ll perform daily MySQL database backups, so if something goes wrong following an upgrade or if you erase some data by mistake, we’ll be able to restore your database the way it was on any of the past seven days.
InnoDB in VPS Servers
If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the default software bundle that will be installed on your Virtual Private Server before we give it to you. You won’t have to set up anything manually and you will be able to enable and run any PHP-based app that requires InnoDB as soon as your Virtual Private Server is set up, which takes no more than sixty minutes after the order submission procedure itself. A few engines are offered, so whenever you create a MySQL database via the Hepsia Control Panel, a specific engine will be selected once the app installation process starts and our system will detect the engine that is required by the app in question. In case you need MyISAM, for instance, you will not need to do anything different than installing the desired application, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It’s included in the default software package that will be installed on all Hepsia-managed servers, so once your machine is assembled, you will be able to sign in and to activate any kind of PHP script-based app that needs this particular MySQL storage engine. When you set up a new MySQL database via the Control Panel, there won’t be any activated engine till you begin installing an application. Once the app configuration wizard starts dumping data in the database, the engine will be set automatically based on the requirements of the respective app, so you can use both InnoDB and MyISAM without having to select either one of them explicitly at any moment. Thus, you can use an extensive selection of applications for your sites.