InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a lot of upsides which have made it the engine of choice for lots of PHP-driven software apps, among them Magento and Joomla, which have switched to InnoDB permanently. For example, adding large data volumes will be much faster with InnoDB, due to the fact that it locks only a single database row to execute a specific operation, 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 information is handled. Simply put, importing new or modifying existing data will either be entirely completed, or will be canceled and the procedure will be rolled back if a given issue appears during the process, so the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

You can use any open-source script-based app that requires InnoDB in case you’ve got a cloud hosting plan with us, as the storage engine is available on our advanced cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can activate applications that need the MyISAM engine without the need to deal with any obstacle as well and, once again, the engine will be pre-selected, so you will not have to change any setting manually at any time. Furthermore, we will also perform daily backups of all the MySQL databases that you have in the shared hosting account, so if you delete or overwrite something, we can easily restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our Linux semi-dedicated hosting plans by default, so the moment you create a new semi-dedicated account, you can go ahead and activate any PHP-driven web app that needs the database storage engine. A few engines are pre-installed on our cloud website hosting platform, so when you create a brand new MySQL database and start installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be selected based on the concrete app’s prerequisites. This will allow you to install and manage InnoDB-specific applications without needing to deal with any obstacle and without modifying any settings in your account. To be on the safe side, we will always keep a 1-week-old backup of all your MySQL databases, so if you remove or edit any content by mistake, we can quickly retrieve it.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the software package that will be pre-installed on your Virtual Private Server before we give it to you. You will not need to configure anything manually and you’ll be able to install and use any PHP script-based app that needs InnoDB when your VPS server is up and running, which takes no more than one hour after the order submission itself. A couple of engines are available, so anytime you set up a database through the Hepsia hosting Control Panel, a particular engine will be picked once the app activation process starts and our system will automatically detect the engine that is required by the app in question. If you need MyISAM, for instance, you will not have to do anything different than installing the desired application, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It is an essential part of the software package that we install on all Hepsia-managed servers, so as soon as your machine is up and running, you will be able to log in and to install any kind of open-source script-driven software application that requires this MySQL database engine. When you set up a new database through the Control Panel, there won’t be any activated engine until you start installing an application. Once the app installation wizard begins dumping information in the newly created database, the engine will be chosen automatically on the basis of the prerequisites of the particular app, so you can run both MyISAM and InnoDB without having to select either one of them specifically at any time. Thus, you can use a huge variety of apps for your sites.