InnoDB is a storage engine for MySQL databases, which is used by widespread PHP-based apps like Magento and Joomla v3. It’s excellent for scalable applications, since it performs unbelievably well when processing large volumes of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same length of time. What’s more, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – rules that specify how data inserts and modifications should be treated. In case a particular operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will be retained safe and sound and won’t be partially mixed with new content.

InnoDB in Web Hosting

You will be able to run any open-source script-driven software app that needs InnoDB in case you’ve got a Linux web hosting service with our company, as the MySQL database storage engine is available on our innovative cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can install apps that need the MyISAM engine without any impediments as well and, again, the engine will be selected automatically, so you won’t need to modify anything manually at any moment. In addition, we will also create daily backups of all the databases that you have in your account, so if you delete or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting service support InnoDB and you can use all the options offered by this MySQL database engine with any script-based web app that requires it. InnoDB is one of the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the specific app. You won’t have to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our 1-click application installer tool. To be on the safe side, we’ll generate regular database backups, so if anything goes wrong following some update or if you erase some data accidentally, we’ll be able to restore the database the way it was on any of the past 7 days.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to make use of any PHP script-powered software app that requires this storage engine without the need to set up anything manually. You can pick Hepsia on the VPS order page and your brand new server will be set up within one hour, so you can log in and begin building your websites straight away. Once you create a brand new database and start the app installation process, our system will pick the engine for this MySQL database automatically. In this way, you can run various applications simultaneously without having to change anything on the VPS server. You can have a WordPress-powered personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-driven web shop that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

InnoDB comes as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s included in the default software package that will be installed on all Hepsia-managed dedicated servers, so once your machine is up and running, you’ll be able to log in and to install a various open-source script-driven web application that needs this particular database storage engine. When you create a new database through the Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app activation wizard starts dumping content in the newly created database, the engine will be picked automatically depending on the prerequisites of the given application, so you can use both MyISAM and InnoDB without having to select either one explicitly at any time. Therefore, you can make use of an immense range of applications for your sites.