Learn more about InnoDB and see why it’s already been selected as the default MySQL database engine.
InnoDB is a database engine for MySQL databases, which is used by widely used script-based applications like Joomla™ v3 and Magento. It is excellent for scalable applications, because it performs really well when managing immense data volumes. Instead of locking the whole table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can complete a lot more tasks for the same length of time. Furthermore, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – a set of rules that define how data imports and updates should be handled. In case a given task hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will remain safe and sound and won’t be partially merged with new content.
InnoDB in Cloud Hosting
While InnoDB is either not available or a paid upgrade with other hosting companies, it’s an essential part of the standard set of features that we offer with our cloud hosting
plans. If you want to make use of a PHP-driven application that needs InnoDB particularly, in order to be installed and to operate correctly, you won’t have any problems since the database engine is available on our in-house built cloud Internet hosting platform. No matter if you create a brand-new database and activate an app manually or make use of our 1-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific app needs InnoDB rather than MyISAM. In addition to the exceptional crash recovery that InnoDB is offering, we also maintain regular backups of all databases, so we can quickly recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the Control Panel offered with all our semi-dedicated server
plans and you start installing a script-driven app either manually or using our single-click application installer tool, the storage engine for the database will be set automatically based on the given app’s prerequisites. As InnoDB is available on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that requires it without any manual action needed on your end at any moment. To avoid any chance of losing info if you update an app or if you erase a database unintentionally, we’ll perform backups of all your MySQL databases every day, so if something goes wrong, we can recover your content.
InnoDB in VPS Servers
If you pick a VPS server
with our Hepsia Control Panel, the InnoDB database storage engine will be an integral part of the standard software pack that will be pre-installed on your Virtual Private Server before we give it to you. You will not need to configure anything manually and you’ll be able to enable and use any PHP-driven web application that needs InnoDB as soon as your VPS server is set up, which takes no more than 60 minutes after the order submission process itself. A couple of engines are offered, so anytime you set up a database via the Hepsia hosting Control Panel, a particular engine will be activated once the app activation process begins and our system will automatically recognize the engine that is required by the application in question. In case you have to use MyISAM, for example, you won’t have to do anything different than installing the preferred application, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
If you order a new dedicated server
, you will be able to select any of the three hosting Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to install this MySQL database storage engine manually in order to be able to run PHP script-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require in order to manage very large Internet sites, it’s pretty likely that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so if a particular app requires MyISAM instead of InnoDB, you will not have any obstacle while using it. The engine that will be used will be automatically recognized as soon as the app installation procedure starts, so you won’t need to tweak any settings manually at any point.