InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster database failure recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by numerous developers that write scalable apps, due to the fact that it works more efficiently with immense volumes of data, while it keeps the server processing load at a minimum. Also, it locks only a single row in the database if any info should be modified, while lots of other engines lock the entire table and thus require more time to accomplish several successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for some reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest Joomla™ releases are two instances of widespread PHP script-based software applications which have switched to InnoDB.

InnoDB in Cloud Web Hosting

You’ll be able to use any PHP-powered software app that requires InnoDB if you’ve got a Linux cloud web hosting with us, as the MySQL storage engine is available on our innovative cloud hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is required. You can run apps which need the MyISAM engine without having any difficulty as well and, once again, the engine will be selected automatically, so you will not need to edit any setting manually at any moment. Furthermore, we will also carry out regular backups of all the MySQL databases that you have in the shared web hosting account, so if you delete or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our Linux semi-dedicated hosting plans by default, so once you obtain a new account, you can go ahead and install any PHP-powered application that needs this particular MySQL database engine. A number of engines are installed on our cloud website hosting platform, so when you set up a brand new database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked in accordance with the prerequisites of the app in question. This will permit you to activate and manage InnoDB-specific apps without experiencing any complication and without updating any settings in your semi-dedicated account. To be on the safe side, we’ll always keep a one-week-old backup of all your databases, so if you erase or edit any content accidentally, we can quickly restore it.

InnoDB in VPS Servers

If our custom-built Hepsia hosting Control Panel is selected during the registration process for your new VPS web hosting plans , InnoDB will be installed on the server together with other essential software, so you will not have to do anything if you decide to install script-based web applications that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a new database and begin the app installation procedure manually or using our one-click installer. The system will detect which engine the particular app requires and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the application can dump its data in that database. Therefore, you can manage applications with different prerequisites with regard to the MySQL engine without having to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

If you get a new dedicated server, you will be able to pick any of the 3 hosting Control Panels that we are offering – DirectAdmin, Hepsia and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to add this database engine manually in order to be able to manage PHP-powered web apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the resources that you require to run large-size websites, it is quite possible that you’ll resort to InnoDB. You’ll be able to make use of other engines too, so if a certain app requires MyISAM rather than InnoDB, you will not come across any difficulty while managing it. The engine that will be used will be automatically recognized the moment the app installation procedure commences, so you will not need to alter any setting manually at any point.