InnoDB is a popular storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has lots of upsides that make it the engine of choice for a lot of PHP-powered web apps, among them Joomla and Magento, which have moved to InnoDB for good. For instance, importing immense data volumes will be faster with InnoDB, since it locks only one row to accomplish an operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is handled. Put simply, adding new or modifying existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if any problem shows up in the meantime, thus the content that remains in the database won’t be lost.

InnoDB in Hosting

You will be able to install any PHP script-powered web application that needs InnoDB in case you have a hosting plan with our company, as the database storage engine is available on our innovative cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is needed. You can activate applications which need the MyISAM engine without having to deal with any obstacle as well and, once again, the engine will be selected automatically, so you won’t need to configure any setting manually at any moment. On top of that, we will also perform daily backups of all the databases that you have in your shared web 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

If you set up a brand new MySQL database from the hosting Control Panel included with each of our semi-dedicated server accounts and you begin installing an open-source script-powered web application either manually or using our 1-click app installer tool, the MySQL database storage engine will be selected automatically depending on the prerequisites of the particular app. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that requires it without any manual intervention required on your end at any moment. To prevent any risk of losing data if you update an application or if you remove a database by accident, we will perform backups of all your MySQL databases each day, so if anything happens, we can retrieve your data.

InnoDB in VPS Servers

All Linux VPS plans that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to make use of any PHP-based application that needs this database storage engine without the need to activate anything manually. You can pick Hepsia on the VPS order form and your brand-new server will be set up within 1 hour, so you can log in and begin setting up your sites straight away. Once you set up a new MySQL database and begin the app installation process, our system will set the engine for this MySQL database automatically. Thus, you can install various apps simultaneously without the need to modify anything on the VPS server. You can have a WordPress personal weblog that makes use of the default MySQL engine – MyISAM, and a Magento-powered online store that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

InnoDB is available as standard with all Linux dedicated web hosting plans ordered with the Hepsia Control Panel. It is part of the default software bundle that will be pre-installed on all Hepsia-managed servers, so once your machine is assembled, you’ll be able to log in and to install any PHP-based software application that requires this particular MySQL storage engine. If you set up a new MySQL database through the Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app configuration wizard begins importing content into the database, the engine will be picked automatically on the basis of the prerequisites of the app in question, so you can run both MyISAM and InnoDB without the need to select either one explicitly at any moment. Therefore, you can make use of a huge range of applications for your websites.