InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has a lot of strengths that make it the preferred engine for numerous PHP script-based apps, including Magento and Joomla, which have shifted over to InnoDB permanently. For instance, importing large amounts of data will be faster with InnoDB, because it locks only one row to complete a given task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is handled. In simpler words, importing new or editing existing data will either be fully completed, or will be canceled and the operation will be rolled back in case a given issue shows up during the process, thus the content that remains in the database won’t be lost.

InnoDB in Web Hosting

You will be able to activate any script-driven application that requires InnoDB if you’ve got a web hosting service with us, as the MySQL database storage engine is present on our cutting-edge cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can install applications that use the MyISAM engine without any problem as well and, once again, the engine will be pre-selected, so you will not need to change any setting manually at any moment. Furthermore, we will also generate regular backups of all the databases that you have in your account, so in case you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our Linux semi-dedicated service by default, so once you create a new semi-dedicated account, you can go ahead and install any open-source script-driven web application that needs the database engine. A couple of engines are installed on our cloud hosting platform, so when you create a brand new database and start installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be chosen in accordance with the prerequisites of the respective application. This will allow you to activate and manage InnoDB-specific applications without the need to cope with any impediment and without the need to edit any settings in your semi-dedicated account. To take no chances, we will always keep a seven-day-old backup of all your MySQL databases, so if you remove or alter any content accidentally, we can swiftly retrieve it.

InnoDB in VPS Servers

In case our custom Hepsia Control Panel is picked during the signup process for a new VPS servers , InnoDB will be installed on the Virtual Private Server along with other necessary software, so you will not need to do anything if you choose to make use of open-source script-based web apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand-new MySQL database and begin installing the app manually or through our one-click installer tool. The system will automatically recognize the engine that the app in question requires and will assign it to the specific database, so the installation process will continue impeccably and the application can import its data into that database. Thus, you can install apps with various prerequisites about the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It’s part of the software package that will be installed on all Hepsia-equipped dedicated servers, so once your physical machine is set up, you’ll be able to log in and to install any type of PHP-powered software app that needs this particular storage engine. When you set up a new database via the Control Panel, there won’t be any activated engine till you begin installing an app. Once the app activation wizard starts dumping data in the newly created database, the engine will be picked automatically in accordance with the requirements of the specific app, so you can use both MyISAM and InnoDB without the need to select either one explicitly at any moment. In this way, you can make use of a large collection of applications for your Internet sites.