InnoDB is a storage engine for MySQL relational databases, which is used by well known open-source script-driven web apps such as Joomla™ 3.x and Magento. It’s excellent for scalable applications, as it works exceptionally well when processing immense volumes of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can process a lot more operations for the same period of time. Plus, InnoDB offers a much better database crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be treated. In case a given operation hasn’t been fully completed for any reason, the action will be rolled back. Thus, the database content will remain safe and sound and won’t be partially mixed with newly entered content.
InnoDB in Cloud Hosting
While InnoDB is either not available or a paid upgrade with other hosting companies, it is part of the standard set of features that we’re offering with our cloud hosting plans. If you want to use an open-source script-driven app that needs InnoDB particularly, in order to be activated and to perform correctly, you will not come across any difficulties as the MySQL database engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you set up a brand-new database and install an application manually or use our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires InnoDB rather than MyISAM. In addition to the excellent database failure recovery that InnoDB is offering, we also keep daily backups of all databases, so that we can swiftly recover any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our Linux semi-dedicated servers by default, so once you order a new semi-dedicated account, you can move on and install any PHP script-based web app that requires this MySQL database storage engine. Several engines are pre-installed on our cloud platform, so when you set up a brand-new MySQL database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be selected in accordance with the specific app’s prerequisites. This will allow you to activate and run InnoDB-specific apps without having any obstacle and without having to update any settings in your semi-dedicated account. To be on the safe side, we’ll always have a 7-day-old backup of all your MySQL databases, so if you erase or change any content by mistake, we can quickly recover it.
InnoDB in VPS Servers
If you select a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an essential part of the software bundle that will be pre-installed on your server before we hand it over to you. You won’t need to set up anything manually and you will be able to install and run any PHP script-based web app that needs InnoDB once your VPS is set up, which takes no more than 1 hour after the order process itself. A couple of engines are available, so anytime you create a MySQL database through the Hepsia hosting Control Panel, a specific engine will be activated when the app installation begins and our system will detect which engine is required by the app in question. If you have to use MyISAM, for instance, you won’t need to do anything different from installing the app of your preference, whether manually or using our app installer.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is an integral part of the standard software package that will be installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is up and running, you will be able to sign in and to install a various PHP script-driven web app that needs this database storage engine. If you set up a new database via the hosting Control Panel, there won’t be any activated engine till you start installing an app. Once the app configuration wizard starts dumping content in the database, the engine will be selected automatically based on the requirements of the given application, so you can use both InnoDB and MyISAM without the need to select either of them specifically at any time. Therefore, you can make use of a vast variety of apps for your websites.