InnoDB is a database engine for MySQL relational databases, which is used by well known script-based apps such as Joomla v3 and Magento. It is ideal for scalable applications, because it performs unbelievably well when processing immense amounts of data. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same period of time. Besides, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – a set of rules that specify how data inserts and updates should be handled. In case a given task has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved safe and sound and won’t be partially merged with newly entered content.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many other web hosting providers, it’s an integral part of the standard set of services offered with our shared hosting plans. In case you’d like to use a PHP script-based software app that needs InnoDB particularly, in order to be installed and to function properly, you won’t have any difficulties as the MySQL storage engine is available on our custom cloud hosting platform. No matter if you create a brand-new MySQL database and install an app manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the given app requires InnoDB rather than MyISAM. Besides the incredible crash recovery offered by InnoDB, we also perform daily database backups, so that we can quickly restore any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
InnoDB is included with each of our semi-dedicated servers by default, so the moment you purchase a new semi-dedicated account, you can move on and install any PHP-based web app that needs this particular MySQL database engine. Several engines are pre-installed on our cloud website hosting platform, so when you create a brand new MySQL database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked based on the respective app’s prerequisites. This will permit you to install and run InnoDB-specific apps without running into any complication and without the need to update any settings in your semi-dedicated account. To be on the safe side, we’ll always have a 7-day-old backup of all your MySQL databases, so if you erase or edit any content by mistake, we can swiftly rescue it.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the features which you can select on the order form when you purchase a dedicated server from our company. As this is the most powerful kind of web hosting, it’s very likely that you’ll run highly popular websites that will draw plenty of visitors, and since InnoDB is among the best options for such websites, we’ll activate it together with all the other software apps that are offered with a Hepsia-equipped server. If you set up a brand new database in your 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 scripts installer tool that is available in the Control Panel. The required engine will be recognized and will be set for that database, so you can install scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without running into any predicament.