InnoDB is a database storage engine for MySQL databases, which is used by widely used script-driven software applications such as Joomla™ 3 and Magento. It is perfect for scalable apps, since it performs really well when handling huge data volumes. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same period of time. What’s more, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – rules that indicate how data imports and modifications should be handled. If a given operation hasn’t been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will be kept safe and sound and will not be partially merged with new content.
InnoDB in Cloud Website Hosting
While InnoDB is either not available or a paid upgrade with many web hosting companies, it is part of the standard set of features that we offer with our cloud website hosting
plans. In case you want to use a PHP script-driven web application that requires InnoDB in particular, in order to be activated and to work correctly, you will not encounter any impediments since the InnoDB database engine is available on our custom cloud web hosting platform. No matter if you create a brand new database and activate an application manually or take advantage of our single-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular app needs InnoDB instead of MyISAM. In addition to the excellent database crash recovery that InnoDB is offering, we also carry out regular backups of all databases, so we can swiftly restore any database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
You can install a PHP script-driven software application that requires InnoDB with any of our semi-dedicated server
packages, due to the fact that all the accounts are created on our advanced cloud hosting platform where the MySQL 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 – if you make use of our one-click application installer. In either case, the needed engine will be chosen automatically as soon as the activation of the app begins, so you will not need to update anything manually, no matter if the app requires InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your databases in case you delete one by accident, as we carry out a few database backups every day, each of which is kept for 1 week.
InnoDB in Dedicated Web Hosting
Our Hepsia Control Panel is one of the features that you can pick on the server configuration page when you purchase a dedicated server
from us. As this is the most powerful type of hosting, it is rather likely that you will run popular websites that will draw plenty of individuals, and since InnoDB is one of the best choices for such Internet sites, we will enable it along with all the other software applications that are offered with a Hepsia-managed server. If you set up a brand-new database in your account, there won’t be any activated storage engine until you begin installing an open-source script, whether manually via your browser or using the automatic script installation tool that is available in the Control Panel. The required engine will be recognized and will be set for that database, so you can activate scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without any problem.