InnoDB is a popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got a lot of advantages which have made it the engine of choice for a lot of PHP-powered web applications, including Joomla and Magento, which have shifted over to InnoDB permanently. For instance, importing huge data volumes will be much faster with InnoDB, as it locks only one row to accomplish a specific operation, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is tackled. In simpler words, importing new or updating existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case some problem occurs in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Cloud Hosting

You’ll be able to run any PHP-driven application that requires InnoDB if you have a cloud hosting with us, as the database engine is present on our cutting-edge cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can run applications that use the MyISAM engine without having any difficulty as well and, once again, the engine will be selected automatically, so you will not need to edit anything manually at any time. What’s more, we’ll also carry out daily backups of all the databases that you’ve got in your shared web hosting account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated servers by default, so once you purchase a new semi-dedicated account, you can move on and install any script-powered software application that needs this database engine. A couple of engines are installed on our cloud platform, so when you create a new MySQL database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be picked on the basis of the requirements of the respective app. This will allow you to install and run InnoDB-specific apps without running into any impediment and without the need to change any settings in your account. To be on the safe side, we will always have a one-week-old backup of all your databases, so if you erase or alter any content unintentionally, we can quickly recover it.

InnoDB in VPS Servers

When you buy a VPS server from us, you’ll be able to use our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will allow you to use any open-source script-powered software application which requires InnoDB, as the MySQL storage engine is part of the default software bundle that will be pre-installed on your Virtual Private Server during its creation. When you set up a brand new MySQL database via the hosting Control Panel, you’ll simply have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine if the application in question requires it, so you won’t need to do anything else in your account. In the same manner, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

InnoDB is included by default with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It is part of the software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is set up, you will be able to log in and to activate any script-based software application that needs this particular MySQL storage engine. When you set up a new MySQL database through the hosting Control Panel, there won’t be any active engine until you begin installing an app. As soon as the app setup wizard begins importing information into the database, the engine will be set automatically based on the requirements of the particular application, so you can run both MyISAM and InnoDB without having to select either of them explicitly at any point. Therefore, you can make use of a wide range of applications for your Internet sites.