InnoDB is a database engine for MySQL databases, which is used by well known PHP-powered web applications like Joomla 3.x and Magento. It is excellent for scalable apps, since it performs unbelievably well when handling large data volumes. Rather than locking the entire table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more operations for the same length of time. Additionally, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – a set of rules that indicate how data inserts and updates should be handled. If a specific task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and will not be partially merged with newly appended content.

InnoDB in Cloud Hosting

You’ll be able to use any open-source script-driven app that needs InnoDB if you have a cloud hosting with us, as the MySQL database storage engine is available on our leading-edge cloud platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can activate applications that need the MyISAM engine without having to deal with any difficulty as well and, again, the engine will be selected automatically, so you won’t have to edit any setting manually at any point. What’s more, we will also carry out daily backups of all the MySQL databases that you’ve got in your account, so in case you delete or overwrite anything, we can quickly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated services support InnoDB and you can make the most of all the features of this MySQL database storage engine with any PHP script-powered software application that needs it. It is among the engines that we have on our cloud platform, so the one that will be used depends on the requirements of the given application. You won’t have to do anything manually to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our one-click app installer tool. To be on the safe side, we’ll generate daily backups of all your MySQL databases, so if something goes wrong after an update or if you remove some content unintentionally, we will be able to restore the database the way it was on any of the past 7 days.

InnoDB in VPS

If you obtain a virtual private server from us, you’ll be able to use our in-house built Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to manage any PHP script-based app that requires InnoDB, as the MySQL database storage engine is an essential part of the software package that will be pre-installed on the server during its setup. When you set up a new MySQL database through the Control Panel, you’ll simply have to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine if the app in question requires it, so you will not have to do anything else in your account. Equivalently, if a certain application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Hosting

InnoDB is included by default with all dedicated hosting services ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed servers, so once your machine is assembled, you’ll be able to sign in and to install a various script-driven software app that requires this particular database storage engine. When you create a new database through the hosting Control Panel, there won’t be any activated engine till you start installing an application. As soon as the app setup wizard begins dumping information in the newly created database, the engine will be set automatically on the basis of the requirements of the particular application, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any time. Therefore, you can use an immense range of apps for your Internet sites.