What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by popular open-source script-driven software applications like Magento and Joomla™ 3. It is excellent for scalable apps, as it excels in managing large amounts of data. Instead of locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same period of time. In addition, InnoDB offers a much better crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data imports and modifications should be handled. If a given task has not been fully completed for any reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and won’t be partially merged with newly entered content.
InnoDB in Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting service providers, it is an integral part of the default set of services that we offer with our hosting
packages. In case you want to make use of a script-based web app that requires InnoDB particularly, in order to be activated and to perform properly, you won’t face any obstacles because the storage engine is available on our custom-built cloud web hosting platform. Irrespective of whether you set up a brand new MySQL database and install an app manually or make use of our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular application requires InnoDB rather than MyISAM. In addition to the excellent database failure recovery offered by InnoDB, we also maintain daily backups of all databases, so that we can swiftly recover any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our semi-dedicated servers
by default, so the moment you order a new semi-dedicated account, you can go on and install any PHP script-based software application that needs the MySQL database storage engine. Several engines are pre-installed on our cloud hosting platform, so when you create a brand new MySQL database and begin installing an app manually, or decide to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set on the basis of the particular app’s prerequisites. This will allow you to activate and run InnoDB-specific applications without having to deal with any obstacle and without needing to modify any settings in your semi-dedicated account. To take no chances, we’ll always have a one-week-old backup of all your databases, so if you delete or edit any content unintentionally, we can easily rescue it.
InnoDB in VPS Servers
All VPS servers
that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to run any PHP script-powered application that needs this particular MySQL storage engine without the need to set up anything manually. You can pick Hepsia on the VPS order page and your brand-new server will be set up within 60 minutes, so you can sign in and begin creating your websites straight away. Once you create a new MySQL database and begin the app activation process, our system will pick the engine for that database automatically. In this way, you can activate different apps at the same time without modifying anything on the server. You can set up a WordPress online blog that makes use of the default MySQL engine – MyISAM, and a Magento-based online shopping portal that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
If you buy a new dedicated server
, you’ll be able to choose any of the three Control Panels offered by us – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to activate this MySQL storage engine manually so as to be able to use script-driven web apps that require it. InnoDB is used by scalable applications and since a dedicated server will give you all the server resources that you require to run very large sites, it’s very likely that you’ll resort to InnoDB. You’ll be able to use other engines too, so in case a specific app requires MyISAM instead of InnoDB, you won’t have any complication while managing it. The engine that will be used will be recognized automatically when the app installation procedure begins, so you will not have to configure any settings manually whatsoever.