InnoDB is a very popular storage engine for the MySQL database management system. 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 a lot of PHP-based software applications, such as Magento and Joomla™, which have shifted over to InnoDB for good. For example, importing large volumes of data will be faster with InnoDB, since it locks only a single row to execute a given task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is handled. In simpler words, adding new or modifying existing data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case a certain issue shows up in the meantime, so the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

You will be able to make use of any open-source script-powered app that requires InnoDB if you have a Linux shared hosting with our company, as the MySQL storage engine is present on our avant-garde cloud hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can install apps that use the MyISAM engine without encountering any difficulty as well and, again, the engine will be selected automatically, so you won’t have to change any setting manually at any time. In addition, we’ll also create regular backups of all the databases that you have in the shared web hosting account, so if you erase or overwrite something, we can swiftly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

If you create a new MySQL database from the Control Panel provided with each of our semi-dedicated server accounts and you begin installing a PHP script-powered web application either manually or using our one-click application installer, the storage engine for the database will be picked automatically on the basis of the requirements of the given app. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any app that needs it without any manual action required on your end at any time. To prevent any risk of losing info if you update an application or if you remove a database by accident, we will generate a backup of all your MySQL databases every day, so if something goes wrong, we can restore your data.

InnoDB in VPS

If our custom-built Hepsia Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be installed on the server along with other necessary pieces of software, so you will not need to do anything if you decide to install script-powered web applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed as well. You can create a brand new MySQL database and start installing the application manually or using our one-click installation tool. The system will detect the engine that the app in question needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can enter its content into that database. Thus, you can install applications with different prerequisites in regard to the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our in-house developed Hepsia Control Panel come with a software package that is pre-activated and among everything else, you will get the InnoDB database storage engine, so you will not need to install it manually if you want to run PHP scripts that require it. All it takes to install such a script is to set up a new MySQL database and to begin the setup process – once the installation wizard gains access to the database in question and begins entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to use scripts that need the other widely used MySQL engine, MyISAM, so you will not need to configure any settings on the dedicated server. This will allow you to run various scripts on one single physical machine and to use the latter to its maximum capacity.