InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a much better overall performance and a faster database crash recovery compared to the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by numerous devs that build scalable apps, due to the fact that it works more effectively with enormous amounts of data, while it keeps the server load low. Furthermore, it uses row-level locking if anything should be edited, while lots of other engines lock the entire table and hence need much more time to accomplish multiple successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for whatever reason, the operation is rolled back to prevent scrambling or losing data. Magento and the latest Joomla™ releases are two instances of widespread script-driven applications that have shifted over to InnoDB.

InnoDB in Shared Web Hosting

InnoDB is available with all our shared web hosting plans by default, not upon request or as a paid upgrade, so you can install and run any PHP-powered app which requires the storage engine without encountering any problem once you activate your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation, regardless of whether you use our 1-click installer or create the MySQL database and install the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We’ll maintain regular database backups, so you can rest assured that you will never lose any data in case you delete a database by mistake or you overwrite some key info – you will simply need to notify us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Servers

You can install a script-driven web app that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our leading-edge cloud platform where the MySQL storage engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you use our 1-click application installer tool. In either case, the needed engine will be picked automatically the moment the app’s activation starts, so you won’t have to configure anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to restore any of your databases in case you unintentionally erase one, as we create a couple of MySQL database backups every day, each of which is saved for 1 week.

InnoDB in VPS Servers

All VPS plans that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to take advantage of any script-driven software application that requires this database engine without having to set up anything manually. You can pick Hepsia on the VPS order form and your new Virtual Private Server will be ready within 60 minutes, so you can sign in and start creating your websites right away. Once you set up a brand-new MySQL database and begin the app activation process, our system will set the engine for this database automatically. In this way, you can manage different apps at the same time without editing anything on the server. You can create a WordPress-based online journal that uses the default MySQL engine – MyISAM, and a Magento online shopping portal that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you will be able to choose one of the three hosting Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to activate this storage engine manually so as to be able to run PHP-powered apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you need to manage very large Internet sites, it’s rather possible that you will use InnoDB. You will be able to make use of other engines too, so if a particular application requires MyISAM instead of InnoDB, you won’t have any obstacle while running it. The engine that will be used will be recognized automatically as soon as the app installation procedure starts, so you won’t need to update any setting manually whatsoever.