InnoDB is a database storage engine for MySQL relational databases, which is used by widely used PHP script-based software applications like Magento and Joomla v3. It is excellent for scalable applications, since it performs very well when handling large volumes of data. Instead of locking the entire table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same period of time. What’s more, InnoDB offers an improved crash recovery and supports transactions and foreign keys – rules that prescribe how data imports and updates should be handled. In case a specific operation has not been fully completed for any reason, the action will be rolled back. Thus, the content in the database will remain safe and sound and won’t be partially merged with newly appended content.

InnoDB in Shared Hosting

You’ll be able to install any PHP script-driven web application that needs InnoDB if you have a shared hosting with our company, as the storage engine is available on our avant-garde cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can run applications which require the MyISAM engine without any difficulty as well and, again, the engine will be selected automatically, so you will not need to configure anything manually at any time. Furthermore, we will also perform regular backups of all the databases that you’ve got in your shared account, so in case you erase or overwrite anything, we can swiftly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you will be able to use all the features offered by this MySQL database engine with any script-based web application that requires it. It’s one of the engines that we have on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the particular app. You won’t need to do anything manually to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our single-click application installer. To be on the safe side, we’ll carry out regular MySQL database backups, so if something goes wrong following some update or if you remove some content accidentally, we will be able to restore the database the way it was on any of the past seven days.

InnoDB in VPS Servers

If our in-house built Hepsia hosting Control Panel is selected during the signup process for your new VPS servers , InnoDB will be installed on the Virtual Private Server together with other required software, so you will not need to do anything if you choose to install script-based web applications that need this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand new MySQL database and begin the app installation procedure manually or using our one-click installer. The system will detect which engine the particular app needs and will set it for the specific database, so the installation will proceed impeccably and the app can import its data into that database. Thus, you can install applications with different prerequisites regarding the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features that you can select on the server order page when you buy a dedicated server from our company. As this is the most powerful type of hosting, it’s very likely that you’ll manage very popular Internet sites that will attract lots of visitors, and since InnoDB is one of the best options for such Internet sites, we will activate it together with all the other software applications that are offered with a Hepsia-equipped dedicated server. When you create a new database in your dedicated server account, there won’t be any active MySQL database engine till you begin installing a PHP script, whether manually through your browser or using the automatic script installation tool that is included in the hosting Control Panel. The required engine will be recognized automatically and will be set for that database, so you can run scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without coming across any difficulty.