InnoDB is a storage engine for MySQL databases, which is used by widespread PHP script-driven software applications like Magento and Joomla™ v3. It’s excellent for scalable apps, since it works stunningly well when processing large data volumes. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same length of time. What’s more, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be handled. If a certain operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will be retained safe and sound and won’t be partially mixed with new content.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other hosting companies, it is an essential part of the default set of services offered with our shared hosting plans. In case you want to use an open-source script-based app that requires InnoDB in particular, in order to be activated and to function correctly, you won’t face any obstacles as the MySQL database storage engine is available on our in-house built cloud platform. Regardless of whether you set up a brand-new database and install an application manually or make use of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app needs InnoDB rather than MyISAM. In addition to the exceptional crash recovery offered by InnoDB, we also maintain regular database backups, so we can swiftly recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database from the Control Panel included with each of our semi-dedicated server packages and you start installing a PHP script-powered software application either manually or using our single-click app installer tool, the storage engine for the database will be selected automatically depending on the prerequisites of the specific application. As InnoDB is available on the cloud platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any app that needs it without any manual intervention required on your end at any point. To prevent any chance of losing information if you update an application or if you erase a database unintentionally, we will generate backups of all your databases each day, so if anything goes wrong, we can recover your content.
InnoDB in VPS Servers
All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to run any open-source script-driven web app that requires the MySQL database storage engine without having to configure anything manually. You can pick Hepsia on the VPS configuration page and your new Virtual Private Server will be ready within sixty minutes, so you can sign in and begin building your sites right away. Once you set up a brand-new database and begin the app installation process, our system will select the engine for this MySQL database automatically. Thus, you can install various apps at the same time without having to configure anything on the Virtual Private Server. You can set up a WordPress-powered personal journal that uses the default MySQL engine – MyISAM, and a Magento-based e-commerce website that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated servers that are ordered with the Hepsia Control Panel. It is an integral part of the default software bundle that will be pre-installed on all Hepsia-equipped servers, so as soon as your machine is set up, you’ll be able to log in and to install a various script-driven software app that needs this MySQL storage engine. When you set up a new MySQL database through the Control Panel, there won’t be any activated engine till you start installing an application. Once the app installation wizard begins entering data into the database, the engine will be set automatically based on the prerequisites of the given app, so you can run both InnoDB and MyISAM without selecting either one of them explicitly at any moment. In this way, you can make use of a wide collection of applications for your sites.