InnoDB is a storage engine for MySQL relational databases, which is used by widespread PHP-driven applications such as Magento and Joomla v3. It’s perfect for scalable applications, since it performs exceptionally well when managing enormous data volumes. Instead of locking the whole table to add new information to a database as many other engines do, InnoDB locks only one row, so it can carry out much more operations for the same length of time. Also, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – a set of rules that define how data inserts and updates should be handled. In case a specific task hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the database content will stay intact and won’t be partially merged with newly inserted content.

InnoDB in Cloud Hosting

Any PHP-driven web app that needs InnoDB will run impeccably on our cutting-edge cloud platform and the MySQL database storage engine comes with all our cloud hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected based on the app’s specifications without having to update any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full capacity. We’ll store daily content backups, so in case you accidentally erase a MySQL database that’s important to you or you overwrite certain parts of it, we’ll be able to restore your content the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

You can activate an open-source script-powered web application that needs InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud hosting platform where the MySQL storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our single-click app installer. In either case, the required engine will be chosen automatically once the installation of the application starts, so you won’t have to change anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to retrieve any of your databases in case you remove one by mistake, as we carry out several backups every day, each of which is saved for 1 week.

InnoDB in Dedicated Servers

If you get a new dedicated server, you’ll be able to pick one of the 3 Control Panels offered by our company – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to enable this storage engine manually in order to be able to manage PHP-driven web applications that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the system resources that you require to manage large-size Internet sites, it is quite likely that you’ll use InnoDB. You will be able to make use of other engines too, so in case a specific app needs MyISAM rather than InnoDB, you won’t run into any problem while running it. The engine that will be used will be detected automatically the moment the app installation process commences, so you will not have to configure any settings manually at any time.