InnoDB is a database engine for MySQL relational databases, which is used by popular PHP-based apps such as Magento and Joomla™ 3.x. It’s excellent for scalable apps, since it works remarkably well when handling large amounts of data. Rather than locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same length of time. What’s more, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – rules that define how data imports and modifications should be handled. If a specific task hasn’t been entirely completed for any reason, the action will be rolled back. Thus, the database content will be retained safe and sound and won’t be partially mixed with newly imported content.
InnoDB in Cloud Web Hosting
Any script-based web app that needs InnoDB will run flawlessly on our avant-garde cloud web hosting platform and the database engine comes with all our cloud web hosting
plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without having to update any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to make the most of its full potential. We will perform regular content backups, so in case you accidentally erase a database that is important to you or you overwrite some part of it, we will be able to restore the database the way it was only several hours earlier.
InnoDB in Semi-dedicated Hosting
You can activate a PHP script-driven software application that needs InnoDB with any of our semi-dedicated server
plans, due to the fact that all the accounts are set up on our leading-edge cloud hosting platform where the database storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our 1-click application installer tool. Either way, the needed engine will be picked automatically the moment the activation of the application starts, so you won’t have to edit anything manually, no matter if the app needs InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to recover any of your databases if you accidentally erase one, as we create a couple of backups every day, each of which is preserved for one week.
InnoDB in VPS Web Hosting
In case our custom-built Hepsia hosting Control Panel is picked during the signup process for your new Linux VPS web hosting packages
, InnoDB will be activated on the server along with other required software, so you will not need to do anything if you decide to install PHP script-based apps that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can create a new MySQL database and begin the app installation manually or through our single-click installation tool. The system will automatically recognize the engine that the app in question needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can dump its data in that database. Thus, you can install applications with various requirements with regard to the MySQL engine without making any changes on your Virtual Private Server.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting
that are ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you will not need to install it manually if you want to activate open-source scripts that require it. All it takes to install such a script is to set up a new database and to begin the setup – once the script setup wizard acquires access to the database in question and starts dumping content in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You’ll also be able to use scripts that need the other very popular MySQL engine – MyISAM, so you won’t have to edit any settings on the dedicated server. This will enable you to run a variety of scripts on a single machine and to use it to its maximum capabilities.