InnoDB is a database storage engine for MySQL relational databases, which is used by popular PHP-powered software apps such as Magento and Joomla 3.x. It’s ideal for scalable apps, because it works unbelievably well when handling immense amounts of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can execute a lot more operations for the same length of time. Also, InnoDB offers a much better database crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and updates should be treated. In case a certain operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be retained intact and won’t be partially merged with newly added content.
InnoDB in Shared Hosting
InnoDB is available with all our shared hosting by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP-powered software app that needs the MySQL database storage engine without encountering any obstacle once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation, no matter if you use our one-click installer or create the database and install the app manually, on the condition that the app requires it instead of the more famous MyISAM engine. We will generate daily database backups, so you can rest assured that you won’t ever lose any data if you erase a database by mistake or you overwrite some essential information – you’ll just need to touch base with us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Servers
You can make use of a script-powered software app that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our advanced cloud platform where the storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our single-click application installer tool. Either way, the needed engine will be chosen automatically once the application’s activation starts, so you will not need to update anything manually, no matter if the app needs InnoDB or the more frequently used MyISAM. Also, we’ll always be able to retrieve any of your MySQL databases in case you remove one by mistake, as we perform several backups every day, each of which is preserved for 1 whole week.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s an essential part of the software bundle that we install on all Hepsia-managed servers, so once your machine is up and running, you will be able to log in and to activate a various script-based app that needs this particular database storage engine. When you create a new MySQL database through the Control Panel, there won’t be any activated engine until you begin installing an app. Once the app installation wizard starts entering information into the newly created database, the engine will be set automatically in accordance with the requirements of the particular app, so you can use both MyISAM and InnoDB without the need to select either of them specifically at any moment. Thus, you can make use of an extensive variety of apps for your Internet sites.