InnoDB is a storage engine for MySQL databases, which is used by famous open-source script-powered web applications such as Magento and Joomla 3. It is ideal for scalable apps, since it works amazingly well when processing large amounts of data. Rather than locking the entire table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same length of time. Moreover, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be handled. If a particular task has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will stay intact and won’t be partially mixed with newly imported content.

InnoDB in Web Hosting

You’ll be able to make use of any PHP script-powered software app that requires InnoDB if you have a Linux web hosting service with our company, as the storage engine is available on our avant-garde cloud website hosting platform as standard. During 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 required. You can activate apps which use the MyISAM engine without encountering any impediment as well and, once again, the engine will be pre-selected, so you won’t need to edit any setting manually at any moment. What’s more, we’ll also make daily backups of all the databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

If you set up a brand new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server packages and you begin installing an open-source script-based web application either manually or using our 1-click app installer tool, the storage engine for the MySQL database will be selected automatically depending on the specific app’s requirements. Since InnoDB is present on the cloud platform where your new semi-dedicated hosting 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 time. To prevent any chance of losing info if you update an app or if you remove a database by accident, we will perform a backup of all your MySQL databases each day, so if something happens, we can retrieve your data.

InnoDB in VPS Web Hosting

If you order a virtual private server from our company, you will be able to use our in-house developed Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to use any open-source script-based software application that requires InnoDB, as this storage engine is an essential part of the software bundle that will be installed on the Virtual Private Server during its configuration. When you set up a brand-new MySQL database via the hosting Control Panel, you’ll just need to start installing an application – manually or using our application installer. InnoDB will be set as the default engine as long as the application in question requires it, so you will not have to do anything else in your account. Correspondingly, if a given application needs MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers Hosting

When you acquire a new dedicated server, you will be able to pick any of the three hosting Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to enable this database storage engine manually in order to be able to manage PHP-based apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you require to manage large-size Internet sites, it is very likely that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a specific application requires MyISAM instead of InnoDB, you won’t come across any difficulty while managing it. The engine that will be used will be automatically recognized the moment the app installation procedure starts, so you won’t need to change any setting manually at any moment.