InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is used by many devs that write scalable software apps, due to the fact that it works much more efficiently with huge amounts of data, while it keeps the server load low. Also, it it locks only one row in the database in case anything should be edited, while many other engines lock the entire database table and hence require more time to accomplish several successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to prevent scrambling or losing data. Magento and the latest Joomla editions are two instances of widely used script-powered apps that have shifted over to InnoDB.

InnoDB in Hosting

You can run any PHP script-powered app that requires InnoDB in case you have a hosting plan with us, as the storage engine is available on our innovative cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can install apps that use the MyISAM engine without any difficulty as well and, again, the engine will be pre-selected, so you won’t have to configure any setting manually at any time. What’s more, we will also carry out daily backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

You can run an open-source script-powered application that requires InnoDB with any of our semi-dedicated server packages, because all the accounts are created on our advanced cloud platform where the database engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our single-click app installer tool. Either way, the required engine will be chosen automatically the moment the installation of the application starts, so you will not have to configure anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to retrieve any of your databases if you accidentally erase one, as we make a few MySQL database backups every day, each of which is kept for 1 whole week.

InnoDB in VPS Servers

All VPS web hosting plans that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to take advantage of any PHP script-based application that requires this database engine without having to configure anything manually. You can pick Hepsia on the VPS configuration page and your new Virtual Private Server will be ready within 60 minutes, so you can log in and start setting up your Internet sites right away. When you create a brand-new database and begin the app activation process, our system will select the engine for that MySQL database automatically. In this way, you can manage different applications simultaneously without the need to change anything on the VPS server. You can have a WordPress-driven weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven e-shop that uses the InnoDB engine, for example.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options that you can pick on the server order page when you purchase a dedicated server from us. Since this is the most powerful kind of hosting, it’s pretty likely that you’ll manage popular Internet sites that will attract a lot of people, and since InnoDB is one of the best choices for such sites, we’ll activate it together with all the other software applications that are offered with a Hepsia-equipped dedicated server. When you set up a new database in your account, there won’t be any activated MySQL storage engine till you start installing a script, whether manually through your web browser or using the automatic scripts installation tool that is included in the Control Panel. The required engine will be automatically detected and will be set for the database in question, so you can run scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without having any impediment.