InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP-driven web apps like Joomla 3 and Magento. It’s perfect for scalable applications, because it works incredibly well when handling huge data volumes. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same period of time. Moreover, InnoDB offers a better crash recovery and supports database transactions and foreign key constraints – rules that indicate how data inserts and updates should be handled. If a specific operation hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will be kept undamaged and will not be partially mixed with newly imported content.
InnoDB in Hosting
You will be able to make use of any script-driven application that needs InnoDB if you have a Linux hosting with our company, as the storage engine is available on our advanced cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can install applications which require the MyISAM engine without the need to deal with any complication as well and, again, the engine will be pre-selected, so you won’t have to edit any setting manually at any time. Furthermore, we’ll also make regular backups of all the databases that you have in your shared web hosting account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
You can make use of a script-driven web app that needs InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our leading-edge cloud hosting platform where the storage engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our 1-click application installer. Either way, the required engine will be selected automatically as soon as the application’s installation begins, so you will not have to update anything manually, regardless of whether the application requires InnoDB or the more commonly used MyISAM. Also, we will always be able to recover any of your databases if you remove one by accident, as we carry out a couple of database backups every day, each of which is preserved for one whole week.
InnoDB in VPS
If our in-house built Hepsia Control Panel is chosen during the signup process for your new Linux VPS packages , InnoDB will be activated on the Virtual Private Server together with other required pieces of software, so you will not need to do anything if you decide to use PHP script-based software applications that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new MySQL database and begin installing the app manually or through our one-click installer tool. The system will recognize the engine that the particular application requires and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the application can dump its data in that database. In this way, you can run applications with different requirements with regard to the MySQL engine without the need to make any changes on your VPS server.
InnoDB in Dedicated Hosting
Our Hepsia Control Panel is one of the features which you can pick on the order form when you buy a dedicated server from our company. Since this is the most powerful type of hosting, it’s rather likely that you’ll manage popular sites that will draw plenty of individuals, and since InnoDB is among 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 dedicated server. When you set up a brand new MySQL database in your dedicated account, there won’t be any activated MySQL storage engine till you start installing a PHP script, whether manually via your Internet browser or using the automatic script installation tool that is available in the hosting Control Panel. The needed engine will be automatically detected and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without any problems.