InnoDB is a storage engine for MySQL databases, which is used by widespread script-driven web applications like Joomla™ v3 and Magento. It’s perfect for scalable apps, because it works really well when handling huge amounts of data. Instead of locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same period of time. In addition, InnoDB offers a better crash recovery and supports transactions and foreign keys – a set of rules that define how data imports and modifications should be handled. If a particular task has not been entirely completed for any 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 imported content.
InnoDB in Hosting
InnoDB is offered with all our Linux hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-based app which requires the database storage engine without the need to deal with any obstacle once you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, regardless of whether you make use of our single-click installation tool or create the MySQL database and set up the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll make daily backups of all your MySQL databases, so you can be sure that you’ll never lose any content if you delete a database by mistake or you overwrite some essential information – you simply have to touch base with us and we will restore everything back to normal.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting include InnoDB and you can take advantage of all the features of this database storage engine with any PHP script-powered application that needs it. It’s among the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the given app’s prerequisites. You won’t need to do anything manually in order to enable InnoDB, as it will be set as the default engine when you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we’ll generate daily backups of all your databases, so if something goes wrong following some update or if you erase some content by accident, we will be able to restore the database the way it was on any of the previous 7 days.
InnoDB in Dedicated Hosting
InnoDB is available as standard with all Linux dedicated hosting ordered with the Hepsia Control Panel. It’s an integral part of the software package that will be installed on all Hepsia-managed dedicated servers, so once your machine is assembled, you’ll be able to log in and to install any type of script-driven web application that needs this storage engine. If you set up a new MySQL database through the Control Panel, there won’t be any active engine until you start installing an application. Once the app installation wizard starts dumping information in the database, the engine will be chosen automatically in accordance with the respective app’s prerequisites, so you can run both MyISAM and InnoDB without the need to select either one specifically at any point. In this way, you can use a vast selection of applications for your Internet sites.