InnoDB is a storage engine for MySQL relational databases, which is used by popular script-based apps such as Magento and Joomla 3. It is excellent for scalable applications, as it works very well when processing huge volumes of data. Rather than locking the whole table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same period of time. Furthermore, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – a set of rules that determine how data imports and modifications should be handled. If a particular task has not been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will remain undamaged and will not be partially merged with new content.
InnoDB in Web Hosting
You can activate any open-source script-powered web application that requires InnoDB if you have a Linux web hosting with us, as the MySQL storage engine is available on our innovative cloud website hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably in case this engine is needed. You can activate applications which need the MyISAM engine without encountering any problem as well and, once again, the engine will be pre-selected, so you will not have to edit any setting manually at any time. What’s more, we will also create daily backups of all the databases that you have in the shared web hosting account, so if you erase or overwrite anything, we can swiftly restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Hosting
InnoDB is included with each of our Linux semi-dedicated hosting packages by default, so as soon as you obtain a new account, you can go ahead and install any PHP script-based web application that requires this MySQL storage engine. Several engines are installed on our cloud hosting platform, so when you set up a brand-new database and start installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be chosen on the basis of the requirements of the specific app. This will permit you to activate and manage InnoDB-specific apps without needing to cope with any impediment and without having to edit any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 1-week-old backup of all your databases, so if you delete or edit any content accidentally, we can easily recover it.
InnoDB in Dedicated Web Hosting
All Linux dedicated servers hosting packages that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-activated and among everything else, you’ll get the InnoDB storage engine, so you won’t have to install it manually if you’d like to activate scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to start the installation – once the setup wizard accesses the database and starts entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to activate scripts that require the other widely used MySQL engine, MyISAM, so you won’t need to change any settings on the dedicated server. This will allow you to install various scripts on a single physical server and to use it to its full potential.