InnoDB is a database storage engine for MySQL databases, which is used by widely used PHP script-powered applications such as Joomla v3 and Magento. It’s perfect for scalable apps, as it performs really well when managing enormous data volumes. Rather than locking the whole table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same length of time. Furthermore, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and modifications should be treated. In case a certain task has not been entirely completed for any reason, the action will be rolled back. Thus, the database content will remain safe and sound and won’t be partially merged with newly added content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it is an integral part of the default set of services that we are offering with our cloud hosting plans. In case you want to use an open-source script-based software application that needs InnoDB specifically, in order to be installed and to function correctly, you won’t need to deal with any impediments because the database engine is available on our in-house developed cloud Internet hosting platform. No matter if you create a brand-new MySQL database and install an app manually or use our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB rather than MyISAM. In addition to the remarkable database failure recovery offered by InnoDB, we also generate daily backups of all databases, so we can swiftly restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database from the hosting Control Panel offered with all our semi-dedicated server packages and you start installing a PHP script-driven software app either manually or using our one-click application installer, the MySQL database storage engine will be selected automatically depending on the requirements of the specific app. Since InnoDB is available on the cloud web hosting platform where your new account will be created, it will be set as the default engine for each app that needs it without the need for any manual action on your end at any time. To avoid any risk of losing information if you update an application or if you remove a database by mistake, we’ll carry out backups of all your MySQL databases each day, so if something happens, we can restore your data.

InnoDB in VPS Servers

All Linux VPS plans that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to run any PHP script-based app that needs the MySQL database storage engine without needing to install anything manually. You can select Hepsia on the VPS order form and your brand new Virtual Private Server will be set up within sixty minutes, so you can sign in and start creating your websites straight away. Once you set up a new MySQL database and start the app installation process, our system will choose the engine for this database automatically. In this way, you can run various apps simultaneously without having to change anything on the server. You can have a WordPress-based personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-driven online shopping portal that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is an essential part of the software bundle that we install on all Hepsia-managed dedicated servers, so as soon as your physical machine is ready, you will be able to sign in and to activate any kind of script-driven web application that needs this MySQL storage engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app activation wizard starts dumping information in the database, the engine will be set automatically in accordance with the prerequisites of the particular application, so you can run both MyISAM and InnoDB without the need to select either of them specifically at any moment. Therefore, you can make use of a large selection of apps for your Internet sites.