InnoDB is a storage engine for MySQL relational databases, which is used by well known PHP script-powered web applications such as Magento and Joomla 3.x. It’s ideal for scalable applications, as it excels in processing immense volumes of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. Additionally, InnoDB offers a much better database crash recovery and supports transactions and foreign key constraints – rules that define how data imports and updates should be treated. If a specific operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will remain safe and sound and will not be partially mixed with newly inserted content.

InnoDB in Hosting

While InnoDB is either not offered or it is a paid upgrade with many other hosting service providers, it is an integral part of the standard set of features that we offer with our hosting plans. In case you wish to use an open-source script-driven web app that needs InnoDB in particular, in order to be activated and to operate correctly, you won’t have any obstacles because the InnoDB storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you create a new database and activate an app manually or take advantage of our single-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the specific app requires it instead of MyISAM. In addition to the outstanding crash recovery offered by InnoDB, we also store regular database backups, so that we can swiftly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

You can run a script-driven app that requires InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our cutting-edge cloud hosting platform where the database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our 1-click application installer tool. Either way, the required engine will be picked automatically the moment the application’s activation starts, so you will not have to update anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. Also, we will always be able to recover any of your databases if you unintentionally delete one, as we generate a few database backups every day, each of which is saved for 1 whole week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to run any PHP-powered app that requires the database engine without needing to activate anything manually. You can choose Hepsia on the VPS order page and your brand-new Virtual Private Server will be up and running within 1 hour, so you can log in and begin setting up your web sites right away. When you set up a brand new MySQL database and start the app installation process, our system will pick the engine for that MySQL database automatically. Thus, you can install various apps at the same time without configuring anything on the VPS server. You can create a WordPress-powered online journal that makes use of the default MySQL engine – MyISAM, and a Magento-based online store that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you will be able to pick one of the three hosting Control Panels offered by our company – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to install this MySQL database storage engine manually in order to be able to manage script-based web apps that require it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you require in order to run large-size Internet sites, it is rather likely that you’ll use InnoDB. You will be able to use other engines as well, so in case a given app needs MyISAM instead of InnoDB, you won’t have to deal with any difficulty while using it. The engine that will be used will be detected automatically when the app installation procedure starts, so you will not have to alter any setting manually at any point.