InnoDB is a database storage engine for MySQL relational databases, which is used by widely used open-source script-based web applications like Joomla 3 and Magento. It is excellent for scalable apps, since it works exceptionally well when processing huge data volumes. Instead of locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same period of time. Moreover, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – rules that indicate how data inserts and modifications should be treated. In case a particular task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will remain undamaged and won’t be partially merged with newly appended content.
InnoDB in Shared Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with many hosting service providers, it is an integral part of the default set of services that we’re offering with our shared website hosting packages. In case you would like to use a PHP script-driven web application that needs InnoDB specifically, in order to be activated and to function properly, you will not come across any obstacles because the MySQL storage engine is available on our custom-built cloud platform. No matter if you set up a new database and install an application manually or take advantage of our 1-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app requires InnoDB instead of MyISAM. Besides the amazing crash recovery that InnoDB offers, we also store daily database backups, so that we can easily recover any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our semi-dedicated hosting services by default, so the moment you obtain a new account, you can move on and activate any open-source script-powered app that requires this database engine. A few engines are pre-installed on our cloud website hosting platform, so when you set up a new database and start installing an application manually, or opt to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected based on the prerequisites of the respective app. This will permit you to install and run InnoDB-specific apps without having to deal with any impediment and without the need to modify any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a seven-day-old backup of all your databases, so if you delete or change any content accidentally, we can easily restore it.
InnoDB in VPS
If our in-house built Hepsia hosting Control Panel is chosen during the registration process for a new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server along with other essential pieces of software, so you will not have to do anything if you decide to install open-source script-driven apps that require this MySQL database engine. The default MySQL engine – MyISAM, will be activated too. You can set up a brand new database and begin the app installation procedure manually or through our one-click installer. The system will detect which engine the app in question requires and will assign it to the specific database, so the installation process will continue impeccably and the application can insert its content into that database. Therefore, you can install apps with various prerequisites regarding the MySQL engine without having to make any modifications on your VPS server.
InnoDB in Dedicated Hosting
All dedicated hosting that are ordered with our custom-built Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually if you need to run scripts that need it. All it takes to use such a script is to create a new MySQL database and to initiate the setup – once the script setup wizard gets access to the database and begins importing content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You’ll also be able to activate scripts that require MyISAM – the other widely used MySQL engine, so you will not need to modify any settings on the server. This will enable you to use different scripts on a single server and to use it to its full capabilities.