See what a database engine is, what are the merits of the InnoDB engine and why it is gaining a lot of worldwide popularity.
InnoDB is a database storage engine for MySQL databases, which is used by popular PHP script-based web applications like Joomla™ 3.x and Magento. It is perfect for scalable apps, as it performs unbelievably well when handling huge amounts of data. Instead of locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same period of time. Besides, InnoDB offers a faster crash recovery and supports transactions and foreign keys – rules that specify how data inserts and modifications should be treated. In case a particular task hasn’t been thoroughly completed for whatever 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 mixed with newly added content.
InnoDB in Cloud Website Hosting
InnoDB is offered with all our cloud website hosting plans
by default, not upon request or as a paid upgrade, so you’ll be able to install and run any script-driven application that needs the MySQL database storage engine without encountering any difficulty as soon as you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation, irrespective of whether you use our one-click installer or create the MySQL database and install the app manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We’ll maintain daily backups of all your databases, so you can be sure that you won’t ever lose any content in case you delete a database by mistake or you overwrite some key information – you simply need to contact us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Servers
If you create a brand new MySQL database through the Control Panel coming with all our semi-dedicated server
accounts and you begin installing a PHP-driven web app either manually or using our single-click application installer tool, the database storage engine will be set automatically based on the given app’s prerequisites. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any time. To avoid any risk of losing data if you update an application or if you delete a database by mistake, we’ll generate a backup of all your MySQL databases each day, so if something happens, we can recover your content.
InnoDB in VPS Servers
All VPS plans
that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to run any script-based software application that needs the MySQL storage engine without having to set up anything manually. You can select Hepsia on the VPS configuration page and your new Virtual Private Server will be ready within 1 hour, so you can log in and begin building your websites straight away. Once you set up a brand-new database and begin the app activation process, our system will set the engine for this MySQL database automatically. In this way, you can run various apps simultaneously without having to edit anything on the server. You can set up a WordPress-driven blog that uses MyISAM – the default MySQL engine, and a Magento e-commerce site that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
If you purchase a new dedicated server
, you will be able to choose any of the three Control Panels that we are offering – Hepsia, cPanel and DirectAdmin. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to install this database engine manually to be able to manage script-based apps that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you need to run large-scale sites, it is rather possible that you will resort to InnoDB. You’ll be able to make use of other engines too, so in case a certain app needs MyISAM rather than InnoDB, you won’t run into any problem while running it. The engine that will be used will be detected automatically the moment the app installation procedure starts, so you won’t need to tweak any setting manually at any time.