InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got lots of strengths which make it the engine of choice for lots of open-source script-based apps, among them Joomla and Magento, which have shifted over to InnoDB for good. For example, importing large amounts of data will be faster with InnoDB, because it locks only a single database row to complete a given task, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. In simpler words, importing new or editing existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a given issue appears in the meantime, hence the content that remains in the database will not be damaged.

InnoDB in Cloud Website Hosting

You can make use of any PHP-based app that requires InnoDB in case you’ve got a cloud website hosting plan with us, as the MySQL database storage engine is available on our advanced cloud website hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is needed. You can activate apps that need the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be pre-selected, so you will not need to change anything manually at any point. In addition, we’ll also create regular backups of all the databases that you have in the shared account, so in case you erase or overwrite anything, we can swiftly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

InnoDB is offered with each of our semi-dedicated hosting plans by default, so the moment you create a new account, you can go ahead and activate any PHP script-driven app that requires the MySQL database storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a brand-new MySQL database and start installing an app manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be selected on the basis of the prerequisites of the particular app. This will permit you to install and run InnoDB-specific apps without coming across any complication and without the need to modify any settings in your account. To take no chances, we’ll always keep a one-week-old backup of all your MySQL databases, so if you delete or change any content unintentionally, we can quickly rescue it.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you will be able to select any of the 3 Control Panels that we’re offering – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to add this database engine manually so as to be able to manage PHP-powered applications that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the resources that you need in order to manage large-scale sites, it is very likely that you’ll use InnoDB. You’ll be able to make use of other engines as well, so in case a specific app requires MyISAM rather than InnoDB, you won’t need to deal with any problem while managing it. The engine that will be used will be detected automatically the moment the app installation procedure begins, so you will not have to change any setting manually at any moment.