InnoDB is a database storage engine for MySQL relational databases, which is used by famous open-source script-powered apps like Joomla 3.x and Magento. It is perfect for scalable apps, since it works amazingly well when handling enormous amounts of data. Instead of locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can process much more tasks for the same length of time. Also, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – rules that determine how data inserts and updates should be treated. If a given task hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will be preserved intact and will not be partially mixed with newly added content.

InnoDB in Website Hosting

You can install any PHP-powered web application that needs InnoDB in case you have a Linux website hosting plan with our company, as the MySQL database engine is available on our leading-edge cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can activate apps which use the MyISAM engine without the need to deal with any obstacle as well and, once again, the engine will be selected automatically, so you won’t need to configure anything manually at any point. In addition, we’ll also perform daily backups of all the MySQL databases that you have in your account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel included with each of our semi-dedicated server plans and you start installing a PHP script-based software app either manually or using our one-click application installer, the storage engine for the database will be set automatically depending on the specific app’s requirements. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without any manual intervention needed on your end at any time. To avoid any chance of losing info if you update an application or if you remove a database by mistake, we’ll make a backup of all your databases each and every day, so if anything happens, we can restore your content.

InnoDB in VPS Servers

In case our custom-built Hepsia Control Panel is picked during the signup process for a new VPS hosting plans , InnoDB will be installed on the server along with other necessary software, so you won’t need to do anything if you decide to activate PHP-powered applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand new MySQL database and start installing the app manually or using our one-click installer tool. The system will recognize the engine that the particular app requires and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can enter its content into that database. In this way, you can install apps with various requirements with regard to the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house built Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually in case you’d like to use open-source PHP scripts that need it. All it takes to use such a script is to create a new MySQL database and to start the setup – once the script setup wizard gets access to the database and begins importing content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You’ll also be able to install scripts that need the other very popular MySQL engine, MyISAM, so you will not need to configure any settings on the server. This will permit you to install a variety of scripts on a single physical machine and to use it to its fullest potential.