InnoDB is a database engine for MySQL databases, which is used by famous open-source script-driven web applications like Magento and Joomla 3. It is perfect for scalable apps, as it performs really well when processing enormous data volumes. Rather than locking the whole table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same period of time. Besides, InnoDB offers a faster database failure recovery and supports database transactions and foreign key constraints – a set of rules that determine how data imports and modifications should be treated. If a given task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved safe and sound and will not be partially mixed with newly imported content.
InnoDB in Shared Hosting
Any PHP-driven application that requires InnoDB will run flawlessly on our advanced cloud website hosting platform and the database storage engine is available with all our shared hosting packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected on the basis of the app’s specifications without the need to modify any setting in your account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to get the most out of its full capacity. We will perform regular content backups, so in case you accidentally remove a database that is important to you or you overwrite a certain part of it, we’ll be able to restore your content the way it was just several hours ago.
InnoDB in Semi-dedicated Servers
If you create a brand new MySQL database through the hosting Control Panel offered with each of our semi-dedicated server packages and you begin installing an open-source script-driven web application either manually or using our 1-click app installer tool, the MySQL database storage engine will be picked automatically on the basis of the prerequisites of the specific application. As InnoDB is present on the cloud web hosting platform where your new account will be created, it will be set as the default engine for any app that needs it without any manual intervention required on your end at any point. To prevent any chance of losing data if you update an application or if you erase a database accidentally, we will generate backups of all your MySQL databases each day, so if anything happens, we can rescue your content.
InnoDB in Dedicated Servers
All dedicated servers ordered with our custom-developed Hepsia hosting Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not need to add it manually if you need to use open-source PHP scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to begin the installation process – once the script installation wizard obtains access to the database in question and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You will also be able to install scripts that require MyISAM, the other popular MySQL engine, so you won’t have to change any settings on the dedicated server. This will permit you to activate a variety of scripts on one single machine and to use it to its maximum potential.