InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got a number of advantages which make it the engine of choice for a lot of PHP script-driven web applications, such as Magento and Joomla™, which have switched to InnoDB permanently. For instance, adding huge amounts of data will be faster with InnoDB, as it locks only a single database row to accomplish an operation, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is tackled. To put it simply, adding new or updating existing data will either be thoroughly completed, or will be aborted and the operation will be rolled back if any problem appears during the process, which is why the content that remains in the database will not be damaged.

InnoDB in Cloud Website Hosting

You’ll be able to make use of any script-based web application that needs InnoDB in case you’ve got a cloud website hosting with us, as the MySQL database engine is available on our leading-edge cloud platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can run apps which use the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be selected automatically, so you won’t have to update any setting manually at any point. In addition, we will also generate daily backups of all the databases that you have in your shared hosting account, so in case you delete or overwrite anything, we can easily restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB is offered with each of our Linux semi-dedicated hosting services by default, so the moment you purchase a new account, you can move on and activate any PHP script-powered web application that requires this storage engine. A few engines are pre-installed on our cloud hosting platform, so when you create a new MySQL database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected depending on the given app’s prerequisites. This will permit you to install and run InnoDB-specific applications without coming across any complication and without the need to configure any settings in your semi-dedicated account. To avoid any risk, we will always keep a 1-week-old backup of all your databases, so if you erase or alter any content unintentionally, we can swiftly retrieve it.

InnoDB in VPS Web Hosting

If you buy a virtual private server from us, you’ll be able to use our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will allow you to install any script-powered application that needs InnoDB, as this storage engine is an integral part of the software bundle that will be installed on the Virtual Private Server during its configuration. When you set up a new database using the Control Panel, you will just need to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine as long as the application in question needs it, so you will not have to do anything else in your VPS account. Identically, if a given app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers Hosting

If you obtain a new dedicated server, you will be able to choose one of the three Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to activate this database engine manually in order to be able to manage open-source script-based software apps that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you require to run very large sites, it is quite likely that you’ll use InnoDB. You’ll be able to make use of other engines too, so if a particular application requires MyISAM instead of InnoDB, you will not experience any difficulty while managing it. The engine that will be used will be automatically recognized when the app installation process commences, so you won’t have to edit any settings manually at any point.