InnoDB is a popular database engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has got lots of advantages which make it the engine of choice for many PHP-powered web applications, such as Magento and Joomla™, which have switched over to InnoDB for good. For example, adding large data volumes will be faster with InnoDB, due to the fact that it locks only one database row to execute a specific 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 way in which the info is treated. Put simply, appending new or updating existing data will either be entirely completed, or will be aborted and the procedure will be rolled back if a given issue occurs during the process, so the content that remains in the database will not be lost.

InnoDB in Cloud Website Hosting

Every PHP script-driven web app that needs InnoDB will run flawlessly on our advanced cloud hosting platform and the storage engine comes with all our cloud website hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected on the basis of the app’s requirements without the need to modify any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to take advantage of its full capacity. We will keep daily content backups, so if you unintentionally erase a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore everything the way it was just several hours earlier.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers include InnoDB and you’ll be able to get the most out of all the features of this MySQL database engine with any script-based application that needs it. It’s one of the engines that are available on our cloud platform, so the one that will be picked depends on the particular app’s prerequisites. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To be on the safe side, we will perform regular backups of all your databases, so if anything goes wrong after an update or if you erase some content by mistake, we’ll be able to restore your database the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is selected during the registration process for a new VPS servers , InnoDB will be installed on the VPS server together with other essential pieces of software, so you will not need to do anything if you choose to manage script-driven apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can create a new database and start the app installation process manually or using our 1-click installer. The system will automatically detect the engine that the particular application needs and will set it for the specific database, so the installation process will proceed impeccably and the app can import its content into that database. In this way, you can make use of applications with various requirements regarding the MySQL engine without the need to make any modifications on your VPS.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you’ll be able to pick one of the three Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to add this database storage engine manually in order to be able to manage script-based apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you require in order to run very large Internet sites, it’s rather likely that you will resort to InnoDB. You’ll be able to use other engines as well, so if a given application needs MyISAM rather than InnoDB, you will not experience any complication while using it. The engine that will be used will be detected automatically the moment the app installation process commences, so you won’t have to update any settings manually at any moment.