InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-powered applications like Magento and Joomla 3. It is excellent for scalable apps, because it works astonishingly well when managing immense amounts of data. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same length of time. Additionally, InnoDB offers an improved crash recovery and supports transactions and foreign keys – a set of rules that indicate how data inserts and modifications should be handled. In case a specific operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will remain undamaged and will not be partially merged with newly inserted content.

InnoDB in Shared Hosting

Every PHP script-based software application that needs InnoDB will function flawlessly on our cutting-edge cloud web hosting platform and the storage engine is available with all our shared hosting packages. Every time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will use will be selected based on the app’s prerequisites without having to change any setting in your hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to get the most out of its full potential. We will create regular content backups, so if you unintentionally delete a MySQL database that you need or you overwrite a certain part of it, we will be able to restore your database the way it was just several hours earlier.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated packages include InnoDB and you can use all the options offered by this MySQL storage engine with any PHP-driven application that requires it. It is one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the given app. You will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our single-click app installer. To avoid any risk, we will create daily database backups, so if anything goes wrong after an update or if you erase some data by mistake, we’ll be able to restore the database the way it was on any of the previous 7 days.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is one of the options that you can pick on the server order page when you buy a dedicated server from our company. Since this is the most powerful kind of website hosting, it’s very likely that you will manage popular Internet sites that will draw lots of visitors, and since InnoDB is among the very best options for such sites, we will activate it along with all the other software applications that come with a Hepsia-equipped server. When you set up a brand new database in your dedicated server account, there won’t be any active database storage engine until you begin installing an open-source PHP script, whether manually through your web browser or using the automatic script installation tool that is available in the Control Panel. The required engine will be automatically recognized and will be assigned to that database, so you can make use of scripts that require InnoDB, as well as ones that require the default MySQL engine, MyISAM, without experiencing any impediment.