InnoDB is a database storage engine for MySQL databases, which is used by widely used PHP-based software apps such as Magento and Joomla™ 3.x. It’s ideal for scalable applications, as it works stunningly well when handling large volumes of data. Rather than locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same length of time. Also, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be treated. In case a given task hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will be retained intact and won’t be partially mixed with newly appended content.

InnoDB in Shared Website Hosting

While InnoDB is either not offered or it is a paid upgrade with other website hosting service providers, it’s an integral part of the default set of features that we are offering with our shared website hosting packages. In case you would like to use a script-powered application that requires InnoDB specifically, in order to be installed and to work correctly, you won’t have any impediments as the MySQL storage engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you create a brand new MySQL database and activate an app manually or take advantage of our 1-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs InnoDB instead of MyISAM. Besides the outstanding database failure recovery that InnoDB is offering, we also make daily backups of all databases, so that we can quickly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers come with InnoDB and you can make use of all the features offered by this MySQL storage engine with any PHP script-powered application that needs it. It is one of the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the requirements of the application in question. You will not need to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we will make daily backups of all your MySQL databases, so if anything goes wrong after some update or if you erase some data by accident, we’ll be able to get the database back to the way it was on any of the past seven days.

InnoDB in VPS Servers

If our in-house developed Hepsia Control Panel is chosen during the registration process for your new VPS servers , InnoDB will be activated on the server together with other required pieces of software, so you will not need to do anything if you choose to use open-source script-powered software apps that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a new database and begin the app installation procedure manually or through our one-click installation tool. The system will automatically recognize which engine the particular app requires and will set it for the specific database, so the installation process will continue flawlessly and the application can enter its data into that database. Thus, you can make use of applications with different requirements about the MySQL engine without the need to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated service that are ordered with the Hepsia hosting Control Panel. It is an integral part of the default software package that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is set up, you’ll be able to sign in and to install any script-powered software application that requires this particular MySQL database engine. When you set up a new MySQL database through the Control Panel, there won’t be any activated engine until you begin installing an app. Once the app configuration wizard starts inserting information into the newly created database, the engine will be chosen automatically based on the prerequisites of the application in question, so you can use both InnoDB and MyISAM without having to select either one explicitly at any point. Therefore, you can make use of a broad range of apps for your sites.