InnoDB is a database storage engine for MySQL databases, which is used by popular open-source script-driven software apps such as Magento and Joomla™ 3. It’s perfect for scalable apps, since it excels in handling enormous volumes of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same length of time. Furthermore, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – rules that determine how data imports and modifications should be treated. If a certain operation hasn’t been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will remain undamaged and will not be partially mixed with newly added content.

InnoDB in Website Hosting

InnoDB is offered with all our website hosting services by default, not upon request or as a paid upgrade, so you’ll be able to install and run any script-based web application that requires the InnoDB database storage engine without having to deal with any difficulty once you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation process, no matter if you make use of our 1-click installation tool or create the database and install the app manually, as long as the application requires it instead of the more famous MyISAM engine. We’ll maintain daily backups of all your databases, so you can be certain that you’ll never lose any content if you delete a database by accident or you overwrite some key info – you’ll just have to notify us and we’ll restore your data back to normal.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server plans and you begin installing a PHP script-driven application either manually or using our single-click app installer tool, the storage engine for the database will be selected automatically depending on the prerequisites of the particular app. Since InnoDB is present on the cloud platform where your new account will be set up, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any time. To prevent any chance of losing data if you update an application or if you delete a database by accident, we’ll generate backups of all your databases each day, so if something happens, we can restore your content.

InnoDB in VPS

All VPS that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to use any script-based web app that needs this particular storage engine without the need to install anything manually. You can pick Hepsia on the VPS order page and your brand new VPS server will be set up within the hour, so you can log in and start setting up your sites right away. Once you set up a brand new database and begin the app installation process, our system will choose the engine for this database automatically. Thus, you can run different applications at the same time without the need to update anything on the Virtual Private Server. You can set up a WordPress-based personal blog that uses MyISAM – the default MySQL engine, and a Magento-powered e-commerce site that uses InnoDB, for example.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our in-house built Hepsia hosting Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually in case you’d like to activate scripts that need it. All it takes to activate such a script is to set up a new database and to begin the installation – once the script setup wizard receives access to the database in question and starts importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to activate scripts that need MyISAM, the other widely used MySQL engine, so you will not have to modify any settings on the server. This will allow you to run different scripts on one single machine and to use it to its full capacity.