InnoDB is a database engine for MySQL databases, which is used by famous open-source script-powered web applications such as Joomla 3 and Magento. It’s excellent for scalable apps, as it works remarkably well when processing large volumes of data. Instead of locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more tasks for the same length of time. Plus, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – rules that define how data inserts and updates should be handled. In case a certain task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will stay safe and sound and will not be partially merged with newly added content.
InnoDB in Shared Website Hosting
Any script-powered web application that requires InnoDB will run impeccably on our innovative cloud web hosting platform and the database engine comes with all our shared website hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without the need to configure any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to take advantage of its full capacity. We will make regular backups of your content, so if you accidentally remove a MySQL database that’s important to you or you overwrite a specific part of it, we’ll be able to restore your data the way it was just a couple of hours earlier.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers include InnoDB and you can use all the features of this storage engine with any open-source script-based app that needs it. It is among the engines that we have on our cloud web hosting platform, so the one that will be picked depends on the requirements of the given application. You will not have to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer tool. To avoid any risk, we will store daily MySQL database backups, so if something goes wrong after some update or if you erase some content by accident, we will be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS Servers
When you acquire a VPS server from us, you’ll be able to use our custom-developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to run any PHP script-driven app which needs InnoDB, as the MySQL storage engine is included in the software package that will be pre-installed on your VPS server during its setup. When you set up a new database through the hosting Control Panel, you just need to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the application in question requires it, so you won’t have to do anything else in your VPS account. Equivalently, if a given app requires MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated servers ordered with the Hepsia hosting Control Panel. It is included in the software package that will be installed on all Hepsia-managed servers, so as soon as your physical machine is up and running, you will be able to sign in and to activate any kind of PHP-driven web app that requires this particular database storage engine. If you set up a new database via the Control Panel, there won’t be any active engine till you begin installing an app. Once the app installation wizard begins entering information into the database, the engine will be picked automatically in accordance with the prerequisites of the specific application, so you can use both InnoDB and MyISAM without having to select either one of them explicitly at any moment. In this way, you can make use of a large collection of applications for your websites.