InnoDB is a database storage engine for MySQL databases, which is used by popular PHP-based applications like Magento and Joomla 3. It’s ideal for scalable applications, since it works really well when managing enormous volumes of data. Rather than locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can perform much more operations for the same period of time. In addition, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be handled. In case a certain task hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the database content will be kept undamaged and won’t be partially merged with newly inserted content.

InnoDB in Web Hosting

You’ll be able to make use of any script-based web app that requires InnoDB if you have a Linux web hosting package with our company, as the database storage engine is available on our leading-edge cloud website hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is needed. You can install apps which use the MyISAM engine without encountering any impediment as well and, again, the engine will be pre-selected, so you will not need to configure any setting manually at any moment. Furthermore, we’ll also perform regular backups of all the MySQL databases that you have in your shared hosting account, so in case you delete or overwrite anything, we can easily get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

You can install an open-source script-based web app that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are created on our innovative cloud web hosting 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 web hosting Control Panel, or automatically – in case you use our single-click app installer tool. Either way, the required engine will be chosen automatically once the application’s installation starts, so you won’t need to edit anything manually, irrespective of whether the app needs InnoDB or the more widely used MyISAM. On top of that, we will always be able to retrieve any of your databases if you accidentally erase one, as we perform a few backups every day, each of which is preserved for 1 week.

InnoDB in VPS Hosting

All Linux VPS hosting packages that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to make use of any PHP-based web app that needs the MySQL storage engine without installing anything manually. You can pick Hepsia on the VPS order form and your brand new server will be up and running within 60 minutes, so you can log in and begin building your websites straight away. When you set up a brand new MySQL database and begin the app installation process, our system will choose the engine for this MySQL database automatically. In this way, you can run various applications at the same time without the need to edit anything on the Virtual Private Server. You can have a WordPress-based personal weblog that makes use of the default MySQL engine – MyISAM, and a Magento e-store that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Web Hosting

If you obtain a new dedicated server, you’ll be able to choose any of the three hosting Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to activate this database engine manually to be able to use PHP script-based web applications that need it. InnoDB is used for scalable applications and since a dedicated server will give you all the server resources that you need to manage large-size sites, it is very likely that you’ll use InnoDB. You’ll be able to make use of other engines too, so in case a particular app requires MyISAM instead of InnoDB, you won’t experience any difficulty while using it. The engine that will be used will be automatically recognized the moment the app installation commences, so you won’t need to change any setting manually at any time.