Discover what a database engine is, what are the merits of the InnoDB engine and why it's gaining a lot of global popularity.
InnoDB is a storage engine for MySQL databases, which is used by well known open-source script-based applications such as Joomla™ 3.x and Magento. It’s perfect for scalable applications, since it performs unbelievably well when managing huge data volumes. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. Also, InnoDB offers a much better database crash recovery and supports database transactions and foreign keys – rules that indicate how data inserts and modifications should be handled. In case a given operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will remain safe and sound and won’t be partially merged with newly inserted content.
InnoDB in Semi-dedicated Servers
You can activate a PHP script-based web app that requires InnoDB with all of our semi-dedicated server
plans, since all the accounts are created on our avant-garde cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our 1-click application installer. In either case, the required engine will be picked automatically as soon as the application’s activation starts, so you won’t have to configure anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to retrieve any of your databases if you erase one by accident, as we carry out several database backups every day, each of which is kept for 1 whole week.