InnoDB is a very popular database storage engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has plenty of pluses that have made it the preferred engine for many PHP-driven web apps, such as Joomla and Magento, which have switched to InnoDB permanently. For example, adding immense amounts of data will be faster with InnoDB, due to the fact that it locks only a single row to accomplish a given task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is handled. In simpler words, appending new or editing existent data will either be entirely completed, or will be annulled and the procedure will be rolled back in case some issue occurs in the meantime, which means that the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

You can install any PHP-based software application that requires InnoDB if you’ve got a Linux shared hosting with our company, as the MySQL storage engine is available on our advanced cloud hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can run applications which need the MyISAM engine without having any difficulty as well and, once again, the engine will be pre-selected, so you won’t need to change any setting manually at any point. Furthermore, we’ll also perform daily backups of all the MySQL databases that you have in the shared web hosting account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

You can activate an open-source script-driven web application that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are created on our cutting-edge cloud platform where the database storage engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you make use of our single-click app installer. In either case, the required engine will be picked automatically once the application’s installation starts, so you won’t need to update anything manually, no matter if the application needs InnoDB or the more frequently used MyISAM. Also, we will always be able to restore any of your MySQL databases in case you erase one by mistake, as we make a couple of database backups every day, each of which is kept for 1 week.

InnoDB in Dedicated Hosting

InnoDB comes as standard with all Linux dedicated hosting that are ordered with the Hepsia hosting Control Panel. It’s included in the default software package that will be pre-installed on all Hepsia-managed dedicated servers, so once your physical machine is ready, you’ll be able to log in and to activate any script-powered software application that requires this particular storage engine. If you set up a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an app. As soon as the app installation wizard starts dumping data in the newly created database, the engine will be set automatically on the basis of the prerequisites of the particular application, so you can use both MyISAM and InnoDB without the need to select either one of them explicitly at any point. In this way, you can use a huge selection of applications for your Internet sites.