InnoDB is a database engine for MySQL relational databases, which is used by popular script-driven web apps like Magento and Joomla 3.x. It’s excellent for scalable apps, because it performs astonishingly well when managing huge data volumes. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same period of time. Plus, InnoDB offers a faster database failure recovery and supports database transactions and foreign key constraints – rules that define how data imports and modifications should be treated. If a certain operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will be kept safe and sound and will not be partially merged with newly imported content.
InnoDB in Cloud Hosting
InnoDB is offered with all our cloud hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any PHP script-powered web application which requires the storage engine without any impediments as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation, irrespective of whether you make use of our single-click installer or create the MySQL database and set up the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll create daily backups of all your MySQL databases, so you can rest assured that you won’t ever lose any data in case you delete a database by accident or you overwrite some essential information – you will just have to touch base with us and we’ll restore your data back to normal.
InnoDB in Semi-dedicated Hosting
You can activate a PHP-based web app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our advanced cloud hosting platform where the MySQL database engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you use our 1-click app installer tool. Either way, the required engine will be picked automatically as soon as the activation of the application begins, so you won’t have to change anything manually, irrespective of whether the application needs InnoDB or the more commonly used MyISAM. On top of that, we will always be able to restore any of your MySQL databases if you erase one by accident, as we perform a couple of database backups every day, each of which is kept for seven days.
InnoDB in VPS
All VPS services that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you will be able to run any open-source script-driven web application that needs the MySQL storage engine without the need to set up anything manually. You can pick Hepsia on the VPS order form and your brand new server will be set up within 1 hour, so you can sign in and start building your web sites right away. When you set up a brand new database and begin the app activation process, our system will pick the engine for this MySQL database automatically. In this way, you can run different apps at the same time without the need to configure anything on the Virtual Private Server. You can set up a WordPress-based online blog that makes use of the default MySQL engine – MyISAM, and a Magento e-store that makes use of InnoDB, for example.
InnoDB in Dedicated Hosting
When you order a new dedicated server, you will be able to choose any of the three hosting Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to enable this MySQL storage engine manually so as to be able to manage script-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the resources that you require in order to manage large-scale sites, it’s pretty possible that you will resort to InnoDB. You will be able to use other engines too, so in case a particular app requires MyISAM rather than InnoDB, you will not have to deal with any difficulty while using it. The engine that will be used will be detected automatically as soon as the app installation starts, so you will not have to configure any setting manually at any point.