InnoDB is a very popular storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got many upsides which make it the engine of choice for lots of open-source script-driven software apps, such as Magento and Joomla, which have moved to InnoDB for good. For example, importing large volumes of data will be faster with InnoDB, due to the fact that it locks only one row to complete a particular task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is treated. Simply put, adding new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case a given issue appears in the meantime, so the content that remains in the database will not be lost.
InnoDB in Shared Web Hosting
While InnoDB is either not available or a paid upgrade with other web hosting companies, it’s an essential part of the standard set of services that we are offering with our shared web hosting packages. If you’d like to use a PHP-based web app that requires InnoDB specifically, in order to be installed and to work properly, you will not come across any impediments because the storage engine is available on our custom cloud Internet hosting platform. Irrespective of whether you set up a brand new MySQL database and install an app manually or make use of our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB instead of MyISAM. Besides the remarkable crash recovery offered by InnoDB, we also maintain daily database backups, so that we can easily recover any database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our semi-dedicated packages by default, so once you buy a new account, you can move on and activate any open-source script-driven software app that requires this MySQL database storage engine. A number of engines are pre-installed on our cloud hosting platform, so when you set up a new database and begin installing an application manually, or decide to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be selected on the basis of the prerequisites of the specific application. This will allow you to install and run InnoDB-specific applications without running into any impediment and without needing to update any settings in your semi-dedicated account. To take no chances, we’ll always keep a one-week-old backup of all your databases, so if you remove or edit any content by mistake, we can easily rescue it.
InnoDB in VPS Web Hosting
All Linux VPS web hosting that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to run any PHP script-powered software application that needs the MySQL database engine without having to install anything manually. You can select Hepsia on the VPS order page and your new server will be ready within one hour, so you can log in and start creating your web sites straight away. Once you set up a brand new database and start the app activation process, our system will select the engine for that MySQL database automatically. In this way, you can install different applications at the same time without the need to update anything on the Virtual Private Server. You can have a WordPress-powered online journal that makes use of MyISAM – the default MySQL engine, and a Magento-powered Internet shop that makes use of InnoDB, for example.
InnoDB in Dedicated Servers Hosting
InnoDB is available by default with all dedicated servers hosting ordered with the Hepsia hosting Control Panel. It is part of the standard software bundle that we install on all Hepsia-equipped dedicated servers, so once your physical machine is set up, you will be able to sign in and to activate any script-powered application that requires this particular storage engine. If you set up a new database through the Control Panel, there won’t be any active engine until you start installing an application. Once the app activation wizard starts inserting data into the newly created database, the engine will be chosen automatically on the basis of the requirements of the given app, so you can use both InnoDB and MyISAM without the need to select either one specifically at any moment. Therefore, you can make use of a vast variety of apps for your websites.