InnoDB is a popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has many upsides that make it the preferred engine for many PHP-driven web apps, including Magento and Joomla, which have switched over to InnoDB for good. For example, importing huge data volumes will be faster with InnoDB, because it locks only one row to perform a specific operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. Simply put, importing new or modifying existing data will either be entirely completed, or will be annulled and the procedure will be rolled back if a given issue shows up in the meantime, hence the content that remains in the database won’t be lost.

InnoDB in Hosting

You can activate any open-source script-powered application that requires InnoDB if you have a Linux hosting package with us, as the MySQL database engine is present on our avant-garde cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can run apps which need the MyISAM engine without having to deal with any impediment as well and, once again, the engine will be selected automatically, so you won’t have to configure anything manually at any time. In addition, we will also perform daily backups of all the databases that you have in your shared hosting account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

InnoDB is included with each of our Linux semi-dedicated packages by default, so the moment you get a new semi-dedicated account, you can go on and install any script-powered software app that requires the MySQL storage engine. A number of engines are pre-installed on our cloud platform, so when you create a brand new database and begin installing an application manually, or opt to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected on the basis of the specific app’s prerequisites. This will permit you to install and manage InnoDB-specific apps without running into any obstacle and without changing any settings in your account. To be on the safe side, we’ll always have a 7-day-old backup of all your databases, so if you remove or change any content unintentionally, we can easily recover it.

InnoDB in VPS Hosting

When you purchase a virtual private server from us, you’ll be able to take advantage of our in-house built Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to manage any PHP-powered web application which requires InnoDB, as this particular MySQL database engine is included in the standard software bundle that will be pre-installed on your Virtual Private Server during its configuration. When you create a brand-new MySQL database through the hosting Control Panel, you will just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine given that the application in question requires it, so you will not have to do anything else in your account. Equivalently, if an application needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages that are ordered with our in-house developed Hepsia hosting Control Panel include a software package that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually if you need to use open-source scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to initiate the installation – once the script installation wizard accesses the database and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You’ll also be able to activate scripts that need MyISAM, the other very popular MySQL engine, so you won’t have to edit any settings on the server. This will enable you to use a variety of scripts on one single machine and to use the latter to its fullest capacity.

    • Our ID: 151274