InnoDB is a very popular storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has lots of strong sides which make it the engine of choice for lots of PHP-powered applications, including Joomla™ and Magento, which have shifted over to InnoDB permanently. For example, importing large volumes of data will be faster with InnoDB, since it locks only a single database row to complete a given operation, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is handled. To put it simply, appending new or editing existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case some problem shows up during the process, hence the content that remains in the database will not be damaged.
InnoDB in Shared Web Hosting
InnoDB is offered with all our shared web hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any PHP script-driven software app which needs the database engine without any problems as soon as you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, no matter if you make use of our single-click installation tool or create the database and activate the application manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will perform daily backups of all your MySQL databases, so you can be sure that you won’t ever lose any content in case you delete a database unintentionally or you overwrite some key info – you will just need to inform us and we will restore the database the way it was.
InnoDB in Dedicated Servers
When you order a new dedicated server, you’ll be able to select one of the three hosting Control Panels that we offer – Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to add this storage engine manually to be able to use open-source script-based web applications that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the system resources that you require in order to manage large-size Internet sites, it is rather likely that you will use InnoDB. You will be able to make use of other engines too, so in case a specific application needs MyISAM instead of InnoDB, you will not run into any complication while using it. The engine that will be used will be automatically recognized once the app installation process begins, so you will not need to tweak any setting manually at any point.