InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has numerous pluses that have made it the engine of choice for many script-powered applications, such as Magento and Joomla, which have switched over to InnoDB for good. For instance, importing immense amounts of data will be faster with InnoDB, because it locks only a single database row to execute a task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is handled. Simply put, adding new or updating existent data will either be fully completed, or will be canceled and the operation will be rolled back if any problem appears in the meantime, hence the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP-driven application that requires the InnoDB database storage engine without having to deal with any impediment once you order your account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation process, irrespective of whether you take advantage of our one-click installation tool or create the database and install the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will carry out daily database backups, so you can be sure that you’ll never lose any content in case you erase a database by mistake or you overwrite some essential info – you’ll just need to contact us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the Control Panel provided with all our semi-dedicated server plans and you start installing a PHP script-based software app either manually or using our single-click application installer, the storage engine for the database will be set automatically depending on the specific app’s requirements. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any app that requires it without any manual intervention required on your end at any moment. To prevent any risk of losing data if you update an app or if you delete a database by accident, we’ll perform backups of all your MySQL databases every day, so if something happens, we can restore your content.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be included in the default software package that will be pre-installed on your server before we hand it over to you. You won’t need to configure anything manually and you will be able to enable and run any PHP-powered web application that requires InnoDB as soon as your VPS server is set up, which takes no more than sixty minutes after the order procedure itself. Several engines are offered, so every time you create a MySQL database via the Hepsia Control Panel, a particular engine will be picked when the app installation starts and our system will detect which engine is required by the app in question. If you need MyISAM, for example, you won’t have to do anything different from installing the application of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features which you can select on the server order page when you buy a dedicated server from us. As this is the most powerful type of website hosting, it’s rather likely that you will manage popular sites that will draw many individuals, and since InnoDB is one of the best choices for such Internet sites, we will install it along with all the other software applications that are offered with a Hepsia-managed server. If you create a new database in your account, there won’t be any active database storage engine until you begin installing an open-source script, whether manually through your web browser or using the automatic scripts installer that is included in the hosting Control Panel. The needed engine will be detected automatically and will be set for that database, so you can run scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without having any impediment.