InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got many strengths that make it the engine of choice for many script-powered web applications, such as Joomla and Magento, which have switched over to InnoDB permanently. For instance, adding large amounts of data will be faster with InnoDB, because it locks only a single database row to carry out a task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is handled. To put it simply, adding new or updating existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back if some problem appears during the process, which means that the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

Every open-source script-based app that requires InnoDB will function flawlessly on our cutting-edge cloud hosting platform and the MySQL storage engine comes with all our shared hosting plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s requirements without having to update any setting in your account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll create daily backups of your content, so if you unintentionally remove a database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your data the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Hosting

You can make use of a script-driven web app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our advanced cloud hosting platform where the storage engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click app installer. In either case, the required engine will be picked automatically once the app’s activation starts, so you will not need to change anything manually, irrespective of whether the app requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to retrieve any of your MySQL databases in case you delete one by mistake, as we carry out several database backups every day, each of which is preserved for 7 days.

InnoDB in VPS

If our in-house developed Hepsia hosting Control Panel is picked during the registration process for a new Linux VPS packages , InnoDB will be activated on the VPS server together with other required software, so you will not need to do anything if you decide to use PHP script-based software applications that require this MySQL storage 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 single-click installer. The system will detect which engine the application in question needs and will assign it to the specific database, so the installation will proceed impeccably and the application can enter its content into that database. Therefore, you can use applications with various requirements in regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Hosting

If you obtain a new dedicated server, you’ll be able to choose any of the three Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to enable this MySQL database engine manually in order to be able to manage script-powered web applications that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the resources that you require in order to manage large-scale websites, it is pretty possible that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so if a given app requires MyISAM instead of InnoDB, you will not encounter any impediment while managing it. The engine that will be used will be detected automatically when the app installation process begins, so you will not need to fine-tune any setting manually at any time.