InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and a faster crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of devs that create scalable apps, as it works much more effectively with large volumes of data, while it keeps the server processing load at a minimum. In addition, it locks only a single row in the database if any information should be modified, whereas lots of other engines lock the entire table and therefore need much more time to execute several sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification process cannot be completed for any reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest editions of Joomla are two instances of widely used open-source script-powered apps which have shifted over to InnoDB.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our cloud website hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any script-based software application that needs the database engine without encountering any impediment once you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app activation, irrespective of whether you make use of our single-click installation tool or create the database and activate the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll maintain daily backups of all your databases, so you can be sure that you’ll never lose any content if you delete a database by accident or you overwrite some essential info – you simply have to touch base with us and we will restore everything the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated hosting service by default, so the moment you create a new semi-dedicated account, you can move on and activate any PHP-powered app that needs the database storage engine. A few engines are installed on our cloud hosting platform, so when you create a brand-new MySQL database and start installing an application manually, or decide to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected on the basis of the requirements of the specific application. This will permit you to install and manage InnoDB-specific apps without needing to deal with any problem and without modifying any settings in your semi-dedicated account. To avoid any risk, we will always keep a seven-day-old backup of all your databases, so if you erase or change any content by accident, we can easily retrieve it.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia Control Panel, the InnoDB database engine will be part of the default software package that will be pre-installed on your server before we give it to you. You will not have to activate anything manually and you will be able to enable and run any open-source script-driven application that requires InnoDB once your Virtual Private Server is ready, which takes no more than 1 hour after the order submission process itself. Several engines are available, so anytime you create a MySQL database through the Hepsia hosting Control Panel, a specific engine will be selected once the app activation process starts and our system will detect the engine that is required by the app in question. In case you need to use MyISAM, for instance, you will not have to do anything different from installing the desired app, whether manually or using our application installer.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our in-house built Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database engine, so you will not have to activate it manually in case you’d like to activate PHP scripts that require it. All it takes to run such a script is to create a new MySQL database and to start the installation process – as soon as the script setup wizard obtains access to the database and starts entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to run scripts that require the other widely used MySQL engine – MyISAM, so you will not need to update any settings on the server. This will permit you to activate different scripts on a single physical server and to use it to its fullest capabilities.