InnoDB is a database storage engine for MySQL relational databases, which is used by widely used script-based applications such as Joomla 3.x and Magento. It is perfect for scalable apps, because it excels in managing huge amounts of data. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. Also, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data inserts and modifications should be handled. In case a given operation hasn’t been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be retained safe and sound and will not be partially merged with new content.
InnoDB in Website Hosting
While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is included in the default set of features that we’re offering with our website hosting plans. In case you’d like to use a script-powered software app that needs InnoDB in particular, in order to be activated and to perform properly, you will not encounter any obstacles since the InnoDB database storage engine is available on our custom-built cloud platform. Regardless of whether you create a new MySQL database and install an application manually or make use of our 1-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app needs it instead of MyISAM. Besides the outstanding crash recovery that InnoDB is offering, we also carry out daily backups of all databases, so that we can swiftly restore any database in your shared hosting account.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database from the hosting Control Panel included with each of our semi-dedicated server accounts and you begin installing a PHP script-based application either manually or using our 1-click application installer, the storage engine for the MySQL database will be selected automatically based on the requirements of the specific app. As InnoDB is present on the cloud website hosting platform where your new 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 moment. To prevent any risk of losing info if you update an app or if you erase a database by mistake, we will make backups of all your MySQL databases each day, so if something goes wrong, we can rescue your content.
InnoDB in VPS Servers
If you choose a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the default software pack that will be installed on your server before we give it to you. You will not have to configure anything manually and you will be able to enable and manage any PHP script-powered application that needs InnoDB once your VPS server is up and running, which takes no more than sixty minutes after the order submission process itself. A number of engines are offered, so every time you create a database using the Hepsia hosting Control Panel, a particular engine will be selected when the app installation begins and our system will automatically recognize the engine that is required by the app in question. If you need to use MyISAM, for instance, you won’t have to do anything different from installing the preferred application, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
InnoDB is included as standard with all Linux dedicated service ordered with the Hepsia Control Panel. It is included in the standard software bundle that we install on all Hepsia-equipped servers, so once your physical machine is ready, you’ll be able to sign in and to activate any PHP-based app that needs this particular MySQL database storage engine. If you set up a new database via the hosting Control Panel, there won’t be any active engine until you start installing an application. Once the app activation wizard begins entering information into the newly created database, the engine will be selected automatically on the basis of the specific app’s requirements, so you can use both MyISAM and InnoDB without having to select either one of them explicitly at any time. Thus, you can use an extensive variety of apps for your websites.