InnoDB is a database storage engine for MySQL databases, which is used by widely used PHP script-powered applications such as Joomla 3.x and Magento. It is ideal for scalable apps, because it works stunningly well when managing huge volumes of data. Instead of locking the entire table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. What’s more, InnoDB offers an improved crash recovery and supports transactions and foreign keys – rules that define how data imports and updates should be handled. In case a given operation has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved safe and sound and will not be partially mixed with newly entered content.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting service providers, it is an essential part of the default set of features that we are offering with our shared web hosting plans. If you’d like to use a script-based software application that needs InnoDB in particular, in order to be activated and to work properly, you won’t encounter any impediments since the InnoDB storage engine is available on our custom-developed cloud Internet hosting platform. Regardless of whether you create a new database and activate an application manually or make use of our 1-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the respective app needs InnoDB rather than MyISAM. Besides the remarkable database crash recovery that InnoDB is offering, we also perform daily backups of all databases, so that we can quickly restore any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database through the Control Panel provided with all our semi-dedicated server packages and you begin installing a script-driven application either manually or using our single-click app installer tool, the storage engine for the database will be picked automatically based on the prerequisites of the given application. As InnoDB is available on the cloud platform where your new semi-dedicated account will be set up, it will be set as the default engine for each app that requires it without any manual action needed on your end at any point. To avoid any chance of losing information if you update an application or if you erase a database by mistake, we will generate a backup of all your MySQL databases each and every day, so if something happens, we can restore your content.

InnoDB in VPS Servers

If our custom-developed Hepsia hosting Control Panel is selected during the signup process for a new VPS hosting plans , InnoDB will be activated on the server along with other required pieces of software, so you won’t need to do anything if you decide to activate script-powered software apps that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a new database and start the app installation process manually or using our 1-click installer tool. The system will detect the engine that the particular application needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can insert its data into that database. In this way, you can use apps with various prerequisites regarding the MySQL engine without making any modifications on your VPS server.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that is pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to activate it manually if you’d like to activate scripts that need it. All it takes to run such a script is to create a new MySQL database and to start the setup – once the installation wizard acquires access to the database and begins entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You’ll also be able to install scripts that require the other very popular MySQL engine – MyISAM, so you won’t need to edit any settings on the dedicated server. This will enable you to run different scripts on a single physical server and to use the latter to its full capacity.