InnoDB is a storage engine for MySQL databases, which is used by widely used PHP script-based web apps such as Joomla™ 3 and Magento. It is ideal for scalable applications, as it works incredibly well when handling immense data volumes. Rather than locking the whole table to add new information to a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. What’s more, InnoDB offers a faster crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and updates should be handled. In case a certain task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will be retained undamaged and won’t be partially merged with newly inserted content.

InnoDB in Cloud Website Hosting

You’ll be able to make use of any PHP-based web application that requires InnoDB if you’ve got a Linux cloud website hosting service with our company, as the MySQL storage engine is available on our advanced cloud web hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can activate applications which need the MyISAM engine without having any problem as well and, again, the engine will be pre-selected, so you will not have to configure anything manually at any moment. In addition, we will also perform daily backups of all the databases that you’ve got in your shared account, so if you erase or overwrite something, we can swiftly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

You can install a script-driven web application that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are set up on our cutting-edge cloud platform where the MySQL database storage engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you make use of our one-click app installer. In either case, the required engine will be chosen automatically once the activation of the application begins, so you will not need to update anything manually, no matter if the application needs InnoDB or the more widely used MyISAM. Furthermore, we will always be able to restore any of your databases in case you erase one by accident, as we carry out a few database backups every day, each of which is saved for 1 week.

InnoDB in VPS

In case our custom-built Hepsia Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server along with other essential pieces of software, so you won’t have to do anything if you decide to activate script-powered web applications that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand-new MySQL database and start installing the app manually or using our single-click installer tool. The system will automatically detect which engine the application in question requires and will set it for the specific database, so the installation process will proceed flawlessly and the application can insert its content into that database. In this way, you can run apps with various requirements with regard to the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Hosting

InnoDB is included as standard with all Linux dedicated hosting services ordered with the Hepsia hosting Control Panel. It is an integral part of the software bundle that we install on all Hepsia-managed servers, so once your machine is assembled, you’ll be able to sign in and to activate a various script-powered web application that needs this particular MySQL storage engine. When you create a new database through the hosting Control Panel, there won’t be any active engine until you start installing an application. As soon as the app activation wizard begins inserting information into the newly created database, the engine will be selected automatically on the basis of the requirements of the application in question, so you can use both MyISAM and InnoDB without the need to select either one of them specifically at any point. In this way, you can make use of a vast collection of apps for your sites.