InnoDB is a popular storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got a number of strengths which make it the engine of choice for many PHP script-based software apps, among them Joomla and Magento, which have moved to InnoDB for good. For instance, importing huge amounts of data will be much faster with InnoDB, since it locks only one database row to perform a given task, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is handled. Put simply, adding new or modifying existent data will either be entirely completed, or will be annulled and the procedure will be rolled back in case a certain problem occurs in the meantime, therefore the content that remains in the database won’t be lost.

InnoDB in Web Hosting

You will be able to activate any PHP script-driven software application that requires InnoDB if you’ve got a web hosting plan with our company, as the storage engine is present on our avant-garde cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can run apps which require the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be pre-selected, so you won’t need to edit anything manually at any time. On top of that, we’ll also create daily backups of all the databases that you have in the shared hosting account, so if you erase or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the Control Panel offered with all our semi-dedicated server accounts and you start installing a PHP-based web app either manually or using our one-click app installer tool, the database storage engine will be set automatically depending on the prerequisites of the specific application. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each app that requires it without the need for any manual intervention on your end at any point. To prevent any risk of losing info if you update an app or if you delete a database by accident, we’ll carry out a backup of all your databases each and every day, so if anything happens, we can rescue your content.

InnoDB in VPS Servers

When you buy a VPS server from us, you’ll be able to make use of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to run any open-source script-driven app which requires InnoDB, as this particular storage engine is an integral part of the standard software bundle that will be installed on your server during its configuration. When you create a new MySQL database using the Control Panel, you just have to start installing an app – manually or using our app installer. InnoDB will be set as the default engine on the condition that the app in question needs it, so you won’t need to do anything else in your VPS account. In the same manner, if a certain app needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is an essential part of the software package that we install on all Hepsia-managed servers, so as soon as your machine is assembled, you’ll be able to sign in and to install any open-source script-powered web application that needs this MySQL storage engine. If you set up a new MySQL database through the Control Panel, there won’t be any activated engine till you begin installing an application. Once the app installation wizard starts inserting data into the newly created database, the engine will be picked automatically depending on the requirements of the app in question, so you can use both InnoDB and MyISAM without the need to select either one of them explicitly at any moment. Therefore, you can use a vast range of apps for your Internet sites.