InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP-driven software apps such as Magento and Joomla v3. It is perfect for scalable apps, since it works amazingly well when handling enormous volumes of data. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can complete a lot more tasks for the same period of time. Furthermore, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data imports and updates should be handled. In case a specific task hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the database content will remain undamaged and won’t be partially mixed with new content.

InnoDB in Shared Hosting

You will be able to use any PHP script-powered application that requires InnoDB if you have a Linux shared hosting service with us, as the MySQL database engine is available on our innovative cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can run applications which use the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be selected automatically, so you will not need to configure anything manually at any time. In addition, we’ll also carry out regular backups of all the databases that you have in the account, so if you erase or overwrite something, we can quickly get it back to 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 service by default, so once you get a new account, you can go on and install any script-based software app that needs this MySQL storage engine. Several engines are pre-installed on our cloud platform, so when you create a new database and begin installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be chosen based on the prerequisites of the particular app. This will allow you to activate and run InnoDB-specific apps without running into any predicament and without needing to change any settings in your semi-dedicated account. To avoid any risk, we’ll always have a one-week-old backup of all your MySQL databases, so if you remove or edit any content by mistake, we can swiftly retrieve it.

InnoDB in VPS Servers

If our custom Hepsia Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be activated on the Virtual Private Server along with other required software, so you will not have to do anything if you choose to manage open-source script-driven software applications that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand-new database and begin the app installation process manually or using our single-click installer. The system will recognize the engine that the app in question needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can import its content into that database. Thus, you can run apps with various requirements regarding the MySQL engine without the need to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

All dedicated service ordered with our in-house built Hepsia Control Panel include a software bundle that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you won’t have to add it manually in case you would like to activate open-source scripts that require it. All it takes to activate such a script is to create a new MySQL database and to begin the installation – once the installation wizard gets access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to activate scripts that need MyISAM, the other popular MySQL engine, so you won’t have to modify any settings on the dedicated server. This will permit you to run different scripts on one single server and to use it to its full potential.