InnoDB is a very popular storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a number of pluses that make it the engine of choice for plenty of script-based apps, including Magento and Joomla™, which have switched over to InnoDB for good. For example, adding huge data volumes will be faster with InnoDB, as it locks only one row to accomplish a particular 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 treated. To put it simply, appending new or modifying existing data will either be fully 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 lost.

InnoDB in Shared Hosting

Any script-based application that requires InnoDB will run impeccably on our leading-edge cloud hosting platform and the storage engine is offered with all our shared hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will use will be selected in accordance with the app’s specifications without the need to update any setting in your hosting account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We will store daily content backups, so in case you unintentionally erase a MySQL database that is important to you or you overwrite a specific part of it, we will be able to restore the database the way it was only a couple of hours earlier.

InnoDB in Dedicated Hosting

InnoDB comes by default with all Linux dedicated hosting ordered with the Hepsia Control Panel. It is an essential part of the default software bundle that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is set up, you will be able to log in and to activate a various PHP script-powered web app that requires this particular MySQL database engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app setup wizard begins inserting data into the database, the engine will be set automatically in accordance with the prerequisites of the specific app, so you can use both MyISAM and InnoDB without the need to select either of them specifically at any moment. Therefore, you can use a broad variety of applications for your sites.