InnoDB
What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a much better overall performance and an improved database failure recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by numerous programmers that create highly scalable applications, as it works much more efficiently with huge data volumes, while it keeps the server load low. Also, it locks only a single row in the database in case any information should be edited, whereas many other engines lock the entire table and therefore need more time to carry out several sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid scrambling or the loss of data. Magento and the latest Joomla™ versions are two instances of famous PHP-driven web apps that have switched over to InnoDB.
-
InnoDB in Cloud Hosting
While InnoDB is either a paid upgrade or it is not available at all with other hosting providers, it is an integral part of the standard set of services that we are offering with our
cloud hosting packages. If you wish to make use of an open-source script-driven software application that needs InnoDB particularly, in order to be installed and to perform properly, you will not have any problems because the InnoDB storage engine is available on our in-house built cloud Internet hosting platform. No matter if you set up a new database and install an app manually or take advantage of our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular app requires it instead of MyISAM. In addition to the amazing crash recovery that InnoDB offers, we also carry out regular database backups, so that we can swiftly restore any MySQL database in your shared account.
-
InnoDB in Semi-dedicated Hosting
If you create a brand-new MySQL database through the hosting Control Panel included with each of our
semi-dedicated server packages and you start installing an open-source script-driven application either manually or using our 1-click app installer tool, the MySQL database storage engine will be selected automatically depending on the requirements of the app in question. Since InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for each app that requires it without any manual intervention needed on your end at any moment. To prevent any chance of losing data if you update an app or if you remove a database by accident, we will make backups of all your databases each day, so if something goes wrong, we can restore your data.
-
InnoDB in Dedicated Web Hosting
Our Hepsia hosting Control Panel is one of the features which you can select on the server order page when you purchase a
dedicated server from our company. As this is the most powerful type of hosting, it is very likely that you will manage very popular websites that will draw lots of people, and since InnoDB is among the very best options for such websites, we’ll enable it along with all the other software apps that come with a Hepsia-equipped server. When you create a new MySQL database in your dedicated server account, there won’t be any active MySQL database engine till you begin installing a script, whether manually via your web browser or using the automatic script installation tool that is included in the hosting Control Panel. The necessary engine will be detected and will be assigned to the database in question, so you can activate scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having to deal with any problem.