InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has many strong sides that make it the engine of choice for numerous script-driven software apps, among them Magento and Joomla, which have switched to InnoDB for good. For instance, importing enormous amounts of data will be much faster with InnoDB, since it locks only a single row to perform a particular task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Put simply, appending new or updating existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case a certain problem appears during the process, therefore the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting by default, not upon request or as a paid upgrade, so you can install and manage any script-powered app that requires the InnoDB storage engine without the need to deal with any difficulty once you activate your shared account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, regardless of whether you make use of our single-click installation tool or create the database and activate the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll generate regular MySQL database backups, so you can be certain that you will never lose any data in case you erase a database by accident or you overwrite some important information – you will just have to notify us and we will restore the database back to normal.

InnoDB in VPS

If our custom-developed Hepsia Control Panel is chosen during the registration process for your new Linux virtual private servers , InnoDB will be installed on the Virtual Private Server along with other necessary software, so you will not have to do anything if you choose to install PHP script-based web apps that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a new database and start the app installation manually or using our one-click installation tool. The system will recognize the engine that the particular app needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can enter its content into that database. Therefore, you can install apps with various requirements in regard to the MySQL engine without the need to make any changes on your server.

InnoDB in Dedicated Hosting

When you obtain a new dedicated server, you’ll be able to select any of the 3 Control Panels offered by us – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to enable this database engine manually to be able to run open-source script-driven software applications that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you need in order to run large-scale sites, it is very possible that you’ll resort to InnoDB. You will be able to use other engines too, so if a specific application needs MyISAM rather than InnoDB, you won’t have any difficulty while using it. The engine that will be used will be automatically detected the moment the app installation procedure commences, so you will not have to fine-tune any setting manually whatsoever.