InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a better overall performance and a faster database failure recovery compared to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by numerous web developers that run scalable apps, because it works more effectively with immense volumes of data, while it keeps the server processing load low. What’s more, it locks only a single database row if any info should be edited, whereas many other engines lock the entire database table and hence require much more time to fulfill several successive 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 data loss. Magento and the latest Joomla™ releases are two examples of widely used script-based apps which have switched to InnoDB.

InnoDB in Website Hosting

InnoDB is offered with all our Linux website hosting packages by default, not as a paid upgrade or upon request, so you can activate and run any open-source script-powered software app that needs the database engine without having to deal with any impediment as soon as you open your shared hosting account. InnoDB will be pre-selected as the default engine for a particular database during the app installation process, no matter if you use our one-click installation tool or create the MySQL database and install the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We will perform daily database backups, so you can rest assured that you’ll never lose any data if you delete a database accidentally or you overwrite some vital information – you’ll just have to contact us and we’ll restore the database the way it was.

InnoDB in VPS Hosting

If our custom-built Hepsia hosting Control Panel is selected during the signup process for a new Linux VPS hosting packages , InnoDB will be activated on the VPS server along with other needed software, so you will not have to do anything if you choose to activate PHP-based applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated too. You can set up a new database and start the app installation procedure manually or through our single-click installer tool. The system will detect the engine that the app in question needs and will assign it to the specific database, so the installation process will proceed impeccably and the application can dump its data in that database. Therefore, you can manage applications with various requirements in regard to the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house built Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you will not need to activate it manually in case you would like to activate open-source scripts that require it. All it takes to install such a script is to set up a new MySQL database and to begin the setup – once the setup wizard acquires access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You’ll also be able to run scripts that require the other popular MySQL engine, MyISAM, so you won’t need to configure any settings on the server. This will allow you to install various scripts on one single physical machine and to use it to its maximum capabilities.