InnoDB is a database engine for MySQL relational databases, which is used by widely used PHP-driven web apps such as Joomla v3 and Magento. It is excellent for scalable applications, because it performs incredibly well when managing huge volumes of data. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can complete much more operations for the same length of time. Also, InnoDB offers a faster crash recovery and supports transactions and foreign keys – a set of rules that define how data inserts and modifications should be handled. In case a given task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be preserved undamaged and won’t be partially mixed with newly appended content.

InnoDB in Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosting companies, it is included in the default set of services offered with our website hosting packages. In case you would like to use a script-driven software application that needs InnoDB specifically, in order to be installed and to function properly, you won’t face any obstacles since the InnoDB database storage engine is available on our custom cloud platform. No matter if you create a brand new database and install an application manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires it instead of MyISAM. Besides the exceptional crash recovery that InnoDB offers, we also store daily database backups, so that we can easily recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the Control Panel offered with each of our semi-dedicated server packages and you start installing a script-powered software application either manually or using our one-click application installer, the database storage engine will be set automatically on the basis of the prerequisites of the specific application. Since InnoDB is present on the cloud web hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any point. To avoid any chance of losing data if you update an app or if you delete a database by mistake, we’ll make a backup of all your databases every day, so if something happens, we can recover your data.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to use any open-source script-based web app that needs this particular database storage engine without needing to activate anything manually. You can choose Hepsia on the VPS order form and your brand new Virtual Private Server will be up and running within 1 hour, so you can log in and begin creating your sites right away. Once you create a brand-new database and begin the app activation process, our system will select the engine for this MySQL database automatically. In this way, you can manage various applications at the same time without having to change anything on the VPS server. You can have a WordPress-driven personal blog that uses the default MySQL engine – MyISAM, and a Magento-powered e-store that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you’ll be able to pick one of the 3 hosting Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to install this MySQL database engine manually so as to be able to use PHP script-powered apps that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you require to manage very large Internet sites, it’s rather possible that you will use InnoDB. You will be able to make use of other engines too, so if a specific app needs MyISAM rather than InnoDB, you will not have to deal with any complication while running it. The engine that will be used will be recognized automatically once the app installation process starts, so you will not have to configure any setting manually whatsoever.