InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-based software apps such as Joomla 3.x and Magento. It is perfect for scalable apps, because it works really well when processing huge data volumes. Instead of locking the whole table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same length of time. Furthermore, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that define how data imports and updates should be handled. In case a given task has not been fully completed for any reason, the action will be rolled back. Thus, the database content will stay intact and will not be partially merged with newly inserted content.

InnoDB in Web Hosting

You can use any open-source script-driven application that needs InnoDB in case you’ve got a web hosting with our company, as the database engine is available on our innovative cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can install apps which require the MyISAM engine without the need to deal with any complication as well and, once again, the engine will be selected automatically, so you will not need to configure anything manually at any point. Furthermore, we’ll also make daily backups of all the databases that you have in the shared web hosting account, so if you delete or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

You can activate a PHP-powered web app that requires InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are created on our leading-edge cloud hosting platform where the database storage engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our one-click application installer. Either way, the required engine will be chosen automatically as soon as the activation of the application starts, so you will not need to edit anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. On top of that, we will always be able to retrieve any of your databases if you remove one by accident, as we create several backups every day, each of which is stored for one week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to make use of any script-based app that needs this MySQL storage engine without the need to install anything manually. You can select Hepsia on the VPS order form and your brand-new VPS server will be ready within the hour, so you can log in and start building your Internet sites right away. Once you set up a brand new database and start the app installation process, our system will select the engine for this database automatically. In this way, you can activate various apps simultaneously without having to modify anything on the VPS server. You can create a WordPress-driven online journal that uses the default MySQL engine – MyISAM, and a Magento-powered web store that uses InnoDB, for example.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options that you can choose on the server order page when you buy a dedicated server from our company. Since this is the most powerful kind of hosting, it is pretty likely that you’ll manage highly popular Internet sites that will draw many people, and since InnoDB is one of the very best choices for such Internet sites, we will activate it together with all the other software apps that are offered with a Hepsia-equipped server. When you create a new MySQL database in your account, there won’t be any activated MySQL database storage engine till you start installing a PHP script, whether manually via your web browser or using the automatic script installer that is included in the Control Panel. The needed engine will be detected and will be assigned to that database, so you can make use of scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without any complications.