InnoDB is a database storage engine for MySQL relational databases, which is used by popular script-based web apps like Magento and Joomla 3.x. It’s perfect for scalable applications, as it works really well when handling huge data volumes. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can complete much more operations for the same period of time. Also, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data imports and modifications should be treated. In case a specific task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will remain safe and sound and will not be partially merged with newly entered content.

InnoDB in Cloud Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosting providers, it’s an integral part of the default set of features offered with our cloud website hosting plans. If you wish to use a script-powered app that needs InnoDB particularly, in order to be activated and to operate correctly, you will not need to deal with any impediments because the database engine is available on our custom-built cloud web hosting platform. Irrespective of whether you create a new MySQL database and install an app manually or use our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific app needs it instead of MyISAM. Besides the outstanding database failure recovery offered by InnoDB, we also keep regular database backups, so we can easily restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

You can activate a PHP script-based web application that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our avant-garde cloud web hosting platform where the database engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our one-click application installer tool. In either case, the needed engine will be selected automatically the moment the application’s activation begins, so you will not need to configure anything manually, regardless of whether the app requires InnoDB or the more widely used MyISAM. On top of that, we’ll always be able to retrieve any of your databases if you accidentally erase one, as we create a few database backups every day, each of which is preserved for 1 week.

InnoDB in VPS

If our custom Hepsia hosting Control Panel is selected during the signup process for a new Linux VPS packages , InnoDB will be activated on the server along with other needed pieces of software, so you won’t have to do anything if you choose to install PHP-powered apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a brand new database and start installing the app manually or using our 1-click installer tool. The system will detect the engine that the particular application needs and will set it for the specific MySQL database, so the installation will proceed impeccably and the application can import its content into that database. In this way, you can use applications with different prerequisites in regard to the MySQL engine without the need to make any changes on your server.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages that are ordered with our custom-built Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t have to install it manually in case you need to activate scripts that need it. All it takes to run such a script is to set up a new database and to begin the setup process – once the installation wizard acquires access to the database in question and starts entering content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You will also be able to run scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to modify any settings on the server. This will enable you to install a variety of scripts on one single physical server and to use it to its fullest capacity.