InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it provides a significantly better overall performance and a faster crash recovery compared with the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by lots of programmers that create scalable software applications, since it works more efficiently with huge volumes of data, while it keeps the server load at a minimum. Also, it uses row-level locking if anything should be modified, while many other engines lock the entire table and therefore need much more time to handle several consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the latest versions of Joomla™ are two examples of famous PHP-driven software applications that have shifted over to InnoDB.
InnoDB in Semi-dedicated Servers
You can use a PHP-driven software app that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are created on our leading-edge cloud hosting platform where the database engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you use our one-click application installer tool. Either way, the needed engine will be selected automatically once the app’s activation starts, so you won’t have to update anything manually, no matter if the application requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you accidentally delete one, as we generate a few database backups every day, each of which is preserved for 1 week.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s an essential part of the default software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your machine is assembled, you’ll be able to log in and to install a various PHP script-powered web app that requires this storage engine. When you create a new database via the Control Panel, there won’t be any active engine till you start installing an app. Once the app activation wizard starts dumping content in the newly created database, the engine will be set automatically on the basis of the particular app’s prerequisites, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any point. Therefore, you can make use of an extensive selection of applications for your Internet sites.