InnoDB is a database engine for MySQL databases, which is used by widely used PHP script-driven web apps such as Magento and Joomla™ v3. It is excellent for scalable apps, as it works remarkably well when managing immense data volumes. Instead of locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can perform much more operations for the same length of time. Also, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – rules that specify how data imports and modifications should be handled. In case a certain operation hasn’t been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will stay undamaged and won’t be partially merged with newly imported content.

InnoDB in Website Hosting

You’ll be able to use any script-driven application that needs InnoDB in case you’ve got a website hosting plan with our company, as the MySQL database engine is present on our innovative cloud web hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can run apps which need the MyISAM engine without encountering any obstacle as well and, once again, the engine will be pre-selected, so you won’t need to edit any setting manually at any moment. In addition, we’ll also carry out daily backups of all the MySQL databases that you have in the shared hosting account, so if you delete or overwrite something, we can quickly get it back to the way it was on any of the past seven days.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia hosting Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not have to activate it manually if you want to run scripts that need it. All it takes to install such a script is to create a new database and to start the setup process – once the script setup wizard obtains access to the database in question and begins importing content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You’ll also be able to run scripts that require the other widely used MySQL engine – MyISAM, so you will not have to edit any settings on the server. This will allow you to use a variety of scripts on one single server and to use it to its maximum capacity.