InnoDB is a database engine for MySQL relational databases, which is used by widely used script-powered software apps like Joomla 3.x and Magento. It’s ideal for scalable apps, since it works remarkably well when managing immense volumes of data. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more operations for the same length of time. In addition, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – rules that define how data imports and modifications should be handled. If a specific task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will stay undamaged and will not be partially merged with newly entered content.

InnoDB in Shared Website Hosting

InnoDB is offered with all our Linux shared website hosting by default, not as a paid upgrade or upon request, so you can activate and manage any PHP-powered application which requires the database storage engine without any difficulties once you order your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation process, irrespective of whether you use our 1-click installation tool or create the database and activate the app manually, as long as the app requires it instead of the more famous MyISAM engine. We will store regular database backups, so you can rest assured that you will never lose any content if you delete a database accidentally or you overwrite some key info – you will just need to touch base with us and we will restore your content back to normal.

InnoDB in Semi-dedicated Hosting

You can activate a PHP script-driven application that requires InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our cutting-edge cloud platform where the storage engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you use our single-click application installer tool. In either case, the needed engine will be selected automatically the moment the activation of the application starts, so you won’t need to update anything manually, no matter if the app requires InnoDB or the more widely used MyISAM. On top of that, we will always be able to restore any of your databases if you unintentionally delete one, as we create a few backups every day, each of which is stored for one whole week.

InnoDB in VPS

In case our in-house developed Hepsia Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be installed on the server along with other necessary pieces of software, so you will not need to do anything if you decide to make use of script-based software applications that require this MySQL database engine. MyISAM – the default MySQL engine, will be activated too. You can set up a new database and start installing the app manually or using our one-click installation tool. The system will automatically recognize which engine the particular application needs and will assign it to the specific database, so the installation will proceed flawlessly and the application can import its data into that database. Thus, you can run apps with different prerequisites regarding the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Hosting

Our Hepsia hosting Control Panel is among the features that you can choose on the server order page when you buy a dedicated server from our company. As this is the most powerful type of hosting, it is rather likely that you will manage popular websites that will draw a lot of individuals, and since InnoDB is one of the very best options for such sites, we’ll enable it along with all the other software applications that are offered with a Hepsia-equipped dedicated server. If you create a new database in your account, there won’t be any activated MySQL database engine till you start installing a PHP script, whether manually through your browser or using the automatic script installer that is available in the Control Panel. The required engine will be detected automatically and will be set for the database in question, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without needing to cope with any problem.