InnoDB is a database engine for MySQL relational databases, which is used by famous script-based web applications such as Magento and Joomla v3. It’s excellent for scalable applications, as it works stunningly well when handling enormous amounts of data. Instead of locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same period of time. Besides, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data inserts and updates should be treated. If a specific operation hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and will not be partially mixed with newly entered content.
InnoDB in Shared Hosting
Any open-source script-driven software application that needs InnoDB will function impeccably on our cutting-edge cloud hosting platform and the storage engine is offered with all our shared hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without having to modify any setting in your hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We’ll maintain regular content backups, so if you unintentionally delete a database that is important to you or you overwrite some part of it, we’ll be able to restore your database the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Servers
You can run a PHP script-powered web application that needs InnoDB with any of our semi-dedicated server plans, as all the accounts are set up on our cutting-edge cloud hosting platform where the MySQL database storage engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our one-click app installer tool. In either case, the required engine will be selected automatically once the installation of the application starts, so you will not need to change anything manually, irrespective of whether the application requires InnoDB or the more regularly used MyISAM. In addition, we will always be able to retrieve any of your databases if you accidentally delete one, as we perform a few backups every day, each of which is stored for seven days.
InnoDB in Dedicated Servers
InnoDB is included by default with all dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It is part of the default software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your machine is ready, you will be able to sign in and to activate any open-source script-based web application that needs this particular storage engine. If you create a new database through the Control Panel, there won’t be any active engine until you start installing an application. Once the app activation wizard begins dumping data in the database, the engine will be chosen automatically based on the requirements of the app in question, so you can use both InnoDB and MyISAM without having to select either one of them specifically at any time. Thus, you can make use of a large collection of applications for your Internet sites.