InnoDB is a popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has plenty of strengths that make it the engine of choice for a lot of open-source script-powered web apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For example, importing large amounts of data will be faster with InnoDB, because it locks only one database row to accomplish a certain operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is tackled. Simply put, appending new or updating existing data will either be fully completed, or will be aborted and the operation will be rolled back if any issue appears in the meantime, therefore the content that remains in the database will not be lost.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosting providers, it is an essential part of the standard set of features that we offer with our cloud web hosting plans. If you’d like to use an open-source script-based web app that needs InnoDB particularly, in order to be installed and to function correctly, you won’t come across any problems because the InnoDB database storage engine is available on our in-house developed cloud platform. Regardless of whether you set up a brand-new MySQL database and activate an application manually or make use of our 1-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the respective app needs InnoDB instead of MyISAM. In addition to the remarkable database crash recovery offered by InnoDB, we also store daily database backups, so that we can swiftly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you’ll be able to get the most out of all the features of this database engine with any PHP script-driven software application that needs it. It’s one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the particular application. You won’t need to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we’ll make daily MySQL database backups, so if anything goes wrong after some update or if you delete some content by accident, we will be able to get your database back to the way it was on any of the previous seven days.

InnoDB in VPS Servers

If our in-house built Hepsia Control Panel is chosen during the registration process for a new VPS web hosting plans , InnoDB will be installed on the server along with other necessary software, so you won’t have to do anything if you decide to run PHP-based software apps that require this MySQL database engine. The default MySQL engine – MyISAM, will be activated too. You can create a brand new MySQL database and begin the app installation process manually or using our 1-click installer tool. The system will detect the engine that the app in question needs and will set it for the specific database, so the installation will continue flawlessly and the application can dump its content in that database. In this way, you can install applications with different prerequisites regarding the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

All Linux dedicated servers that are ordered with our custom Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t have to add it manually if you want to activate open-source scripts that require it. All it takes to install such a script is to create a new MySQL database and to start the setup – once the script installation wizard gets access to the database and starts dumping content in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the particular script. You will also be able to install scripts that need the other popular MySQL engine – MyISAM, so you will not have to update any settings on the server. This will enable you to use various scripts on one single physical machine and to use the latter to its maximum capabilities.