InnoDB is a storage engine for MySQL relational databases, which is used by popular script-driven apps like Joomla™ 3.x and Magento. It is perfect for scalable applications, since it works stunningly well when handling immense amounts of data. Instead of locking the whole database table to add new information to a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more operations for the same length of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that indicate how data imports and updates should be handled. In case a certain operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will stay intact and will not be partially mixed with newly appended content.
InnoDB in Website Hosting
You’ll be able to make use of any open-source script-based web app that requires InnoDB in case you have a website hosting
with us, as the database engine is available on our leading-edge cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can install applications which require the MyISAM engine without having to deal with any obstacle as well and, once again, the engine will be selected automatically, so you will not need to configure any setting manually at any moment. In addition, we will also make regular backups of all the databases that you have in your shared web hosting account, so if you erase or overwrite anything, we can swiftly get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
include InnoDB and you can use all the options offered by this database engine with any PHP script-powered application that requires it. InnoDB is among the engines that we have on our cloud platform, so the one that will be selected depends on the prerequisites of the particular app. You will not need to do anything manually to enable InnoDB, as it will be set as the default engine when you install an app – whether manually or using our 1-click application installer. To avoid any risk, we’ll generate regular backups of all your databases, so if anything goes wrong following an update or if you delete some data by mistake, we’ll be able to restore your database the way it was on any of the previous 7 days.
InnoDB in VPS Servers
If you pick a VPS server
with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the standard software bundle that will be installed on your server before we hand it over to you. You won’t have to set up anything manually and you will be able to enable and manage any script-driven app that requires InnoDB once your Virtual Private Server is ready, which takes no more than 60 minutes after the order submission process itself. Several engines are offered, so every time you set up a MySQL database through the Hepsia hosting Control Panel, a particular engine will be selected once the app installation begins and our system will detect the engine that is required by the app in question. If you need MyISAM, for example, you will not need to do anything different from installing the preferred app, whether manually or using our application installer.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated servers
ordered with the Hepsia hosting Control Panel. It is an essential part of the default software bundle that we install on all Hepsia-managed dedicated servers, so once your physical machine is assembled, you will be able to sign in and to activate a various PHP script-powered web application that needs this particular MySQL database storage engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you start installing an app. As soon as the app activation wizard starts dumping information in the newly created database, the engine will be picked automatically in accordance with the prerequisites of the given application, so you can run both MyISAM and InnoDB without having to select either one of them specifically at any time. Thus, you can use a vast range of apps for your sites.