InnoDB is a database engine for MySQL databases, which is used by famous script-driven applications such as Magento and Joomla 3.x. It is ideal for scalable apps, because it works stunningly well when handling immense data volumes. Rather than locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. Moreover, InnoDB offers a better database crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be handled. In case a given task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and won’t be partially merged with newly appended content.
InnoDB in Shared Hosting
InnoDB is offered with all our Linux shared hosting service by default, not as a paid upgrade or upon request, so you can install and manage any script-based web application which needs the InnoDB database engine without the need to deal with any difficulty once you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, no matter if you make use of our single-click installation tool or create the MySQL database and activate the app manually, as long as the app requires it instead of the more famous MyISAM engine. We’ll maintain daily database backups, so you can be certain that you won’t ever lose any content in case you delete a database by mistake or you overwrite some essential info – you will just have to touch base with us and we will restore your database the way it was.
InnoDB in Semi-dedicated Servers
You can activate a PHP-based app that needs InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are created on our advanced cloud platform where the MySQL storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our single-click app installer tool. Either way, the needed engine will be chosen automatically once the activation of the application begins, so you will not have to change anything manually, regardless of whether the application needs InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to recover any of your databases if you remove one by accident, as we generate a few MySQL database backups every day, each of which is preserved for one week.
InnoDB in VPS Servers
All Linux VPS web hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to run any PHP-powered app that needs this MySQL database engine without needing to configure anything manually. You can pick Hepsia on the VPS configuration page and your new Virtual Private Server will be ready within 1 hour, so you can log in and begin creating your sites straight away. Once you create a brand-new MySQL database and start the app activation process, our system will pick the engine for this MySQL database automatically. Thus, you can activate various apps at the same time without having to modify anything on the VPS server. You can set up a WordPress-driven blog that makes use of the default MySQL engine – MyISAM, and a Magento-based shopping portal that uses InnoDB, for example.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is among the options that you can select on the order form when you purchase a dedicated server from us. As this is the most powerful type of web hosting, it is quite likely that you’ll run popular websites that will attract lots of visitors, and since InnoDB is among the best choices for such sites, we will activate it together with all the other software applications that are available with a Hepsia-managed dedicated server. If you set up a brand-new database in your account, there won’t be any activated database engine until you begin installing a script, whether manually through your Internet browser or using the automatic script installer that is integrated into the Control Panel. The needed engine will be automatically recognized and will be set for the database in question, so you can activate scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without having any difficulty.