InnoDB is a storage engine for MySQL relational databases, which is used by well known PHP script-based applications such as Magento and Joomla™ 3. It is perfect for scalable applications, since it performs stunningly well when processing enormous amounts of data. Instead of locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one row, so it can carry out much more tasks for the same period of time. Furthermore, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – rules that determine how data inserts and modifications should be treated. If a given task hasn’t been fully completed for any reason, the action will be rolled back. Thus, the database content will remain safe and sound and will not be partially merged with newly added content.
InnoDB in Shared Hosting
Every PHP script-driven app that needs InnoDB will function impeccably on our innovative cloud hosting platform and the MySQL database engine is offered with all our shared hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will use will be selected on the basis of the app’s specifications without the need to change any setting in your hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to take advantage of its full potential. We’ll keep daily backups of your content, so if you unintentionally erase a MySQL database that’s important to you or you overwrite some part of it, we will be able to restore the database the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our semi-dedicated plans by default, so the moment you purchase a new semi-dedicated account, you can move on and activate any PHP-driven software application that needs the database storage engine. Several engines are installed on our cloud platform, so when you create a new MySQL database and begin installing an application manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be set on the basis of the prerequisites of the app in question. This will allow you to install and manage InnoDB-specific apps without having to cope with any obstacle and without having to change any settings in your semi-dedicated account. To be on the safe side, we will always have a 1-week-old backup of all your databases, so if you delete or change any content accidentally, we can swiftly restore it.
InnoDB in VPS Servers
If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be part of the software bundle that will be installed on your VPS server before we give it to you. You won’t have to configure anything manually and you will be able to install and use any PHP-powered software application that requires InnoDB when your Virtual Private Server is ready, which takes no more than 1 hour after the order process itself. A couple of engines are available, so anytime you create a database through the Hepsia hosting Control Panel, a particular engine will be selected when the app installation process starts and our system will recognize the engine that is required by the app in question. In case you need MyISAM, for instance, you won’t have to do anything different from installing the chosen application, whether manually or using our application installer.
InnoDB in Dedicated Servers
All dedicated web hosting plans that are ordered with our custom-developed Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually in case you want to run PHP scripts that require it. All it takes to run such a script is to set up a new database and to initiate the setup process – as soon as the installation wizard gets access to the database and begins importing data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the script. You’ll also be able to use scripts that need MyISAM, the other widely used MySQL engine, so you will not have to update any settings on the dedicated server. This will enable you to activate a variety of scripts on one single server and to use it to its full capacity.