InnoDB is a popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has many upsides that make it the engine of choice for lots of open-source script-driven applications, including Joomla™ and Magento, which have switched over to InnoDB permanently. For instance, adding large amounts of data will be faster with InnoDB, as it locks only one row to complete a particular task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is treated. Simply put, appending new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case any issue occurs during the process, which means that the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

Every open-source script-driven application that requires InnoDB will function flawlessly on our leading-edge cloud platform and the MySQL database engine is available with all our shared hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will use will be selected on the basis of the app’s requirements without the need to update any setting in your account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to get the most out of its full potential. We will generate daily backups of your content, so in case you unintentionally delete a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore your database the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Hosting

InnoDB is included with each of our semi-dedicated hosting by default, so once you obtain a new semi-dedicated account, you can go on and activate any open-source script-driven application that requires the storage engine. A few engines are pre-installed on our cloud platform, so when you create a brand-new MySQL database and start installing an app manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be chosen in accordance with the prerequisites of the respective app. This will permit you to activate and run InnoDB-specific applications without having any impediment and without editing any settings in your account. To avoid any risk, we will always have a 7-day-old backup of all your databases, so if you erase or alter any content accidentally, we can swiftly recover it.

InnoDB in VPS Web Hosting

When you obtain a virtual private server from us, you’ll be able to make use of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will allow you to install any PHP script-based application that requires InnoDB, as the database storage engine is an essential part of the standard software bundle that will be pre-installed on your server during its creation. When you set up a brand new MySQL database using the hosting Control Panel, you just need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the app in question needs it, so you will not have to do anything else in your VPS account. Correspondingly, if a given app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is one of the options that you can select on the server configuration page when you buy a dedicated server from our company. As this is the most powerful kind of hosting, it is rather likely that you’ll manage highly popular Internet sites that will attract lots of people, and since InnoDB is among the best choices for such sites, we’ll activate it together with all the other software apps that are offered with a Hepsia-equipped dedicated server. If you create a new database in your dedicated server account, there won’t be any activated storage engine till you start installing a PHP script, whether manually via your web browser or using the automatic scripts installer tool that is included in the hosting Control Panel. The necessary engine will be recognized and will be set for that database, so you can activate scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without the need to cope with any problem.