InnoDB is a database storage engine for MySQL databases, which is used by widely used script-based web applications like Magento and Joomla™ 3. It is excellent for scalable applications, because it excels in processing large volumes of data. Instead of 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. Moreover, InnoDB offers a better crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and modifications should be treated. In case a certain operation hasn’t been fully completed for any reason, the action will be rolled back. In this way, the database content will be retained intact and won’t be partially merged with newly appended content.

InnoDB in Shared Hosting

You’ll be able to install any script-driven web app that requires InnoDB if you have a shared hosting with our company, as the MySQL storage engine is present on our advanced cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is required. You can run applications that require the MyISAM engine without encountering any problem as well and, once again, the engine will be selected automatically, so you will not have to modify anything manually at any time. What’s more, we will also create regular backups of all the MySQL databases that you’ve got in the shared hosting account, so in case you delete or overwrite anything, we can quickly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

You can install a script-powered application that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our advanced cloud web hosting platform where the MySQL database engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you make use of our one-click application installer tool. Either way, the needed engine will be chosen automatically once the app’s installation starts, so you won’t need to edit anything manually, no matter if the app requires InnoDB or the more regularly used MyISAM. Also, we’ll always be able to retrieve any of your databases in case you erase one by accident, as we carry out several database backups every day, each of which is stored for one week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to take advantage of any PHP script-driven web app that requires this database engine without the need to set up anything manually. You can choose Hepsia on the VPS order page and your brand-new server will be set up within one hour, so you can log in and start building your sites straight away. Once you create a new MySQL database and start the app activation process, our system will set the engine for this MySQL database automatically. In this way, you can run various applications simultaneously without the need to edit anything on the VPS server. You can create a WordPress-driven online journal that makes use of MyISAM – the default MySQL engine, and a Magento-driven online store that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

When you order a new dedicated server, you’ll be able to choose any of the three Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to install this database engine manually to be able to run PHP script-based applications that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you require in order to manage large-size sites, it is quite likely that you will resort to InnoDB. You will be able to use other engines too, so if a certain app needs MyISAM rather than InnoDB, you will not run into any problem while using it. The engine that will be used will be automatically detected when the app installation commences, so you won’t need to fine-tune any setting manually whatsoever.