InnoDB is a database engine for MySQL relational databases, which is used by widely used open-source script-based applications such as Magento and Joomla v3. It is perfect for scalable applications, because it performs very well when processing enormous volumes of data. Instead of locking the entire table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. Furthermore, InnoDB offers a better crash recovery and supports transactions and foreign keys – a set of rules that define how data imports and updates should be handled. If a certain task hasn’t been fully completed for some reason, the action will be rolled back. Thus, the content in the database will be kept safe and sound and will not be partially mixed with newly entered content.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database through the Control Panel included with all our semi-dedicated server accounts and you start installing an open-source script-powered application either manually or using our 1-click application installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the specific app’s prerequisites. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that needs it without any manual action needed on your end at any point. To prevent any risk of losing info if you update an app or if you delete a database by mistake, we’ll make backups of all your MySQL databases each and every day, so if anything happens, we can recover your data.

InnoDB in VPS Servers

All VPS web hosting service that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to make use of any PHP-based application that needs the MySQL storage engine without configuring anything manually. You can select Hepsia on the VPS order page and your new VPS server will be ready within the hour, so you can sign in and start setting up your sites right away. When you create a brand-new database and begin the app installation process, our system will pick the engine for that MySQL database automatically. Thus, you can use different applications at the same time without modifying anything on the server. You can have a WordPress-driven online journal that uses MyISAM – the default MySQL engine, and a Magento e-commerce portal that uses InnoDB, for example.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated service ordered with the Hepsia hosting Control Panel. It is part of the standard software bundle that will be installed on all Hepsia-equipped dedicated servers, so as soon as your machine is set up, you’ll be able to sign in and to install a various PHP script-based software app that requires this particular storage engine. When you set up a new database via the Control Panel, there won’t be any active engine until you start installing an app. Once the app installation wizard begins entering information into the newly created database, the engine will be chosen automatically on the basis of the requirements of the particular application, so you can run both MyISAM and InnoDB without the need to select either of them explicitly at any moment. Therefore, you can use a vast variety of applications for your sites.