InnoDB is a database engine for MySQL databases, which is used by famous PHP script-based applications like Joomla v3 and Magento. It is ideal for scalable apps, since it performs exceptionally well when managing huge data volumes. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can handle a lot more operations for the same length of time. Also, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – rules that prescribe how data inserts and modifications should be treated. If a certain task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially mixed with newly added content.
InnoDB in Shared Hosting
InnoDB is available with all our shared hosting packages by default, not upon request or as a paid upgrade, so you will be able to install and run any PHP-powered web app which requires the InnoDB storage engine without encountering any obstacle once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app installation, no matter if you take advantage of our 1-click installation tool or create the MySQL database and install the app manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We’ll keep regular backups of all your databases, so you can rest assured that you won’t ever lose any data in case you delete a database by mistake or you overwrite some crucial info – you’ll simply have to get in touch with us and we’ll restore the database back to normal.
InnoDB in Semi-dedicated Hosting
You can activate a script-powered software app that needs InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our cutting-edge cloud platform where the MySQL storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our 1-click app installer. In either case, the required engine will be chosen automatically the moment the installation of the application begins, so you won’t have to update anything manually, regardless of whether the application needs InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases if you remove one by accident, as we perform a couple of database backups every day, each of which is kept for one whole week.
InnoDB in VPS Web Hosting
When you obtain a virtual private server from our company, you’ll be able to use our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to use any PHP-powered web application which requires InnoDB, as this particular MySQL storage engine is part of the standard software package that will be pre-installed on the VPS server during its creation. When you create a brand new database through the hosting Control Panel, you just need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine as long as the app in question needs it, so you will not have to do anything else in your account. In the same manner, if a certain app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers Hosting
When you buy a new dedicated server, you will be able to select any of the three hosting Control Panels offered by our company – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to add this database engine manually so as to be able to run open-source script-powered software applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you need in order to manage very large sites, it’s very likely that you’ll resort to InnoDB. You will be able to use other engines too, so if a particular application requires MyISAM rather than InnoDB, you will not have to deal with any problem while running it. The engine that will be used will be detected automatically the moment the app installation begins, so you won’t need to fine-tune any settings manually at any time.