Learn more about InnoDB and find out why it’s been chosen as the default MySQL database engine.
InnoDB is a database engine for MySQL databases, which is used by widespread open-source script-driven software apps like Joomla™ v3 and Magento. It is ideal for scalable apps, as it performs exceptionally well when managing immense 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 process much more tasks for the same period of time. Furthermore, InnoDB offers a better database crash recovery and supports database transactions and foreign keys – rules that indicate how data imports and modifications should be treated. In case a certain task has not been entirely completed for any reason, the action will be rolled back. Thus, the content in the database will be preserved safe and sound and won’t be partially merged with newly imported content.
InnoDB in Shared Hosting
You’ll be able to use any PHP-driven web app that needs InnoDB if you’ve got a shared hosting plan
with us, as the storage engine is available on our leading-edge cloud website hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is required. You can run applications which use the MyISAM engine without having to deal with any impediment as well and, once again, the engine will be selected automatically, so you will not have to change any setting manually at any moment. Furthermore, we’ll also generate regular backups of all the databases that you’ve got in the account, so if you erase or overwrite anything, we can swiftly get it back to the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server
packages and you start installing a PHP script-driven application either manually or using our 1-click application installer, the database storage engine will be picked automatically on the basis of the requirements of the specific app. As InnoDB is present on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for any app that needs it without any manual action required on your end at any moment. To prevent any risk of losing info if you update an application or if you erase a database by accident, we will make a backup of all your databases each day, so if anything happens, we can restore your content.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t have to activate it manually in case you need to run open-source PHP scripts that need it. All it takes to activate such a script is to create a new database and to begin the setup process – once the script setup wizard gets access to the database and starts importing content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that need MyISAM – the other widely used MySQL engine, so you will not have to modify any settings on the server. This will allow you to run a variety of scripts on a single server and to use it to its full capacity.