InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got plenty of advantages that have made it the engine of choice for many PHP-based apps, including Joomla and Magento, which have switched to InnoDB for good. For example, adding large data volumes will be faster with InnoDB, because it locks only a single row to complete a task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is tackled. Simply put, adding new or editing existing data will either be fully completed, or will be aborted and the procedure will be rolled back if some issue shows up during the process, so the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with other website hosting service providers, it’s an integral part of the default set of services that we are offering with our shared hosting plans. In case you wish to use a script-based application that requires InnoDB particularly, in order to be activated and to work correctly, you will not need to deal with any difficulties as the database storage engine is available on our in-house developed cloud Internet hosting platform. No matter if you create a brand-new database and activate an application manually or make use of our one-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the incredible database crash recovery that InnoDB offers, we also generate regular backups of all databases, so we can swiftly restore any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB is included with each of our Linux semi-dedicated packages by default, so the moment you create a new semi-dedicated account, you can move on and activate any script-based software app that needs this particular MySQL database engine. Several engines are installed on our cloud website hosting platform, so when you set up a new MySQL database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be picked depending on the specific app’s requirements. This will allow you to activate and run InnoDB-specific applications without coming across any difficulty and without needing to edit any settings in your account. To take no chances, we will always have a 1-week-old backup of all your MySQL databases, so if you delete or edit any content by mistake, we can swiftly restore it.
InnoDB in Dedicated Hosting
InnoDB comes by default with all Linux dedicated servers hosting packages ordered with the Hepsia Control Panel. It’s part of the standard software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is set up, you will be able to sign in and to activate a various script-powered web app that needs this particular MySQL database engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you start installing an app. Once the app setup wizard begins entering information into the database, the engine will be picked automatically based on the prerequisites of the respective app, so you can use both InnoDB and MyISAM without selecting either one specifically at any time. Therefore, you can make use of a broad variety of applications for your Internet sites.