InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a better overall performance and a faster crash recovery compared with the default engine used by the MySQL database management system – MyISAM. InnoDB is preferred by plenty of web developers that run highly scalable web applications, due to the fact that it works much better with large data volumes, while it keeps the server processing load at a minimum. Furthermore, it locks only a single row in the database if any info should be updated, whereas many other engines lock the entire database table and hence require more time to accomplish multiple sequential tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for whatever reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest editions of Joomla are two instances of widespread script-powered apps which have moved to InnoDB.
InnoDB in Shared Hosting
Any open-source script-based web application that needs InnoDB will run flawlessly on our cutting-edge cloud web hosting platform and the database storage engine comes with all our shared hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected on the basis of the app’s prerequisites without the need to modify any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to make the most of its full potential. We will make regular backups of your content, so in case you unintentionally erase a database that you need or you overwrite certain parts of it, we’ll be able to restore the database the way it was only a few hours earlier.
InnoDB in Semi-dedicated Hosting
You can make use of a PHP script-driven web app that requires InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are created on our leading-edge cloud platform where the database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click application installer tool. Either way, the needed engine will be selected automatically as soon as the activation of the app starts, so you won’t need to modify anything manually, no matter if the app needs InnoDB or the more commonly used MyISAM. Also, we will always be able to recover any of your MySQL databases if you delete one by mistake, as we make a few MySQL database backups every day, each of which is stored for one week.
InnoDB in VPS Web Hosting
All Linux VPS web hosting packages that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any script-based software application that requires this particular storage engine without the need to set up anything manually. You can choose Hepsia on the VPS configuration page and your new Virtual Private Server will be up and running within the hour, so you can log in and begin creating your websites right away. Once you set up a new MySQL database and start the app activation process, our system will pick the engine for this MySQL database automatically. In this way, you can run different applications at the same time without changing anything on the Virtual Private Server. You can set up a WordPress personal journal that uses the default MySQL engine – MyISAM, and a Magento e-commerce website that uses the InnoDB engine, for instance.
InnoDB in Dedicated Servers Hosting
Our Hepsia Control Panel is among the options which you can choose on the order form when you purchase a dedicated server from us. Since this is the most powerful kind of web hosting, it’s quite likely that you’ll manage very popular Internet sites that will attract lots of visitors, and since InnoDB is one of the best choices for such sites, we will enable it together with all the other software applications that are available with a Hepsia-managed dedicated server. If you create a brand-new MySQL database in your account, there won’t be any active storage engine until you begin installing an open-source script, whether manually through your browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The needed engine will be recognized automatically and will be assigned to that database, so you can use scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without the need to deal with any difficulty.