InnoDB is a storage engine for MySQL relational databases, which is used by famous PHP script-driven software applications such as Magento and Joomla™ 3. It is excellent for scalable apps, as it performs really well when processing huge volumes of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same period of time. Furthermore, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data inserts and updates should be treated. In case a specific task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and will not be partially mixed with newly inserted content.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the Control Panel offered with each of our semi-dedicated server plans and you begin installing a PHP script-powered application either manually or using our single-click app installer, the storage engine for the database will be set automatically based on the prerequisites of the specific app. Since InnoDB is available on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for each application that needs it without the need for any manual action on your end at any point. To prevent any risk of losing data if you update an app or if you delete a database by mistake, we’ll perform a backup of all your databases each day, so if anything happens, we can retrieve your content.
InnoDB in VPS Servers
If you buy a VPS server from our company, you’ll be able to make use of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to run any open-source script-based software application that needs InnoDB, as this MySQL storage engine is an essential part of the software package that will be pre-installed on your server during its creation. When you set up a brand new database through the Control Panel, you will just have to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you will not need to do anything else in your VPS account. Similarly, if a certain application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed servers, so once your physical machine is ready, you will be able to log in and to activate any PHP script-powered app that needs this particular storage engine. If you create a new MySQL database through the Control Panel, there won’t be any active engine until you start installing an app. Once the app installation wizard begins entering data into the database, the engine will be set automatically in accordance with the given app’s requirements, so you can use both InnoDB and MyISAM without the need to select either one explicitly at any moment. Thus, you can make use of a huge range of applications for your sites.