InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and an improved database crash recovery in comparison to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by plenty of web developers that write highly scalable web apps, because it works much better with enormous volumes of data, while it keeps the server load low. What’s more, it locks only one database row in case anything should be updated, while lots of other engines lock the entire database table and thus require more time to accomplish multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest Joomla releases are two examples of widespread PHP-powered applications that have switched over to InnoDB.
InnoDB in Hosting
Any PHP-powered application that needs InnoDB will function impeccably on our avant-garde cloud web hosting platform and the MySQL database engine is available with all our hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected on the basis of the app’s requirements without having to update any setting in your shared hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to make the most of its full capacity. We will carry out regular content backups, so in case you accidentally remove a database that you need or you overwrite specific parts of it, we’ll be able to restore the database the way it was only several hours earlier.
InnoDB in Semi-dedicated Hosting
If you create a brand-new MySQL database from the hosting Control Panel provided with each of our semi-dedicated server packages and you begin installing a script-based software application either manually or using our 1-click app installer, the MySQL database storage engine will be set automatically depending on the requirements of the particular app. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for each app that needs it without any manual action needed on your end at any time. To prevent any chance of losing data if you update an application or if you erase a database unintentionally, we will carry out a backup of all your databases every day, so if anything happens, we can restore your data.
InnoDB in VPS
If our custom Hepsia Control Panel is selected during the registration process for a new Linux virtual private servers , InnoDB will be activated on the server together with other essential software, so you won’t have to do anything if you decide to manage open-source script-powered software applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand new database and start installing the application manually or through our one-click installation tool. The system will recognize the engine that the particular app requires and will assign it to the specific MySQL database, so the installation will proceed impeccably and the application can insert its data into that database. Thus, you can activate apps with different requirements concerning the MySQL engine without making any changes on your VPS.
InnoDB in Dedicated Hosting
When you obtain a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to activate this MySQL storage engine manually so as to be able to run open-source script-based web applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you need to manage large-size Internet sites, it’s rather likely that you’ll use InnoDB. You’ll be able to use other engines as well, so in case a given application needs MyISAM instead of InnoDB, you will not come across any problem while managing it. The engine that will be used will be recognized automatically as soon as the app installation process commences, so you won’t have to fine-tune any settings manually whatsoever.