InnoDB is a storage engine for MySQL relational databases, which is used by widespread script-powered web apps such as Magento and Joomla™ v3. It’s ideal for scalable applications, since it performs incredibly well when handling enormous amounts of data. Rather than locking the whole 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 operations for the same period of time. Plus, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – rules that indicate how data imports and modifications should be treated. If a given task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved intact and will not be partially merged with newly entered content.
InnoDB in Shared Hosting
InnoDB is offered with all our Linux shared plans by default, not upon request or as a paid upgrade, so you can install and run any PHP-driven web app that requires the MySQL database storage engine without the need to deal with any difficulty once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, regardless of whether you use our single-click installation tool or create the database and install the app manually, as long as the application requires it instead of the more popular MyISAM engine. We will create daily backups of all your databases, so you can rest assured that you will never lose any content in case you delete a database by accident or you overwrite some important info – you’ll simply have to inform us and we’ll restore your data back to normal.
InnoDB in Semi-dedicated Servers
InnoDB comes with each of our semi-dedicated plans by default, so the moment you create a new semi-dedicated account, you can move on and activate any PHP-based software app that needs this database storage engine. Several engines are pre-installed on our cloud web hosting platform, so when you set up a new MySQL database and start installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be picked on the basis of the given app’s prerequisites. This will allow you to activate and run InnoDB-specific apps without running into any impediment and without having to configure any settings in your semi-dedicated account. To avoid any risk, we’ll always have a seven-day-old backup of all your MySQL databases, so if you remove or change any content by accident, we can quickly restore it.
InnoDB in VPS Servers
In case our custom-built Hepsia Control Panel is picked during the signup process for a new VPS hosting plans , InnoDB will be installed on the VPS server together with other needed software, so you won’t need to do anything if you decide to manage script-powered apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a new database and start the app installation manually or using our one-click installation tool. The system will detect the engine that the application in question needs and will set it for the specific database, so the installation process will continue impeccably and the app can insert its content into that database. In this way, you can use applications with different prerequisites concerning the MySQL engine without the need to make any modifications on your server.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the options which you can pick on the server order page when you purchase a dedicated server from us. As this is the most powerful type of hosting, it is very likely that you’ll manage popular sites that will draw plenty of individuals, and since InnoDB is one of the very best choices for such Internet sites, we’ll install it along with all the other software apps that are available with a Hepsia-managed server. When you create a brand new database in your dedicated server account, there won’t be any active database engine until you start installing a PHP script, whether manually through your web browser or using the automatic script installation tool that is available in the hosting Control Panel. The needed engine will be detected automatically and will be set for the database in question, so you can run scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without experiencing any impediment.