InnoDB is a storage engine for MySQL databases, which is used by famous script-driven apps such as Magento and Joomla™ 3.x. It’s excellent for scalable apps, since it works incredibly well when processing large data volumes. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same length of time. What’s more, InnoDB offers an improved database failure recovery and supports transactions and foreign keys – rules that indicate how data inserts and updates should be handled. If a certain task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be preserved intact and will not be partially mixed with newly added content.
InnoDB in Web Hosting
You will be able to install any PHP-powered web application that needs InnoDB in case you have a web hosting
with our company, as the storage engine is present on our innovative cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is needed. You can activate apps which require the MyISAM engine without any difficulty as well and, once again, the engine will be pre-selected, so you will not need to modify any setting manually at any moment. Furthermore, we will also create regular backups of all the MySQL databases that you’ve got in the shared hosting account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
support InnoDB and you will be able to use all the options offered by this storage engine with any PHP-based software app that requires it. InnoDB is among the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the prerequisites of the application in question. You won’t need to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To avoid any risk, we will perform regular database backups, so if anything goes wrong after an upgrade or if you delete some content by mistake, we’ll be able to restore your database the way it was on any of the past 7 days.
InnoDB in VPS Servers
If you get a VPS server
with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the software package that will be installed on your server before we hand it over to you. You won’t need to activate anything manually and you will be able to enable and manage any PHP script-powered web app that needs InnoDB as soon as your VPS is ready, which takes no more than sixty minutes after the order submission process itself. A few engines are offered, so anytime you create a MySQL database using the Hepsia Control Panel, a particular engine will be picked once the app installation commences and our system will automatically detect the engine that is required by the app in question. In case you need MyISAM, for example, you will not have to do anything different than installing the application of your preference, whether manually or using our app installer.
InnoDB in Dedicated Servers
When you get a new dedicated server
, you’ll be able to pick any of the three Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to activate this storage engine manually to be able to run script-based software applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you require in order to manage very large websites, it’s pretty possible that you will resort to InnoDB. You will be able to use other engines too, so in case a certain application needs MyISAM rather than InnoDB, you won’t need to deal with any impediment while using it. The engine that will be used will be detected automatically once the app installation begins, so you won’t have to edit any settings manually at any point.