What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a storage engine for MySQL relational databases, which is used by famous script-powered applications like Joomla™ 3 and Magento. It’s perfect for scalable apps, as it performs stunningly well when processing large volumes of data. Rather than locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same length of time. Moreover, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data imports and updates should be handled. If a certain operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will be preserved safe and sound and will not be partially mixed with newly appended content.
InnoDB in Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting companies, it’s an integral part of the default set of features that we offer with our hosting
packages. In case you would like to use an open-source script-powered web app that needs InnoDB particularly, in order to be installed and to work properly, you won’t experience any impediments since the database storage engine is available on our custom cloud Internet hosting platform. Regardless of whether you set up a brand-new database and install an application manually or take advantage of our single-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs InnoDB instead of MyISAM. Besides the amazing database crash recovery that InnoDB is offering, we also maintain daily database backups, so we can quickly recover any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
You can make use of a script-powered software app that requires InnoDB with all of our semi-dedicated server
plans, due to the fact that all the accounts are set up on our avant-garde cloud web hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our single-click application installer. In either case, the needed engine will be picked automatically the moment the installation of the app starts, so you won’t need to change anything manually, no matter if the app requires InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to recover any of your databases if you accidentally delete one, as we perform several backups every day, each of which is stored for seven days.
InnoDB in VPS Servers
If our in-house developed Hepsia hosting Control Panel is chosen during the registration process for your new VPS web hosting plans
, InnoDB will be activated on the VPS server together with other necessary software, so you will not have to do anything if you choose to manage PHP script-powered applications that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed too. You can create a new MySQL database and start installing the application manually or through our single-click installer tool. The system will automatically recognize which engine the particular app requires and will assign it to the specific MySQL database, so the installation process will continue impeccably and the app can import its data into that database. Therefore, you can manage applications with different requirements concerning the MySQL engine without having to make any modifications on your VPS.
InnoDB in Dedicated Servers
If you purchase a new dedicated server
, you will be able to pick any of the 3 hosting Control Panels that we offer – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to enable this database storage engine manually to be able to use PHP-based apps that need it. InnoDB is used for scalable applications and since a dedicated server will give you all the resources that you need in order to manage large-scale sites, it’s pretty possible that you’ll resort to InnoDB. You’ll be able to use other engines too, so if a specific app needs MyISAM rather than InnoDB, you won’t have to deal with any predicament while running it. The engine that will be used will be automatically recognized as soon as the app installation procedure commences, so you won’t have to edit any settings manually at any point.