InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it provides a much better overall performance and an improved crash recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by numerous devs that run highly scalable web applications, as it works much better with immense volumes of data, while it keeps the server load at a minimum. In addition, it uses row-level locking in case any info should be updated, whereas many other engines lock the entire table and thus need more time to carry out multiple successive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest releases of Joomla™ are two examples of famous PHP-based software platforms that have switched to InnoDB.
InnoDB in Shared Hosting
InnoDB is offered 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 open-source script-based software application that needs the InnoDB database engine without the need to deal with any difficulty as soon as you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation, irrespective of whether you make use of our single-click installer or create the database and activate the application manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We will store daily database backups, so you can rest assured that you will never lose any content if you erase a database accidentally or you overwrite some vital info – you’ll simply have to get in touch with us and we will restore the database the way it was.
InnoDB in Semi-dedicated Hosting
You can run a script-driven web app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our avant-garde cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our single-click application installer tool. Either way, the needed engine will be chosen automatically once the app’s installation begins, so you won’t need to change anything manually, regardless of whether the application needs InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to recover any of your databases if you remove one by mistake, as we perform a few backups every day, each of which is kept for 1 week.
InnoDB in VPS Hosting
If our custom Hepsia Control Panel is selected during the signup process for a new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server together with other necessary software, so you will not have to do anything if you choose to install PHP-driven apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be activated as well. You can create a new database and begin installing the app manually or through our 1-click installer. The system will detect which engine the app in question requires and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can insert its data into that database. Therefore, you can activate apps with different requirements concerning the MySQL engine without the need to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Web Hosting
If you acquire a new dedicated server, you will be able to select any of the 3 hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to activate this database engine manually so as to be able to use PHP script-based web apps that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the resources that you require in order to manage large-size websites, it’s pretty likely that you will resort to InnoDB. You’ll be able to make use of other engines as well, so if a given application requires MyISAM instead of InnoDB, you will not experience any difficulty while using it. The engine that will be used will be automatically recognized the moment the app installation procedure begins, so you won’t have to tweak any settings manually whatsoever.