InnoDB is a database storage engine for MySQL databases, which is used by well known script-based web apps like Magento and Joomla 3.x. It is ideal for scalable apps, as it performs exceptionally well when handling immense data volumes. Instead of locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can handle much more operations for the same length of time. Additionally, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – rules that indicate how data imports and modifications should be handled. In case a particular operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will remain undamaged and will not be partially merged with newly imported content.

InnoDB in Hosting

You will be able to make use of any PHP script-based application that needs InnoDB in case you have a Linux hosting with us, as the database storage engine is present on our avant-garde cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can run applications which need the MyISAM engine without the need to deal with any difficulty as well and, once again, the engine will be selected automatically, so you will not have to update anything manually at any time. In addition, we will also generate regular backups of all the databases that you’ve got in your shared web hosting account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the hosting Control Panel included with all our semi-dedicated server accounts and you start installing a PHP script-driven software application either manually or using our one-click app installer tool, the storage engine for the database will be selected automatically on the basis of the particular app’s prerequisites. Since InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any point. To avoid any risk of losing data if you update an application or if you remove a database by accident, we will carry out backups of all your databases each day, so if anything goes wrong, we can retrieve your content.

InnoDB in Dedicated Hosting

If you acquire a new dedicated server, you will be able to pick one of the 3 Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to install this storage engine manually in order to be able to use PHP-based web apps that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the resources that you need to manage large-scale websites, it is quite possible that you’ll use InnoDB. You’ll be able to use other engines as well, so in case a certain app requires MyISAM instead of InnoDB, you will not need to deal with any problem while using it. The engine that will be used will be automatically recognized as soon as the app installation starts, so you will not have to configure any settings manually whatsoever.