InnoDB is a database engine for MySQL databases, which is used by widely used open-source script-driven apps such as Joomla™ 3.x and Magento. It is perfect for scalable apps, since it excels in handling huge data volumes. Instead of locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same period of time. Furthermore, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – rules that determine how data inserts and updates should be handled. If a specific task has not been fully completed for any reason, the action will be rolled back. In this way, the content in the database will be kept safe and sound and will not be partially merged with newly entered content.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with many web hosting companies, it is part of the standard set of services that we are offering with our cloud hosting packages. If you want to use a script-driven web app that needs InnoDB particularly, in order to be activated and to perform properly, you will not need to deal with any impediments because the MySQL storage engine is available on our custom-built cloud web hosting platform. Regardless of whether you set up a brand-new database and install an application manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific app requires it rather than MyISAM. In addition to the remarkable database failure recovery offered by InnoDB, we also keep regular backups of all databases, so we can swiftly restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server plans and you start installing a PHP-powered web application either manually or using our single-click app installer, the storage engine for the MySQL database will be picked automatically depending on the specific app’s requirements. As InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any time. To prevent any chance of losing info if you update an app or if you delete a database by accident, we will generate a backup of all your MySQL databases each day, so if anything happens, we can retrieve your data.

InnoDB in VPS Web Hosting

If our in-house built Hepsia Control Panel is chosen during the registration process for a new Linux VPS web hosting packages , InnoDB will be activated on the VPS server together with other necessary pieces of software, so you will not need to do anything if you decide to manage open-source script-powered apps that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a brand new MySQL database and start installing the application manually or using our 1-click installer tool. The system will automatically detect which engine the app in question requires and will set it for the specific database, so the installation process will proceed flawlessly and the app can import its content into that database. In this way, you can activate apps with different requirements regarding the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

When you acquire a new dedicated server, you will be able to choose any of the 3 Control Panels that we offer – Hepsia, DirectAdmin and cPanel. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to activate this database engine manually so as to be able to use open-source script-powered software apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you require in order to manage very large Internet sites, it’s quite possible that you will resort to InnoDB. You’ll be able to make use of other engines too, so in case a specific app needs MyISAM instead of InnoDB, you will not run into any problem while managing it. The engine that will be used will be automatically detected when the app installation process commences, so you won’t have to alter any setting manually at any point.