InnoDB is a very popular database engine for MySQL. It is an alternative to the default MyISAM engine and it has got plenty of upsides which make it the engine of choice for a lot of open-source script-driven web apps, among them Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, adding large volumes of data will be much faster with InnoDB, because it locks only one database row to execute a particular operation, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is tackled. Put simply, importing new or updating existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if some issue appears during the process, hence the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

Any open-source script-powered app that needs InnoDB will function impeccably on our leading-edge cloud hosting platform and the database engine is available with all our shared hosting plans. Whenever you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without having to configure any setting in your shared account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We will generate regular content backups, so in case you accidentally erase a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore your content the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our semi-dedicated plans by default, so the moment you obtain a new account, you can go ahead and activate any PHP-powered web app that requires this MySQL database engine. A couple of engines are pre-installed on our cloud website hosting platform, so when you create a brand new MySQL database and begin installing an application manually, or opt to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked in accordance with the prerequisites of the respective application. This will permit you to activate and manage InnoDB-specific apps without having to deal with any complication and without needing to edit any settings in your account. To avoid any risk, we will always have a 1-week-old backup of all your databases, so if you delete or edit any content by mistake, we can quickly rescue it.

InnoDB in VPS Servers

In case our custom Hepsia hosting Control Panel is picked during the registration process for your new VPS hosting plans , InnoDB will be installed on the VPS server together with other necessary software, so you won’t need to do anything if you choose to install script-driven web applications that require this MySQL storage engine. MyISAM, the default MySQL engine, will be activated as well. You can set up a brand new MySQL database and begin the app installation procedure manually or using our 1-click installer tool. The system will automatically detect the engine that the application in question requires and will set it for the specific database, so the installation will proceed impeccably and the application can enter its data into that database. In this way, you can use apps with different prerequisites regarding the MySQL engine without having to make any modifications on your VPS.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to choose any of the 3 hosting Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to activate this MySQL database engine manually to be able to use open-source script-based web apps that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the resources that you require to run large-size Internet sites, it is pretty likely that you will resort to InnoDB. You’ll be able to use other engines too, so if a specific app needs MyISAM instead of InnoDB, you will not have any complication while running it. The engine that will be used will be recognized automatically once the app installation procedure commences, so you will not have to alter any settings manually at any point.