InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a better overall performance and a faster crash recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is preferred by lots of web developers that build highly scalable apps, as it works better with large amounts of data, while it keeps the server load at a minimum. Moreover, it uses row-level locking in case any info should be updated, while many other engines lock the entire table and hence need much more time to process several sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the newest Joomla releases are two instances of widespread PHP-based web apps that have shifted over to InnoDB.

InnoDB in Shared Website Hosting

Any open-source script-based software app that requires InnoDB will run impeccably on our innovative cloud hosting platform and the MySQL database engine is available with all our shared website hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected based on the app’s requirements without having to change any setting in your shared hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to make the most of its full potential. We’ll perform daily content backups, so if you accidentally delete a MySQL database that you need or you overwrite some part of it, we will be able to restore your database the way it was only several hours earlier.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database through the hosting Control Panel included with all our semi-dedicated server packages and you begin installing an open-source script-powered software application either manually or using our one-click app installer tool, the storage engine for the MySQL database will be selected automatically based on the particular app’s requirements. As InnoDB is available 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 point. To prevent any risk of losing information if you update an app or if you erase a database accidentally, we’ll make a backup of all your MySQL databases each and every day, so if anything happens, we can recover your data.

InnoDB in VPS

All VPS services that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to take advantage of any script-driven web app that requires this MySQL storage engine without needing to install anything manually. You can select Hepsia on the VPS order page and your new server will be up and running within sixty minutes, so you can sign in and begin setting up your websites right away. When you set up a brand new database and start the app installation process, our system will choose the engine for this MySQL database automatically. Thus, you can run different apps simultaneously without the need to update anything on the VPS server. You can set up a WordPress personal journal that makes use of the default MySQL engine – MyISAM, and a Magento e-store that uses InnoDB, for example.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is among the options that you can choose on the order form when you buy a dedicated server from us. As this is the most powerful type of hosting, it is rather likely that you’ll manage popular sites that will draw plenty of people, and since InnoDB is among the very best options for such Internet sites, we’ll activate it along with all the other software apps that come with a Hepsia-managed server. If you set up a brand new MySQL database in your dedicated account, there won’t be any activated database storage engine until you start installing a PHP script, whether manually via your Internet browser or using the automatic scripts installer that is integrated into the Control Panel. The necessary engine will be detected automatically and will be set for the database in question, so you can use scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without running into any predicament.