InnoDB is a database storage engine for MySQL databases, which is used by widely used PHP script-driven web apps like Joomla v3 and Magento. It’s perfect for scalable applications, as it performs unbelievably well when handling huge data volumes. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. Moreover, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data imports and updates should be treated. If a given operation has not been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will stay intact and will not be partially mixed with newly appended content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting service providers, it’s included in the standard set of features that we’re offering with our cloud hosting packages. In case you would like to make use of a script-based software application that needs InnoDB particularly, in order to be activated and to operate correctly, you will not encounter any impediments as the InnoDB database storage engine is available on our custom-built cloud web hosting platform. Irrespective of whether you set up a new database and install an application manually or take advantage of our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires InnoDB rather than MyISAM. Besides the incredible database crash recovery offered by InnoDB, we also generate regular backups of all databases, so that we can swiftly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the hosting Control Panel offered with all our semi-dedicated server packages and you begin installing a script-driven application either manually or using our one-click app installer tool, the database storage engine will be picked automatically on the basis of the prerequisites of the specific application. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for each app that needs it without any manual action needed on your end at any moment. To prevent any risk of losing info if you update an app or if you erase a database by mistake, we’ll make a backup of all your databases every day, so if anything happens, we can retrieve your data.

InnoDB in VPS Servers

All Linux VPS servers that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to use any PHP script-driven web application that requires this particular MySQL database storage engine without having to install anything manually. You can choose Hepsia on the VPS order form and your brand-new Virtual Private Server will be ready within sixty minutes, so you can log in and start creating your web sites right away. Once you set up a new MySQL database and begin the app installation process, our system will pick the engine for that database automatically. Thus, you can use different applications simultaneously without having to configure anything on the Virtual Private Server. You can create a WordPress-based personal weblog that makes use of the default MySQL engine – MyISAM, and a Magento-powered e-commerce website that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options that you can pick on the order page when you purchase a dedicated server from our company. As this is the most powerful type of web hosting, it is pretty likely that you will manage highly popular sites that will draw many visitors, and since InnoDB is among the best choices for such Internet sites, we’ll enable it along with all the other software applications that are available with a Hepsia-managed server. If you create a new MySQL database in your dedicated server account, there won’t be any active MySQL database engine till you start installing a PHP script, whether manually through your browser or using the automatic script installer tool that is integrated into the Control Panel. The required engine will be automatically detected and will be set for that database, so you can run scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having any difficulty.