InnoDB is a storage engine for MySQL relational databases, which is used by widely used open-source script-driven web applications like Joomla 3.x and Magento. It is excellent for scalable apps, as it works stunningly well when processing enormous amounts of data. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can process much more operations for the same length of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – a set of rules that define how data inserts and modifications should be handled. If a given task has not been fully completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved undamaged and will not be partially merged with newly added content.
InnoDB in Shared Hosting
InnoDB is available with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you will be able to install and manage any PHP-powered web app which needs the MySQL storage engine without encountering any impediment as soon as you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation process, irrespective of whether you take advantage of our one-click installer or create the MySQL database and set up the application manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We will perform daily backups of all your databases, so you can be certain that you will never lose any data if you delete a database by mistake or you overwrite some key information – you will just have to notify us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated servers support InnoDB and you’ll be able to take full advantage of all the features of this MySQL storage engine with any PHP-powered app that requires it. It’s among the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the requirements of the application in question. You will not need to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To be on the safe side, we will store daily MySQL database backups, so if something goes wrong following some update or if you remove some content by accident, we will be able to restore the database the way it was on any of the previous 7 days.
InnoDB in VPS Servers
When you obtain a VPS server from our company, you will be able to make use of our custom-developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to activate any open-source script-driven software app which requires InnoDB, as this MySQL database storage engine is included in the standard software package that will be pre-installed on the server during its creation. When you create a brand-new MySQL database using the hosting Control Panel, you just need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the app in question requires it, so you won’t need to do anything else in your account. Likewise, if an app requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
All Linux dedicated servers that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that is pre-activated and among everything else, you will get the InnoDB database engine, so you won’t need to activate it manually in case you would like to use PHP scripts that need it. All it takes to install such a script is to set up a new MySQL database and to start the setup – as soon as the setup wizard obtains access to the database in question and begins entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to use scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to configure any settings on the dedicated server. This will allow you to activate different scripts on one single physical machine and to use it to its maximum capabilities.