InnoDB is a database storage engine for MySQL relational databases, which is used by widely used PHP-driven software applications such as Magento and Joomla 3. It is ideal for scalable applications, as it works astonishingly well when processing huge amounts of data. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same length of time. Furthermore, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – rules that determine how data inserts and modifications should be handled. In case a given task hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the database content will be kept intact and won’t be partially merged with new content.

InnoDB in Web Hosting

While InnoDB is either not available or a paid upgrade with many other hosting companies, it’s part of the default set of features that we’re offering with our web hosting packages. In case you’d like to use a script-driven application that needs InnoDB in particular, in order to be activated and to work properly, you will not come across any impediments since the MySQL database engine is available on our custom-developed cloud Internet hosting platform. No matter if you set up a brand-new database and install an application manually or use our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app requires it instead of MyISAM. In addition to the incredible crash recovery that InnoDB offers, we also maintain regular backups of all databases, so that we can swiftly restore any database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the hosting Control Panel provided with each of our semi-dedicated server packages and you start installing a PHP-driven app either manually or using our single-click app installer, the storage engine for the MySQL database will be picked automatically depending on the specific app’s prerequisites. 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 any app that requires it without any manual action needed on your end at any moment. To prevent any risk of losing info if you update an app or if you delete a database unintentionally, we’ll perform a backup of all your MySQL databases each and every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS

If our custom-developed Hepsia Control Panel is picked during the registration process for a new Linux VPS packages , InnoDB will be activated on the server together with other essential software, so you will not have to do anything if you decide to manage script-driven applications that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a brand new MySQL database and start the app installation procedure manually or through our 1-click installation tool. The system will detect the engine that the app in question needs and will assign it to the specific database, so the installation process will continue impeccably and the application can enter its content into that database. Therefore, you can install apps with various prerequisites in regard to the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Hosting

If you purchase a new dedicated server, you will be able to select any of the 3 Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to activate this database engine manually so as to be able to run script-powered applications that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the resources that you require to manage very large Internet sites, it is quite likely that you will resort to InnoDB. You will be able to make use of other engines too, so if a given app requires MyISAM instead of InnoDB, you will not come across any problem while using it. The engine that will be used will be automatically detected as soon as the app installation procedure starts, so you won’t need to configure any settings manually at any point.