InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has numerous pluses that have made it the preferred engine for many PHP-driven applications, including Magento and Joomla, which have shifted over to InnoDB permanently. For example, adding large volumes of data will be faster with InnoDB, due to the fact that it locks only a single row to execute a certain task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Put simply, appending new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case a given issue shows up during the process, which means that the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it is included in the default set of services that we’re offering with our shared website hosting packages. If you want to use a PHP script-powered software app that requires InnoDB specifically, in order to be activated and to work properly, you won’t have any problems since the InnoDB database engine is available on our in-house built cloud website hosting platform. Regardless of whether you set up a new MySQL database and activate an app manually or use our one-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given application requires InnoDB instead of MyISAM. Besides the amazing database failure recovery that InnoDB is offering, we also maintain daily backups of all databases, so we can swiftly recover any database in your shared hosting account.

InnoDB in VPS Hosting

In case our custom Hepsia Control Panel is selected during the registration process for a new Linux VPS hosting packages , InnoDB will be installed on the server along with other essential pieces of software, so you won’t need to do anything if you choose to run PHP script-powered software applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a new database and start installing the app manually or through our single-click installer tool. The system will detect the engine that the app in question requires and will set it for the specific MySQL database, so the installation process will continue impeccably and the app can insert its content into that database. Thus, you can manage apps with various prerequisites regarding the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Web Hosting

InnoDB comes as standard with all Linux dedicated servers hosting packages ordered with the Hepsia Control Panel. It’s included in the software bundle that we install on all Hepsia-managed servers, so once your machine is assembled, you’ll be able to sign in and to activate any type of PHP script-based web app that requires this particular MySQL database engine. When you set up a new database through the hosting Control Panel, there won’t be any activated engine till you start installing an app. Once the app installation wizard begins importing information into the newly created database, the engine will be picked automatically based on the prerequisites of the respective application, so you can run both MyISAM and InnoDB without the need to select either one explicitly at any time. Therefore, you can make use of a vast selection of apps for your sites.