InnoDB is a popular database engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got plenty of pluses which have made it the engine of choice for many script-based web applications, among them Joomla and Magento, which have moved to InnoDB permanently. For instance, importing immense volumes of data will be faster with InnoDB, due to the fact that it locks only one database row to accomplish a specific task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is tackled. Put simply, adding new or updating existent data will either be entirely completed, or will be aborted and the procedure will be rolled back in case some issue shows up during the process, which is why the content that remains in the database will not be damaged.

InnoDB in Shared Web Hosting

You can make use of any script-driven application that needs InnoDB if you’ve got a shared web hosting with our company, as the storage engine is present on our cutting-edge cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate applications that use the MyISAM engine without having to deal with any impediment as well and, again, the engine will be selected automatically, so you will not have to configure any setting manually at any time. Furthermore, we will also carry out regular backups of all the MySQL databases that you have in the shared hosting account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Hosting

You can make use of a PHP script-powered software application that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our leading-edge cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our one-click application installer tool. In either case, the required engine will be chosen automatically as soon as the installation of the app starts, so you will not have to change anything manually, no matter if the app needs InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to recover any of your databases in case you accidentally delete one, as we generate a few MySQL database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Hosting

When you order a virtual private server from our company, you will be able to make use of our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to install any PHP-driven web application that requires InnoDB, as this MySQL storage engine is part of the default software package that will be installed on your Virtual Private Server during its creation. When you set up a new database through the hosting Control Panel, you will just have to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine in case the application in question needs it, so you won’t need to do anything else in your account. In the same manner, if an application requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting ordered with our in-house built Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you won’t have to activate it manually if you’d like to use PHP scripts that require it. All it takes to install such a script is to set up a new database and to begin the installation process – once the script setup wizard acquires access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You will also be able to run scripts that need MyISAM – the other very popular MySQL engine, so you won’t have to change any settings on the server. This will enable you to install different scripts on a single server and to use the latter to its fullest potential.