InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got plenty of strengths which make it the preferred engine for a lot of PHP-driven apps, such as Magento and Joomla™, which have shifted over to InnoDB for good. For example, adding large data volumes will be faster with InnoDB, because it locks only a single database row to accomplish a certain operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is treated. Simply put, importing new or updating existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case a certain issue occurs during the process, so the content that remains in the database will not be damaged.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the hosting Control Panel included with each of our semi-dedicated server accounts and you start installing a script-driven application either manually or using our 1-click application installer tool, the storage engine for the database will be selected automatically based on the specific app’s prerequisites. Since InnoDB is available on the cloud hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without any manual action required on your end at any point. To avoid any chance of losing information if you update an application or if you remove a database by accident, we will make a backup of all your databases every day, so if anything happens, we can restore your data.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-built Hepsia hosting Control Panel come with a software package that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t have to install it manually if you need to use PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to start the setup process – as soon as the script configuration wizard obtains access to the database in question and begins inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to activate scripts that need the other widely used MySQL engine, MyISAM, so you will not have to change any settings on the server. This will allow you to use various scripts on a single machine and to use it to its maximum capabilities.