InnoDB is a database storage engine for MySQL databases, which is used by well known PHP script-driven apps such as Joomla v3 and Magento. It’s excellent for scalable apps, as it performs unbelievably well when processing 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 database row, so it can handle a lot more tasks for the same length of time. In addition, InnoDB offers a better database failure recovery and supports database transactions and foreign keys – rules that define how data imports and updates should be handled. If a certain task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and will not be partially merged with newly added content.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any open-source script-driven software application that needs the MySQL storage engine without having to deal with any problem as soon as you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app activation process, no matter if you use our single-click installation tool or create the database and set up the app manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll make daily backups of all your MySQL databases, so you can be sure that you won’t ever lose any content if you erase a database by mistake or you overwrite some key info – you’ll simply have to inform us and we will restore the database back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our Linux semi-dedicated hosting by default, so the moment you obtain a new semi-dedicated account, you can move on and activate any PHP-powered application that needs the MySQL database storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you set up a new MySQL database and begin installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected in accordance with the prerequisites of the application in question. This will allow you to install and run InnoDB-specific apps without having to cope with any complication and without needing to configure any settings in your account. To be on the safe side, we’ll always keep a one-week-old backup of all your databases, so if you delete or alter any content by mistake, we can swiftly retrieve it.
InnoDB in Dedicated Web Hosting
If you obtain a new dedicated server, you’ll be able to pick one of the three Control Panels offered by us – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to add this MySQL database storage engine manually to be able to use open-source script-powered software apps that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the server resources that you require to run large-scale sites, it’s quite possible that you will use InnoDB. You’ll be able to make use of other engines too, so in case a certain application needs MyISAM rather than InnoDB, you won’t have to deal with any predicament while managing it. The engine that will be used will be automatically recognized when the app installation procedure commences, so you won’t have to configure any setting manually at any moment.