InnoDB is a database storage engine for MySQL relational databases, which is used by widespread PHP-based software apps like Joomla 3 and Magento. It is excellent for scalable applications, as it works astonishingly well when managing immense data volumes. Rather than locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. Also, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and updates should be treated. In case a particular task has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will stay undamaged and won’t be partially mixed with newly added content.

InnoDB in Hosting

InnoDB is available with all our Linux hosting by default, not upon request or as a paid upgrade, so you will be able to activate and manage any open-source script-based web app that needs the InnoDB database engine without any problems once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app installation process, irrespective of whether you take advantage of our single-click installation tool or create the database and activate the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We will perform daily backups of all your MySQL databases, so you can rest assured that you will never lose any data in case you erase a database by mistake or you overwrite some crucial info – you’ll just have to touch base with us and we will restore everything the way it was.

InnoDB in Semi-dedicated Servers

You can run a PHP script-driven app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our avant-garde cloud hosting platform where the MySQL database storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our single-click app installer tool. In either case, the required engine will be chosen automatically as soon as the application’s activation starts, so you will not need to modify anything manually, regardless of whether the application needs InnoDB or the more regularly used MyISAM. On top of that, we’ll always be able to restore any of your MySQL databases in case you unintentionally remove one, as we generate several database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be installed on the server together with other needed software, so you will not have to do anything if you decide to use open-source script-based software applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a brand new MySQL database and begin the app installation procedure manually or using our one-click installer tool. The system will detect which engine the particular app needs and will assign it to the specific database, so the installation process will continue flawlessly and the app can import its content into that database. In this way, you can manage apps with different prerequisites concerning the MySQL engine without the need to make any changes on your VPS.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you will be able to select any of the 3 Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to activate this MySQL storage engine manually in order to be able to use script-driven apps that need it. InnoDB is used by scalable applications and since a dedicated server will give you all the server resources that you need to run large-size Internet sites, it is quite likely that you will use InnoDB. You will be able to use other engines as well, so if a given app needs MyISAM instead of InnoDB, you won’t need to deal with any impediment while running it. The engine that will be used will be recognized automatically as soon as the app installation process starts, so you won’t need to tweak any setting manually at any point.