InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-driven web applications like Joomla™ v3 and Magento. It is excellent for scalable apps, as it works very well when managing enormous data volumes. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same period of time. Besides, InnoDB offers an improved database crash recovery and supports database transactions and foreign key constraints – rules that specify how data imports and modifications should be handled. If a given task has not been fully completed for any reason, the action will be rolled back. In this way, the content in the database will remain intact and won’t be partially merged with newly appended content.

InnoDB in Web Hosting

InnoDB is offered with all our Linux web hosting plans by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP script-powered app that needs the database storage engine without any impediments once you activate your account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation, regardless of whether you take advantage of our single-click installation tool or create the database and install the application manually, provided that the app requires it instead of the more popular MyISAM engine. We’ll maintain daily MySQL database backups, so you can rest assured that you won’t ever lose any data if you delete a database unintentionally or you overwrite some key information – you will just need to get in touch with us and we’ll restore the database back to normal.

InnoDB in Semi-dedicated Servers

InnoDB is offered with each of our semi-dedicated plans by default, so once you purchase a new account, you can go ahead and activate any open-source script-based software application that needs this particular database engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you set up a brand new MySQL database and begin installing an application manually, or opt to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen on the basis of the requirements of the app in question. This will permit you to activate and run InnoDB-specific applications without needing to cope with any impediment and without the need to change any settings in your account. To take no chances, we will always keep a 1-week-old backup of all your databases, so if you erase or alter any content accidentally, we can swiftly rescue it.

InnoDB in VPS Servers

In case our custom-developed Hepsia Control Panel is picked during the signup process for a new VPS plans , InnoDB will be activated on the server along with other essential pieces of software, so you will not have to do anything if you choose to activate open-source script-based web applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand new MySQL database and start the app installation procedure manually or through our 1-click installer tool. The system will detect which engine the app in question requires and will assign it to the specific MySQL database, so the installation will continue flawlessly and the app can import its data into that database. Thus, you can make use of apps with different requirements with regard to the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our in-house built Hepsia Control Panel come with a software package that is pre-installed and among everything else, you will get the InnoDB database engine, so you will not have to add it manually if you want to use open-source PHP scripts that require it. All it takes to activate such a script is to set up a new database and to initiate the installation – once the script configuration wizard receives access to the database in question and begins importing data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that require the other widely used MySQL engine – MyISAM, so you won’t need to update any settings on the server. This will permit you to use a variety of scripts on one single physical machine and to use it to its maximum potential.