InnoDB is a database engine for MySQL relational databases, which is used by popular PHP script-based applications such as Magento and Joomla™ 3. It’s perfect for scalable applications, because it performs amazingly well when managing large amounts of data. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same length of time. Moreover, InnoDB offers a faster database failure recovery and supports database transactions and foreign keys – a set of rules that define how data imports and modifications should be treated. In case a certain operation hasn’t been fully completed for some reason, the action will be rolled back. In this way, the content in the database will be preserved intact and won’t be partially mixed with newly added content.
InnoDB in Shared Web Hosting
InnoDB is available with all our Linux shared web hosting by default, not as a paid upgrade or upon request, so you will be able to activate and run any open-source script-driven web application that requires the database storage engine without any obstacles once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app activation, irrespective of whether you take advantage of our 1-click installation tool or create the MySQL database and set up the application manually, as long as the app requires it instead of the more famous MyISAM engine. We’ll make regular database backups, so you can be certain that you won’t ever lose any data in case you delete a database by accident or you overwrite some vital info – you’ll simply have to alert us and we will restore your content the way it was.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database through the hosting Control Panel coming with all our semi-dedicated server packages and you start installing a PHP script-driven application either manually or using our one-click application installer, the storage engine for the database will be set automatically based on the particular app’s requirements. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each app that requires it without the need for any manual intervention on your end at any point. To avoid any risk of losing data if you update an application or if you erase a database unintentionally, we will make backups of all your databases every day, so if something happens, we can rescue your data.
InnoDB in VPS
If you select a virtual private server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the default software bundle that will be installed on your VPS server before we hand it over to you. You will not have to set up anything manually and you will be able to enable and use any script-based app that needs InnoDB as soon as your VPS server is set up, which takes no more than 1 hour after the order submission procedure itself. A number of engines are offered, so anytime you set up a MySQL database through the Hepsia hosting Control Panel, a specific engine will be selected once the app installation commences and our system will automatically detect which engine is required by the app in question. If you need 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 application installer.
InnoDB in Dedicated Hosting
Our Hepsia Control Panel is one of the features that you can choose on the server order page when you buy a dedicated server from us. As this is the most powerful kind of web hosting, it is quite likely that you will manage highly popular Internet sites that will draw plenty of people, and since InnoDB is among the very best choices for such websites, we will enable it along with all the other software applications that are available with a Hepsia-managed dedicated server. If you set up a brand-new MySQL database in your dedicated server account, there won’t be any activated storage engine till you begin installing an open-source script, whether manually via your browser or using the automatic script installer that is included in the hosting Control Panel. The needed engine will be detected automatically and will be assigned to that database, so you can install scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without coming across any impediment.