InnoDB is a database engine for MySQL databases, which is used by popular PHP script-driven software applications like Joomla 3.x and Magento. It’s perfect for scalable applications, as it performs amazingly well when processing enormous amounts of data. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can perform much more tasks for the same period of time. Plus, InnoDB offers a faster database failure recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and updates should be treated. If a particular operation has not been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and will not be partially merged with newly inserted content.
InnoDB in Shared Hosting
InnoDB is available with all our shared hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-powered app which needs the InnoDB database storage engine without having to deal with any impediment once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app activation, irrespective of whether you make use of our one-click installation tool or create the database and set up the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will perform regular MySQL database backups, so you can be certain that you won’t ever lose any content in case you erase a database unintentionally or you overwrite some essential info – you will simply need to notify us and we will restore your database back to normal.
InnoDB in Semi-dedicated Hosting
You can install a PHP script-based web application that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our avant-garde cloud platform where the MySQL database engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our 1-click app installer tool. Either way, the needed engine will be selected automatically the moment the installation of the app begins, so you will not have to update anything manually, irrespective of whether the application requires InnoDB or the more commonly used MyISAM. On top of that, we will always be able to recover any of your databases in case you accidentally erase one, as we carry out a couple of backups every day, each of which is saved for one whole week.
InnoDB in VPS
If you pick a virtual private server with our Hepsia hosting Control Panel, the InnoDB database engine will be part of the default software bundle that will be installed on your server before we hand it over to you. You will not have to set up anything manually and you will be able to install and use any PHP-driven app that requires InnoDB as soon as your Virtual Private Server is set up, which takes no more than 1 hour after the order submission process itself. A couple of engines are offered, so every time you set up a database via the Hepsia Control Panel, a particular engine will be activated once the app activation commences and our system will automatically recognize the engine that is required by the app in question. In case you need MyISAM, for instance, you won’t need to do anything different from installing the application of your preference, whether manually or using our application installer.
InnoDB in Dedicated Hosting
Our Hepsia Control Panel is among the features which you can pick on the order form when you buy a dedicated server from us. Since this is the most powerful type of web hosting, it’s very likely that you’ll manage highly popular Internet sites that will attract lots of people, and since InnoDB is among the very best options for such Internet sites, we’ll activate it together with all the other software apps that come with a Hepsia-equipped server. When you create a new MySQL database in your dedicated account, there won’t be any activated database engine until you start installing a script, whether manually via your Internet browser or using the automatic script installer tool that is integrated into the Control Panel. The necessary engine will be detected automatically and will be set for the database in question, so you can run scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without any obstacle.