InnoDB is a popular storage engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has lots of pluses which make it the preferred engine for many PHP script-powered applications, including Magento and Joomla, which have switched over to InnoDB permanently. For instance, adding large volumes of data will be much faster with InnoDB, because it locks only one row to execute a particular task, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Simply put, adding new or editing existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case some problem shows up in the meantime, thus the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many other hosting service providers, it is included in the standard set of services that we are offering with our shared hosting plans. If you wish to make use of an open-source script-driven software app that requires InnoDB specifically, in order to be activated and to operate correctly, you won’t come across any obstacles as the InnoDB database storage engine is available on our custom cloud Internet hosting platform. No matter if you create a new MySQL database and activate an application manually or use our single-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs InnoDB rather than MyISAM. Besides the exceptional crash recovery that InnoDB offers, we also store daily backups of all databases, so that we can swiftly recover any database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the hosting Control Panel coming with all our semi-dedicated server plans and you start installing an open-source script-powered web app either manually or using our one-click application installer tool, the storage engine for the MySQL database will be picked automatically based on the specific app’s requirements. Since InnoDB is available on the cloud web hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without any manual intervention needed on your end at any point. To prevent any risk of losing information if you update an application or if you remove a database accidentally, we’ll carry out backups of all your databases every day, so if something happens, we can rescue your content.

InnoDB in VPS

If our custom Hepsia Control Panel is selected during the signup process for a new Linux VPS packages , InnoDB will be installed on the Virtual Private Server along with other essential pieces of software, so you will not need to do anything if you decide to use PHP script-based software applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand new MySQL database and begin the app installation procedure manually or using our one-click installation tool. The system will recognize which engine the application in question requires and will assign it to the specific MySQL database, so the installation process will continue impeccably and the app can insert its content into that database. Thus, you can use apps with various prerequisites concerning the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Hosting

InnoDB is available as standard with all dedicated servers hosting packages ordered with the Hepsia hosting Control Panel. It’s an essential part of the default software package that will be installed on all Hepsia-equipped dedicated servers, so once your machine is ready, you’ll be able to sign in and to install a various PHP script-powered web application that needs this database engine. When you create a new MySQL database through the Control Panel, there won’t be any activated engine until you start installing an application. As soon as the app setup wizard begins dumping data in the database, the engine will be selected automatically in accordance with the respective app’s prerequisites, so you can use both MyISAM and InnoDB without having to select either one explicitly at any point. In this way, you can make use of an extensive selection of apps for your Internet sites.