InnoDB is a popular database storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has numerous strengths that make it the preferred engine for lots of PHP script-driven applications, such as Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, adding enormous amounts of data will be faster with InnoDB, due to the fact that it locks only a single database row to perform an operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the information is treated. To put it simply, adding new or updating existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case some issue shows up in the meantime, so the content that remains in the database won’t be lost.
InnoDB in Shared Web Hosting
InnoDB is offered with all our shared web hosting
by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any open-source script-driven web app that needs the MySQL database storage engine without the need to deal with any complication as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app activation process, regardless of whether you take advantage of our one-click installer or create the database and install the application manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We’ll store daily backups of all your MySQL databases, so you can rest assured that you won’t ever lose any content if you delete a database by mistake or you overwrite some crucial info – you will simply have to get in touch with us and we’ll restore your database back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is available with all our Linux semi-dedicated hosting
by default, so once you order a new semi-dedicated account, you can go ahead and install any PHP-based web app that needs the storage engine. A couple of engines are pre-installed on our cloud website hosting platform, so when you set up a brand-new MySQL database and begin installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be picked based on the requirements of the respective app. This will permit you to install and run InnoDB-specific applications without any obstacles and without having to update any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a 1-week-old backup of all your MySQL databases, so if you remove or edit any content by accident, we can easily retrieve it.
InnoDB in VPS Hosting
If you select a virtual private server
with our Hepsia hosting Control Panel, the InnoDB database engine will be an indivisible part of the software bundle that will be pre-installed on your server before we hand it over to you. You won’t need to activate anything manually and you will be able to enable and use any PHP script-powered web app that needs InnoDB as soon as your Virtual Private Server is up and running, which takes no more than 1 hour after the order submission process itself. A number of engines are available, so anytime you create a MySQL database using the Hepsia hosting Control Panel, a specific engine will be picked once the app activation process begins and our system will detect which engine is required by the app in question. If you have to use MyISAM, for instance, you will not have to do anything different than installing the desired app, whether manually or using our application installer tool.
InnoDB in Dedicated Web Hosting
When you obtain a new dedicated server
, you will be able to pick one of the 3 Control Panels offered by us – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to enable this MySQL database engine manually to be able to manage script-driven apps that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you need to run large-size sites, it is very likely that you’ll resort to InnoDB. You’ll be able to use other engines as well, so if a certain application requires MyISAM rather than InnoDB, you won’t have to deal with any complication while managing it. The engine that will be used will be recognized automatically the moment the app installation procedure begins, so you will not have to alter any settings manually at any time.