InnoDB is a very popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has plenty of upsides that make it the engine of choice for plenty of PHP script-driven web applications, such as Joomla and Magento, which have switched over to InnoDB permanently. For example, importing immense volumes of data will be much faster with InnoDB, because it locks only one row to complete a given task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is handled. In simpler words, appending new or updating existent data will either be fully completed, or will be canceled and the procedure will be rolled back if a certain issue appears during the process, so the content that remains in the database will not be lost.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting companies, it is included in the standard set of features that we are offering with our shared hosting packages. If you would like to make use of an open-source script-powered app that needs InnoDB particularly, in order to be installed and to perform properly, you won’t have any impediments since the InnoDB database storage engine is available on our custom cloud platform. Irrespective of whether you create a brand new MySQL database and install an application manually or use our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular app needs InnoDB instead of MyISAM. In addition to the remarkable database crash recovery offered by InnoDB, we also generate daily backups of all databases, so that we can quickly restore any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB comes with each of our semi-dedicated hosting services by default, so once you order a new account, you can go ahead and activate any script-based application that needs this particular MySQL storage engine. A few engines are installed on our cloud platform, so when you create a brand-new MySQL database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be chosen based on the prerequisites of the respective app. This will permit you to install and manage InnoDB-specific applications without having to cope with any problem and without the need to edit any settings in your semi-dedicated account. To avoid any risk, we will always keep a 1-week-old backup of all your MySQL databases, so if you delete or change any content unintentionally, we can swiftly restore it.
InnoDB in VPS Web Hosting
When you buy a virtual private server from us, you’ll be able to take full advantage of our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to activate any PHP script-driven web application that needs InnoDB, as this particular MySQL storage engine is an integral part of the standard software bundle that will be pre-installed on your VPS server during its setup. When you set up a new MySQL database via the Control Panel, you will just have to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine if the application in question needs it, so you will not have to do anything else in your VPS account. Correspondingly, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Servers Hosting
InnoDB comes as standard with all Linux dedicated servers hosting ordered with the Hepsia hosting Control Panel. It’s included in the default software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is up and running, you’ll be able to sign in and to activate any type of PHP script-driven web application that needs this particular MySQL database storage engine. When you create a new database through the hosting Control Panel, there won’t be any active engine till you begin installing an application. Once the app activation wizard begins dumping data in the database, the engine will be chosen automatically based on the particular app’s prerequisites, so you can run both InnoDB and MyISAM without selecting either of them explicitly at any time. Thus, you can use an immense selection of apps for your websites.