InnoDB is a storage engine for MySQL databases, which is used by popular script-driven software applications such as Magento and Joomla v3. It’s excellent for scalable apps, since it performs really well when handling huge amounts of data. Instead of locking the whole table to append new information to a database as many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same period of time. Moreover, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and updates should be handled. In case a given operation has not been entirely completed for any reason, the action will be rolled back. Thus, the content in the database will be kept undamaged and will not be partially mixed with newly entered content.
InnoDB in Web Hosting
You can use any open-source script-based app that requires InnoDB if you’ve got a Linux web hosting with our company, as the database storage engine is available on our cutting-edge cloud hosting platform as standard. During 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 run applications that require the MyISAM engine without having any difficulty as well and, again, the engine will be pre-selected, so you won’t need to update anything manually at any point. Furthermore, we’ll also make regular backups of all the MySQL databases that you have in the shared hosting account, so if you delete or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
InnoDB is available with all our semi-dedicated hosting packages by default, so the moment you get a new semi-dedicated account, you can go on and install any PHP-based software app that needs this database engine. A number of engines are installed on our cloud web hosting platform, so when you set up a new database and start installing an application manually, or decide to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected in accordance with the requirements of the app in question. This will permit you to install and manage InnoDB-specific apps without coming across any complication and without needing to edit any settings in your semi-dedicated account. To avoid any risk, we’ll always have a seven-day-old backup of all your databases, so if you delete or edit any content accidentally, we can easily rescue it.
InnoDB in VPS
If our in-house built Hepsia hosting Control Panel is chosen during the registration process for your new Linux VPS packages , InnoDB will be activated on the server along with other essential software, so you will not need to do anything if you decide to run PHP script-based applications that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can set up a brand-new MySQL database and begin the app installation procedure manually or using our single-click installer. The system will detect which engine the application in question needs and will assign it to the specific database, so the installation process will proceed flawlessly and the application can dump its data in that database. In this way, you can manage apps with different requirements concerning the MySQL engine without the need to make any changes on your Virtual Private Server.
InnoDB in Dedicated Hosting
All dedicated servers hosting packages ordered with our custom-built Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database engine, so you won’t have to add it manually in case you want to run open-source scripts that require it. All it takes to run such a script is to set up a new MySQL database and to start the installation – as soon as the script setup wizard obtains access to the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to activate scripts that require MyISAM – the other popular MySQL engine, so you will not have to update any settings on the dedicated server. This will enable you to activate different scripts on a single physical server and to use it to its maximum capabilities.