InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, because it provides a better overall performance and an improved crash recovery compared with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is used by lots of developers that run scalable software apps, since it works better with huge amounts of data, while it keeps the server processing load low. Additionally, it uses row-level locking if anything should be modified, while many other engines lock the entire table and hence require much more time to carry out multiple consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification cannot be completed for any reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the latest editions of Joomla are two examples of widespread PHP script-based web applications which have switched over to InnoDB.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any open-source script-powered app that requires the MySQL database engine without any impediments once you order your account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, no matter if you use our 1-click installation tool or create the database and install the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We’ll create regular MySQL database backups, so you can be sure that you’ll never lose any data in case you erase a database by accident or you overwrite some important info – you will simply have to notify us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel included with each of our semi-dedicated server accounts and you start installing a PHP script-driven web application either manually or using our one-click application installer, the storage engine for the MySQL database will be picked automatically depending on the prerequisites of the given app. Since InnoDB is available on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for any app that requires it without any manual action needed on your end at any time. To avoid any chance of losing information if you update an application or if you erase a database by accident, we will make backups of all your databases every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS Servers

In case our custom Hepsia hosting Control Panel is chosen during the signup process for your new VPS servers , InnoDB will be installed on the VPS server together with other needed software, so you will not need to do anything if you decide to run PHP-based software apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a new database and begin the app installation process manually or through our one-click installer. The system will automatically recognize the engine that the app in question requires and will set it for the specific database, so the installation process will proceed impeccably and the application can dump its data in that database. Therefore, you can manage apps with various requirements regarding the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options which you can pick on the order page when you purchase a dedicated server from us. As this is the most powerful type of web hosting, it’s rather likely that you will run popular Internet sites that will attract plenty of visitors, and since InnoDB is among the very best options for such websites, we’ll enable it along with all the other software apps that are available with a Hepsia-managed dedicated server. When you create a brand-new database in your dedicated account, there won’t be any active database storage engine till you begin installing a PHP script, whether manually via your web browser or using the automatic scripts installer tool that is integrated into the hosting Control Panel. The necessary engine will be automatically recognized and will be set for that database, so you can use scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without having to cope with any difficulty.