InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and a faster database failure recovery compared with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is used by numerous web developers that write highly scalable applications, as it works much more efficiently with large volumes of data, while it keeps the server load at a minimum. What’s more, it it locks only one row in the database in case anything should be edited, whereas many other engines lock the entire database table and hence need much more time to perform multiple successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for some reason, the operation is rolled back to avoid scrambling or losing data. Magento and the latest Joomla releases are two examples of widely used script-powered apps which have switched to InnoDB.
InnoDB in Shared Hosting
Any PHP script-powered web application that needs InnoDB will function flawlessly on our cutting-edge cloud web hosting platform and the MySQL database storage engine is offered with all our shared hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will use will be selected on the basis of the app’s specifications without the need to edit any setting in your account. InnoDB will be picked automatically for any application that requires this particular engine and you’ll be able to take advantage of its full capacity. We will create daily backups of your content, so in case you accidentally delete a database that you need or you overwrite certain parts of it, we’ll be able to restore your database the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
If you create a new MySQL database from the Control Panel offered with each of our semi-dedicated server accounts and you start installing a PHP script-powered app either manually or using our one-click application installer, the storage engine for the MySQL database will be selected automatically based on the requirements of the app in question. As InnoDB is available on the cloud platform where your new account will be set up, it will be set as the default engine for any application that requires it without any manual intervention required 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 generate a backup of all your MySQL databases each and every day, so if anything goes wrong, we can restore your content.
InnoDB in VPS Web Hosting
In case our custom Hepsia Control Panel is selected during the registration process for your new Linux virtual private servers , InnoDB will be installed on the server along with other required software, so you will not have to do anything if you decide to make use of open-source script-based software apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand new database and begin the app installation process manually or using our one-click installation tool. The system will recognize which engine the application in question requires and will assign it to the specific database, so the installation will continue flawlessly and the app can dump its content in that database. In this way, you can install applications with different requirements about the MySQL engine without having to make any changes on your VPS server.
InnoDB in Dedicated Servers Hosting
Our Hepsia hosting Control Panel is among the options that you can choose on the server order page when you buy a dedicated server from our company. Since this is the most powerful kind of web hosting, it is quite likely that you will run highly popular websites that will draw plenty of individuals, and since InnoDB is one of the best options for such sites, we will activate it together with all the other software apps that are offered with a Hepsia-equipped server. When you create a brand new database in your dedicated server account, there won’t be any active MySQL database engine till you start installing an open-source PHP script, whether manually via your Internet browser or using the automatic scripts installation tool that is available in the hosting Control Panel. The required 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 the default MySQL engine – MyISAM, without having to cope with any impediment.