InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by numerous developers that create highly scalable applications, because it works much better with enormous data volumes, while it keeps the server load low. Additionally, it locks only one database row if any information should be modified, while many other engines lock the entire table and hence require much more time to carry out multiple successive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest versions of Joomla™ are two examples of widespread open-source script-powered web applications that have switched to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with other hosting providers, it is an integral part of the standard set of services offered with our shared hosting plans. In case you wish to use an open-source script-driven app that needs InnoDB specifically, in order to be activated and to work correctly, you won’t need to deal with any problems because the MySQL storage engine is available on our custom-developed cloud platform. Irrespective of whether you create a brand new MySQL database and install an app manually or use our one-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application needs InnoDB rather than MyISAM. Besides the amazing database crash recovery that InnoDB offers, we also make daily backups of all databases, so that we can quickly restore any database in your shared account.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database from the Control Panel provided with all our semi-dedicated server plans and you start installing a script-based software app either manually or using our single-click app installer, the storage engine for the MySQL database will be picked automatically on the basis of the prerequisites of the particular application. As InnoDB is available on the cloud web hosting platform where your new account will be set up, it will be set as the default engine for each app that needs it without any manual intervention required on your end at any moment. To prevent any chance of losing information if you update an app or if you remove a database unintentionally, we’ll make a backup of all your MySQL databases each day, so if something happens, we can restore your data.
InnoDB in VPS Servers
If our custom Hepsia Control Panel is chosen during the registration process for a new VPS servers , InnoDB will be activated on the server together with other required software, so you won’t have to do anything if you decide to make use of script-based web applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a new database and begin the app installation process manually or using our 1-click installation tool. The system will detect which engine the app in question requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the application can dump its data in that database. Therefore, you can run apps with various requirements in regard to the MySQL engine without the need to make any modifications on your VPS server.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the features which you can choose on the order form when you purchase a dedicated server from our company. As this is the most powerful type of hosting, it’s very likely that you will manage very popular websites that will draw a lot of visitors, and since InnoDB is among the best options for such websites, we will activate it along with all the other software apps that come with a Hepsia-managed server. If you set up a new MySQL database in your account, there won’t be any active MySQL database storage engine till you begin installing a PHP script, whether manually through your Internet browser or using the automatic scripts installation tool that is included in the Control Panel. The necessary engine will be automatically recognized and will be assigned to the database in question, so you can activate scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without coming across any problem.