InnoDB is a popular database engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has lots of strong sides which make it the preferred engine for many open-source script-based web apps, including Joomla™ and Magento, which have switched over to InnoDB for good. For instance, importing large data volumes will be much faster with InnoDB, due to the fact that it locks only one database row to accomplish a task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is handled. Put simply, importing new or editing existing data will either be fully completed, or will be aborted and the operation will be rolled back in case any issue shows up during the process, thus the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

Every open-source script-powered software application that requires InnoDB will function flawlessly on our avant-garde cloud platform and the MySQL database storage engine is offered with all our cloud hosting packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without having to configure any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We’ll make regular backups of your content, so if you accidentally erase a MySQL database that is important to you or you overwrite certain parts of it, we’ll be able to restore everything the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our Linux semi-dedicated plans by default, so as soon as you purchase a new account, you can go on and install any PHP-based web app that requires this particular MySQL database engine. A couple of engines are pre-installed on our cloud website hosting platform, so when you create a new MySQL database and start installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be picked depending on the requirements of the given application. This will allow you to activate and manage InnoDB-specific applications without the need to cope with any obstacle and without the need to change any settings in your semi-dedicated account. To avoid any risk, we will always keep a seven-day-old backup of all your databases, so if you erase or edit any content by mistake, we can swiftly rescue it.

InnoDB in VPS Servers

If you obtain a VPS server from us, you’ll be able to use our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will allow you to run any open-source script-based software application which needs InnoDB, as this database storage engine is an essential part of the standard software bundle that will be pre-installed on your Virtual Private Server during its configuration. When you create a brand new MySQL database using the Control Panel, you simply have to start installing an application – manually or using our app installer. InnoDB will be set as the default engine if the app in question needs it, so you won’t need to do anything else in your VPS account. Likewise, if an application needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you’ll be able to pick any of the 3 Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-installed, so you won’t need to enable this MySQL database storage engine manually to be able to use open-source script-based web applications that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you need to manage very large sites, it is rather possible that you’ll resort to InnoDB. You’ll be able to use other engines as well, so if a particular app needs MyISAM instead of InnoDB, you won’t experience any difficulty while using it. The engine that will be used will be detected automatically as soon as the app installation commences, so you won’t need to change any setting manually at any time.