InnoDB is a database storage engine for MySQL relational databases, which is used by widely used open-source script-powered applications like Joomla 3 and Magento. It is excellent for scalable applications, as it works stunningly well when managing large volumes of data. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can process much more operations for the same length of time. Additionally, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – rules that indicate how data imports and modifications should be treated. If a specific operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and won’t be partially mixed with newly appended content.

InnoDB in Cloud Website Hosting

InnoDB is available with all our cloud website hosting plans by default, not as a paid upgrade or upon request, so you will be able to install and run any script-driven web application which needs the InnoDB storage engine without the need to deal with any obstacle once you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app installation process, irrespective of whether you take advantage of our single-click installer or create the MySQL database and install the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll maintain regular database backups, so you can be sure that you won’t ever lose any content in case you erase a database by mistake or you overwrite some important information – you’ll simply need to get in touch with us and we will restore your database back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans come with InnoDB and you can take advantage of all the features offered by this database engine with any open-source script-based software application that needs it. It is one of the engines that we have on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the respective app. You won’t have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we’ll generate daily database backups, so if something goes wrong after some update or if you remove some content unintentionally, we’ll be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is selected during the signup process for your new VPS web hosting plans , InnoDB will be installed on the server together with other required pieces of software, so you will not have to do anything if you choose to activate script-powered apps that need this MySQL database engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand-new MySQL database and start installing the app manually or through our 1-click installer tool. The system will recognize the engine that the application in question needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the application can import its data into that database. Therefore, you can use apps with various prerequisites in regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you will be able to select one of the three hosting Control Panels offered by our company – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to add this database storage engine manually so as to be able to use open-source script-driven apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the resources that you require to manage large-scale sites, it’s pretty likely that you’ll use InnoDB. You will be able to use other engines as well, so in case a particular app needs MyISAM instead of InnoDB, you will not run into any impediment while managing it. The engine that will be used will be automatically detected when the app installation process begins, so you will not have to tweak any setting manually at any point.