InnoDB is a popular database engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has a number of strong sides which have made it the engine of choice for a lot of PHP-powered applications, among them Joomla and Magento, which have shifted over to InnoDB for good. For instance, adding huge amounts of data will be faster with InnoDB, due to the fact that it locks only one row to accomplish a task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is treated. In simpler words, adding new or editing existent data will either be entirely completed, or will be annulled and the procedure will be rolled back if some issue appears in the meantime, therefore the content that remains in the database will not be lost.
InnoDB in Cloud Hosting
You will be able to activate any open-source script-powered web application that requires InnoDB in case you’ve got a cloud hosting with us, as the MySQL database storage engine is present on our avant-garde cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can install apps which require the MyISAM engine without encountering any difficulty as well and, again, the engine will be selected automatically, so you will not have to configure anything manually at any moment. What’s more, we’ll also perform regular backups of all the databases that you’ve got in your shared web hosting account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database from the Control Panel provided with all our semi-dedicated server packages and you start installing an open-source script-based application either manually or using our one-click app installer, the database storage engine will be selected automatically based on the requirements of the specific application. Since 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 any app that needs it without any manual intervention needed on your end at any time. To avoid any risk of losing data if you update an app or if you delete a database by accident, we’ll carry out a backup of all your databases every day, so if anything goes wrong, we can restore your content.
InnoDB in VPS Servers
If you buy a VPS server from our company, you will be able to make use of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will allow you to use any PHP script-powered software application that requires InnoDB, as this MySQL storage engine is an integral part of the standard software bundle that will be pre-installed on your server during its setup. When you create a brand new MySQL database using the Control Panel, you simply need to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine given that the application in question requires it, so you will not have to do anything else in your VPS account. Identically, if a certain app needs MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
When you acquire a new dedicated server, you will be able to choose any of the three hosting Control Panels offered by our company – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to install this MySQL database engine manually to be able to manage open-source script-driven software applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you need to manage large-size Internet sites, it’s very likely that you’ll use InnoDB. You’ll be able to use other engines too, so if a certain application needs MyISAM rather than InnoDB, you won’t have any complication while using it. The engine that will be used will be detected automatically when the app installation commences, so you will not need to update any settings manually at any moment.