InnoDB is a storage engine for MySQL relational databases, which is used by famous script-driven web applications such as Joomla v3 and Magento. It’s ideal for scalable applications, since it performs amazingly well when processing enormous amounts of data. Rather than locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can execute much more operations for the same length of time. Moreover, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and updates should be treated. In case a certain task hasn’t been fully completed for some reason, the action will be rolled back. Thus, the content in the database will be preserved safe and sound and will not be partially merged with newly appended content.

InnoDB in Shared Web Hosting

You’ll be able to install any PHP-driven application that requires InnoDB if you’ve got a Linux shared web hosting service with us, as the storage engine is present on our leading-edge cloud website hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can activate apps that require the MyISAM engine without encountering any impediment as well and, again, the engine will be pre-selected, so you will not have to edit anything manually at any point. What’s more, we’ll also make daily backups of all the databases that you have in the account, so in case you delete or overwrite anything, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server accounts and you begin installing a PHP-driven web application either manually or using our single-click app installer tool, the storage engine for the database will be selected automatically depending on the requirements of the specific application. As InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without any manual action needed on your end at any time. To prevent any risk of losing information if you update an app or if you delete a database by mistake, we’ll carry out a backup of all your MySQL databases each day, so if something goes wrong, we can rescue your content.

InnoDB in VPS Servers

In case our in-house built Hepsia hosting Control Panel is picked during the registration process for a new VPS servers , InnoDB will be activated on the VPS server together with other necessary pieces of software, so you will not have to do anything if you choose to manage PHP script-based apps that require this MySQL database engine. The default MySQL engine – MyISAM, will be installed as well. You can create a new database and start installing the app manually or through our single-click installation tool. The system will recognize which engine the app in question needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the application can dump its content in that database. Thus, you can install apps with various prerequisites with regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the features which you can pick on the order page when you buy a dedicated server from our company. As this is the most powerful type of website hosting, it is pretty likely that you will manage highly popular Internet sites that will attract lots of visitors, and since InnoDB is among the best choices for such websites, we will activate it along with all the other software apps that are offered with a Hepsia-managed dedicated server. When you create a new MySQL database in your account, there won’t be any active MySQL storage engine till you start installing an open-source PHP script, whether manually via your browser or using the automatic scripts installer tool that is available in the Control Panel. The necessary engine will be recognized and will be assigned to that database, so you can activate scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without having to cope with any obstacle.