InnoDB is a very popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got lots of strengths which make it the engine of choice for lots of open-source script-based software applications, among them Joomla and Magento, which have shifted over to InnoDB for good. For example, adding immense data volumes will be faster with InnoDB, since it locks only a single row to execute a given task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the data is treated. Put simply, appending new or modifying existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case some issue occurs during the process, so the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many other website hosting service providers, it’s included in the standard set of features offered with our shared hosting packages. If you’d like to make use of an open-source script-driven software app that requires InnoDB particularly, in order to be activated and to work correctly, you will not encounter any impediments as the MySQL database storage engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an application manually or use our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective application requires it rather than MyISAM. In addition to the outstanding database crash recovery offered by InnoDB, we also carry out daily backups of all databases, so we can swiftly recover any database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
You can use an open-source script-based app that requires InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our advanced cloud platform where the storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our 1-click application installer. In either case, the needed engine will be selected automatically once the app’s installation begins, so you won’t have to modify anything manually, no matter if the app requires InnoDB or the more regularly used MyISAM. On top of that, we will always be able to recover any of your databases if you remove one by accident, as we make several MySQL database backups every day, each of which is kept for 1 whole week.
InnoDB in VPS Hosting
All Linux VPS hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to use any open-source script-powered software app that requires this particular MySQL database storage engine without the need to install anything manually. You can pick Hepsia on the VPS order form and your brand-new Virtual Private Server will be up and running within 60 minutes, so you can log in and begin creating your Internet sites right away. Once you create a brand new MySQL database and begin the app installation process, our system will set the engine for this MySQL database automatically. Thus, you can activate various applications at the same time without having to update anything on the Virtual Private Server. You can set up a WordPress-based online journal that makes use of MyISAM – the default MySQL engine, and a Magento online shopping portal that uses the InnoDB engine, for instance.
InnoDB in Dedicated Web Hosting
InnoDB comes by default with all Linux dedicated web hosting that are ordered with the Hepsia hosting Control Panel. It is an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your machine is up and running, you’ll be able to sign in and to activate a various PHP-based app that needs this particular database storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you begin installing an application. As soon as the app setup wizard starts dumping information in the database, the engine will be selected automatically based on the requirements of the respective application, so you can use both MyISAM and InnoDB without the need to select either of them explicitly at any time. Therefore, you can use an extensive collection of apps for your Internet sites.