Read more about InnoDB and see why it’s already been chosen as the default MySQL database engine.
InnoDB is a database storage engine for MySQL databases, which is used by well known script-powered web applications like Joomla™ 3.x and Magento. It is excellent for scalable applications, as it performs remarkably well when handling immense data volumes. Instead of locking the whole table to import new information into a database like many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same period of time. Plus, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – a set of rules that indicate how data inserts and updates should be handled. In case a certain operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will be kept safe and sound and will not be partially merged with newly inserted content.
InnoDB in Cloud Website Hosting
While InnoDB is either not offered or it is a paid upgrade with other web hosts, it is an essential part of the standard set of features offered with our cloud website hosting
plans. In case you want to use an open-source script-based software application that needs InnoDB in particular, in order to be installed and to function properly, you won’t encounter any difficulties since the MySQL database storage engine is available on our custom cloud Internet hosting platform. Regardless of whether you create a brand new database and activate an application manually or use our one-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the respective application requires InnoDB rather than MyISAM. In addition to the exceptional database failure recovery that InnoDB is offering, we also make daily database backups, so that we can easily restore any database in your shared website hosting account.
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 start installing a PHP script-driven software app either manually or using our 1-click application installer, the storage engine for the database will be set automatically depending on the requirements of the particular app. As InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each application that needs it without any manual intervention needed on your end at any moment. To avoid any risk of losing information if you update an app or if you remove a database by mistake, we’ll carry out backups of all your databases every day, so if anything goes wrong, we can rescue your data.
InnoDB in VPS Servers
When you acquire a VPS server
from our company, you will be able to use our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to manage any script-driven app which needs InnoDB, as this particular MySQL database storage engine is included in the standard software bundle that will be installed on the Virtual Private Server during its setup. When you set up a brand-new MySQL database via the Control Panel, you just need to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine if the app in question needs it, so you will not need to do anything else in your VPS account. In the same manner, if a given application needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom-built Hepsia Control Panel include a software package that’s pre-installed and among everything else, you will get the InnoDB storage engine, so you won’t need to install it manually in case you want to activate scripts that require it. All it takes to use such a script is to create a new database and to start the installation process – as soon as the script installation wizard gains access to the database and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You’ll also be able to install scripts that need the other popular MySQL engine, MyISAM, so you will not have to update any settings on the server. This will permit you to activate various scripts on a single server and to use the latter to its maximum capacity.