InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has a number of upsides which have made it the preferred engine for numerous PHP script-driven software applications, among them Magento and Joomla, which have shifted over to InnoDB for good. For instance, adding huge volumes of data will be much faster with InnoDB, as it locks only one database row to execute a specific task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is treated. Simply put, appending new or editing existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case some problem occurs during the process, thus the content that remains in the database will not be damaged.

InnoDB in Cloud Website Hosting

Every script-driven application that requires InnoDB will function flawlessly on our avant-garde cloud hosting platform and the MySQL database engine comes with all our cloud website hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected on the basis of the app’s prerequisites without having to update any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We will generate daily content backups, so in case you accidentally remove a MySQL database that’s important to you or you overwrite certain parts of it, we will be able to restore the database the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

You can make use of an open-source script-powered app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our avant-garde cloud hosting platform where the storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our single-click app installer tool. In either case, the needed engine will be chosen automatically once the app’s installation begins, so you won’t need to update anything manually, irrespective of whether the app requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you remove one by mistake, as we create several backups every day, each of which is kept for one whole week.

InnoDB in VPS Servers

In case our in-house built Hepsia Control Panel is chosen during the registration process for a new VPS web hosting plans , InnoDB will be installed on the VPS server together with other required pieces of software, so you will not need to do anything if you decide to activate script-based software applications that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed too. You can create a brand-new MySQL database and start the app installation process manually or using our 1-click installer tool. The system will detect the engine that the application in question requires and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can import its content into that database. Thus, you can use applications with various prerequisites with regard to the MySQL engine without the need to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you’ll be able to pick any of the three Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not need to activate this MySQL database engine manually to be able to manage script-driven apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you need to manage very large Internet sites, it is quite likely that you’ll use InnoDB. You will be able to make use of other engines as well, so if a certain application needs MyISAM instead of InnoDB, you won’t have any difficulty while managing it. The engine that will be used will be detected automatically once the app installation process commences, so you will not need to edit any setting manually at any time.