InnoDB is a database storage engine for MySQL databases, which is used by popular open-source script-powered applications such as Magento and Joomla 3. It’s perfect for scalable apps, since it performs remarkably well when managing huge volumes of data. 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 perform a lot more operations for the same length of time. Also, InnoDB offers a better database crash recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and updates should be handled. If a given operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will stay safe and sound and will not be partially merged with newly imported content.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting service providers, it’s an integral part of the default set of services offered with our cloud web hosting packages. In case you would like to make use of an open-source script-driven application that needs InnoDB particularly, in order to be installed and to perform correctly, you won’t experience any difficulties since the storage engine is available on our in-house developed cloud platform. Irrespective of whether you create a new database and activate an application manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific application needs it instead of MyISAM. In addition to the excellent database failure recovery that InnoDB offers, we also generate daily database backups, so that we can swiftly restore any database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated plans by default, so as soon as you obtain a new account, you can go on and install any PHP-based web application that needs this storage engine. A couple of engines are pre-installed on our cloud hosting platform, so when you set up a new database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen based on the prerequisites of the given application. This will allow you to activate and manage InnoDB-specific apps without having to cope with any difficulty and without needing to modify any settings in your semi-dedicated account. To be on the safe side, we will always have a seven-day-old backup of all your databases, so if you delete or change any content accidentally, we can quickly retrieve it.

InnoDB in Dedicated Servers

InnoDB comes by default with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It is part of the standard software bundle that will be installed on all Hepsia-managed servers, so as soon as your physical machine is assembled, you’ll be able to log in and to install any PHP script-driven application that requires this particular storage engine. If you set up a new database through the hosting Control Panel, there won’t be any active engine until you begin installing an app. As soon as the app configuration wizard begins entering information into the newly created database, the engine will be selected automatically in accordance with the prerequisites of the particular application, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any time. Therefore, you can make use of a broad variety of applications for your Internet sites.