InnoDB
Find out more about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP-driven software apps such as Magento and Joomla™ 3.x. It is excellent for scalable apps, because it performs incredibly well when managing huge data volumes. Rather than locking the whole table to import new information into a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. Moreover, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be handled. If a particular operation has not been fully completed for some reason, the action will be rolled back. In this way, the information in the database will be retained safe and sound and will not be partially mixed with newly imported content.
-
InnoDB in Cloud Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting service providers, it’s part of the standard set of services that we’re offering with our
cloud hosting plans. If you would like to make use of a script-based application that needs InnoDB in particular, in order to be installed and to work correctly, you will not encounter any difficulties because the database storage engine is available on our in-house built cloud Internet hosting platform. Regardless of whether you set up a new database and activate an application manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs it instead of MyISAM. In addition to the remarkable database crash recovery offered by InnoDB, we also keep regular backups of all databases, so that we can easily recover any MySQL database in your shared web hosting account.
-
InnoDB in Semi-dedicated Hosting
InnoDB comes with each of our
Linux semi-dedicated hosting packages by default, so once you obtain a new semi-dedicated account, you can go on and activate any script-driven application that requires this MySQL database engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a brand-new database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be set based on the requirements of the particular app. This will allow you to install and run InnoDB-specific applications without experiencing any problem and without needing to update any settings in your account. To take no chances, we’ll always have a one-week-old backup of all your databases, so if you remove or edit any content by accident, we can easily rescue it.
-
InnoDB in Dedicated Web Hosting
When you purchase a new
dedicated server, you will be able to choose any of the three Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to add this MySQL database engine manually to be able to manage PHP script-driven software apps that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the server resources that you require to manage very large Internet sites, it is pretty likely that you will resort to InnoDB. You’ll be able to use other engines as well, so if a particular app needs MyISAM instead of InnoDB, you will not have to deal with any predicament while managing it. The engine that will be used will be detected automatically when the app installation begins, so you won’t have to alter any setting manually whatsoever.