InnoDB is a storage engine for MySQL relational databases, which is used by widespread PHP script-based software applications such as Magento and Joomla 3.x. It’s ideal for scalable apps, as it works amazingly well when handling huge volumes of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can perform much more tasks for the same period of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign keys – a set of rules that specify how data inserts and modifications should be handled. If a specific operation hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will remain undamaged and will not be partially mixed with newly added content.
InnoDB in Shared Web Hosting
You’ll be able to activate any PHP script-based application that requires InnoDB if you’ve got a Linux shared web hosting with our company, as the MySQL database storage engine is present on our avant-garde cloud website hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can run apps which need the MyISAM engine without encountering any impediment as well and, again, the engine will be selected automatically, so you will not need to update any setting manually at any point. What’s more, we’ll also perform daily backups of all the databases that you’ve got in the account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Hosting
You can run a script-driven software application that requires InnoDB with any of our semi-dedicated server plans, as all the accounts are set up on our cutting-edge cloud platform where the database engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our single-click application installer. Either way, the needed engine will be selected automatically the moment the installation of the app begins, so you won’t need to configure anything manually, no matter if the app needs InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to recover any of your databases in case you accidentally delete one, as we make a few backups every day, each of which is saved for 7 days.
InnoDB in VPS Web Hosting
If you select a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be part of the default software pack that will be pre-installed on your server before we give it to you. You won’t need to activate anything manually and you will be able to install and manage any PHP-based application that needs InnoDB as soon as your Virtual Private Server is up and running, which takes no more than 1 hour after the order procedure itself. A few engines are available, so every time you set up a MySQL database using the Hepsia Control Panel, a particular engine will be picked once the app installation begins and our system will detect the engine that is required by the app in question. In case you need MyISAM, for instance, you won’t have to do anything different than installing the application of your preference, whether manually or using our app installer.
InnoDB in Dedicated Servers Hosting
Our Hepsia Control Panel is one of the options that you can pick on the order page when you purchase a dedicated server from our company. Since this is the most powerful type of website hosting, it’s pretty likely that you’ll run very popular websites that will attract a lot of individuals, and since InnoDB is among the best choices for such sites, we will activate it along with all the other software apps that come with a Hepsia-equipped dedicated server. When you create a brand new MySQL database in your dedicated account, there won’t be any active storage engine until you start installing an open-source script, whether manually via your browser or using the automatic scripts installation tool that is available in the hosting Control Panel. The required engine will be detected automatically and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without any obstacles.