InnoDB is a storage engine for MySQL databases, which is used by widespread script-powered web applications such as Joomla 3.x and Magento. It’s ideal for scalable apps, as it performs really well when managing enormous amounts of data. Rather than locking the entire 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 tasks for the same length of time. Besides, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data imports and modifications should be treated. If a certain task hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will be preserved intact and won’t be partially mixed with newly inserted content.

InnoDB in Hosting

Any PHP script-based software application that requires InnoDB will run flawlessly on our innovative cloud website hosting platform and the database storage engine is offered with all our hosting packages. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to modify any setting in your web hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to get the most out of its full potential. We’ll generate regular content backups, so in case you accidentally delete a database that is important to you or you overwrite some part of it, we will be able to restore your database the way it was just several hours earlier.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is an integral part of the software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your machine is assembled, you will be able to sign in and to install a various open-source script-powered app that requires this particular database storage engine. When you set up a new database via the Control Panel, there won’t be any activated engine till you begin installing an application. As soon as the app activation wizard starts inserting content into the newly created database, the engine will be picked automatically depending on the requirements of the given app, so you can use both InnoDB and MyISAM without selecting either of them explicitly at any point. In this way, you can use an immense range of apps for your websites.