InnoDB is a popular database engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has lots of strengths which have made it the engine of choice for lots of open-source script-based web applications, including Magento and Joomla, which have shifted over to InnoDB permanently. For example, adding immense volumes of data will be much faster with InnoDB, because it locks only one row to execute a particular operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Put simply, importing new or modifying existent data will either be entirely completed, or will be aborted and the operation will be rolled back if a given issue occurs in the meantime, thus the content that remains in the database will not be lost.
InnoDB in Shared Hosting
You will be able to run any open-source script-based application that needs InnoDB in case you’ve got a shared package with our company, as the MySQL database engine is available on our advanced cloud platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is required. You can install applications that require the MyISAM engine without the need to deal with any complication as well and, again, the engine will be selected automatically, so you won’t need to modify any setting manually at any time. In addition, we’ll also create regular backups of all the MySQL databases that you have in the account, so in case you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting include InnoDB and you can take advantage of all the features of this MySQL database storage engine with any PHP-driven app that needs it. InnoDB is among the engines that are available on our cloud hosting platform, so the one that will be used depends on the prerequisites of the given app. You won’t have to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our single-click application installer tool. To be on the safe side, we will keep regular database backups, so if anything goes wrong following some update or if you erase some data accidentally, we’ll be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS Web Hosting
If you obtain a virtual private server from our company, you will be able to use our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will permit you to run any script-powered app that requires InnoDB, as this particular MySQL database storage engine is included in the software bundle that will be installed on the server during its configuration. When you create a new MySQL database through the Control Panel, you just have to start installing an application – manually or using our app installer. InnoDB will be set as the default engine in case the application in question needs it, so you will not have to do anything else in your account. Equivalently, if a certain app needs MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers Hosting
InnoDB comes as standard with all dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It’s included in the standard software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your machine is assembled, you’ll be able to sign in and to install a various open-source script-powered software app that needs this MySQL storage engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app installation wizard begins entering information into the newly created database, the engine will be set automatically depending on the requirements of the given app, so you can run both MyISAM and InnoDB without selecting either one explicitly at any point. In this way, you can use a large range of applications for your sites.