InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has numerous advantages which make it the preferred engine for plenty of script-powered software applications, such as Joomla and Magento, which have shifted over to InnoDB permanently. For instance, adding immense data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to carry out an operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is treated. In simpler words, appending new or updating existent data will either be fully completed, or will be aborted and the procedure will be rolled back if some issue occurs during the process, hence the content that remains in the database will not be lost.

InnoDB in Hosting

You can make use of any PHP script-driven software application that needs InnoDB if you’ve got a hosting plan with us, as the storage engine is available on our advanced cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is required. You can install applications which require the MyISAM engine without encountering any impediment as well and, again, the engine will be selected automatically, so you won’t need to edit anything manually at any point. Furthermore, we’ll also perform regular backups of all the databases that you have in your account, so if you erase or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database through the Control Panel included with all our semi-dedicated server plans and you start installing a script-powered software application either manually or using our 1-click application installer tool, the database storage engine will be picked automatically based on the requirements of the particular application. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without any manual action required on your end at any moment. To avoid any risk of losing info if you update an app or if you delete a database by accident, we’ll generate backups of all your databases each and every day, so if something happens, we can restore your data.

InnoDB in VPS Servers

If our in-house developed Hepsia hosting Control Panel is chosen during the registration process for your new VPS hosting plans , InnoDB will be activated on the VPS server along with other essential pieces of software, so you won’t have to do anything if you decide to activate PHP script-driven applications that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can create a brand new MySQL database and begin the app installation process manually or using our one-click installer. The system will automatically detect which engine the particular app needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can import its data into that database. Therefore, you can manage applications with various prerequisites concerning the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is included in the software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your machine is ready, you’ll be able to sign in and to install a various open-source script-powered software application that needs this particular database engine. If you create a new database through the hosting Control Panel, there won’t be any active engine until you start installing an app. As soon as the app configuration wizard starts inserting content into the database, the engine will be chosen automatically depending on the particular app’s prerequisites, so you can run both MyISAM and InnoDB without having to select either of them specifically at any moment. In this way, you can make use of an extensive selection of apps for your Internet sites.