Find out about InnoDB and see why it’s already been chosen as the default MySQL database engine.
InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a better overall performance and an improved crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by numerous devs that build scalable web apps, since it works more effectively with huge amounts of data, while it keeps the server load low. Additionally, it locks only one database row in case any information should be modified, whereas many other engines lock the entire table and thus require more time to handle several sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to prevent confusion or data loss. Magento and the latest editions of Joomla™ are two examples of famous PHP script-powered software applications which have shifted over to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other web hosting companies, it’s an essential part of the default set of services that we are offering with our shared hosting
plans. In case you’d like to use an open-source script-driven web app that needs InnoDB specifically, in order to be activated and to operate properly, you will not have to deal with any impediments since the storage engine is available on our in-house developed cloud platform. No matter if you create a new database and activate an app manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires InnoDB instead of MyISAM. In addition to the remarkable crash recovery offered by InnoDB, we also make regular database backups, so that we can easily recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting packages
support InnoDB and you can take full advantage of all the features offered by this MySQL database storage engine with any open-source script-based software app that needs it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be picked depends on the requirements of the specific application. You won’t have to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To be on the safe side, we will maintain daily backups of all your databases, so if anything goes wrong after an update or if you delete some data by accident, we’ll be able to restore your database the way it was on any of the previous seven days.
InnoDB in VPS Web Hosting
If you order a virtual private server
with our Hepsia hosting Control Panel, the InnoDB storage engine will be an essential part of the standard software pack that will be pre-installed on your VPS server before we give it to you. You will not have to activate anything manually and you will be able to enable and use any script-powered software application that requires InnoDB when your Virtual Private Server is up and running, which takes no more than 1 hour after the order procedure itself. A few engines are offered, so whenever you set up a MySQL database via the Hepsia Control Panel, a particular engine will be selected once the app activation begins and our system will detect which engine is required by the app in question. If you need MyISAM, for example, you will not need to do anything different from installing the desired app, whether manually or using our app installer tool.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting packages
that are ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually in case you need to run scripts that require it. All it takes to run such a script is to create a new MySQL database and to begin the installation – once the script configuration wizard acquires access to the database and begins inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to activate scripts that need MyISAM, the other popular MySQL engine, so you won’t have to configure any settings on the dedicated server. This will allow you to run various scripts on one single machine and to use the latter to its maximum potential.