InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster database failure recovery compared with the default engine used by MySQL – MyISAM. InnoDB is endorsed by many web developers that write scalable software apps, since it works more efficiently with large data volumes, while it keeps the server processing load at a minimum. What’s more, it locks only one database row if any information should be modified, whereas lots of other engines lock the entire database table and hence need much more time to accomplish several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla™ editions are two examples of famous PHP-based web applications which have switched over to InnoDB.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the Control Panel offered with each of our semi-dedicated server plans and you begin installing a script-driven application either manually or using our 1-click application installer, the storage engine for the MySQL database will be picked automatically depending on the particular app’s requirements. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any application that needs it without the need for any manual action on your end at any time. To avoid any chance of losing information if you update an application or if you remove a database by accident, we will carry out backups of all your databases each and every day, so if something happens, we can rescue your content.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to pick one of the three hosting Control Panels that we offer – cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this MySQL database storage engine manually so as to be able to manage PHP script-based software applications that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the resources that you require in order to run very large Internet sites, it is pretty possible that you will use InnoDB. You’ll be able to use other engines as well, so if a specific application requires MyISAM rather than InnoDB, you won’t come across any problem while running it. The engine that will be used will be automatically detected when the app installation starts, so you won’t have to change any setting manually whatsoever.