InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster database failure recovery in comparison to the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by plenty of web developers that build scalable web apps, as it works better with immense data volumes, while it keeps the server processing load low. Moreover, it locks only a single row in the database in case any info should be updated, whereas many other engines lock the entire database table and therefore need much more time to fulfill multiple consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the newest Joomla versions are two examples of widespread open-source script-driven software platforms that have switched to InnoDB.
InnoDB in Shared Web Hosting
You’ll be able to run any PHP script-based web application that needs InnoDB in case you’ve got a Linux shared web hosting package with our company, as the MySQL storage engine is available on our advanced cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably in case this engine is required. You can activate apps which require the MyISAM engine without any obstacles as well and, once again, the engine will be selected automatically, so you will not have to modify any setting manually at any moment. Furthermore, we will also make regular backups of all the MySQL databases that you have in your account, so if you delete or overwrite something, we can quickly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
If you create a new MySQL database through the hosting Control Panel offered with each of our semi-dedicated server plans and you start installing an open-source script-based app either manually or using our one-click app installer tool, the MySQL database storage engine will be picked automatically based on the prerequisites of the particular app. Since InnoDB is present on the cloud hosting platform where your new account will be set up, it will be set as the default engine for any app that requires it without the need for any manual action on your end at any moment. To avoid any risk of losing information if you update an app or if you delete a database by mistake, we will perform backups of all your MySQL databases each and every day, so if anything happens, we can recover your content.
InnoDB in VPS Hosting
If you order a virtual private server from us, you’ll be able to use our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to use any open-source script-driven web app which requires InnoDB, as the storage engine is part of the standard software bundle that will be pre-installed on your VPS server during its creation. When you set up a brand-new database through the hosting Control Panel, you’ll just need to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine in case the application in question needs it, so you won’t have to do anything else in your account. Likewise, if a given application needs MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Web Hosting
InnoDB comes as standard with all Linux dedicated servers hosting packages ordered with the Hepsia hosting Control Panel. It is an integral part of the default software bundle that will be installed on all Hepsia-managed dedicated servers, so once your machine is ready, you’ll be able to log in and to activate any kind of script-powered software app that needs this MySQL storage engine. When you create a new database via the hosting Control Panel, there won’t be any activated engine until you begin installing an app. Once the app activation wizard starts inserting data into the database, the engine will be chosen automatically depending on the requirements of the particular app, so you can run both InnoDB and MyISAM without having to select either one of them specifically at any time. Thus, you can use a wide selection of apps for your Internet sites.