InnoDB is a popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has got plenty of pluses which make it the engine of choice for plenty of script-powered web apps, including Magento and Joomla, which have shifted over to InnoDB permanently. For example, importing large volumes of data will be faster with InnoDB, since it locks only a single database row to execute a particular operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is handled. Simply put, appending new or updating existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back if a certain problem shows up in the meantime, so the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosts, it’s part of the default set of services offered with our cloud hosting packages. If you’d like to make use of a PHP script-based web app that needs InnoDB particularly, in order to be activated and to function properly, you won’t have any difficulties as the InnoDB storage engine is available on our custom cloud platform. Irrespective of whether you set up a new database and activate an application manually or use our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the particular application requires InnoDB instead of MyISAM. In addition to the exceptional crash recovery that InnoDB is offering, we also maintain daily database backups, so we can easily recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our Linux semi-dedicated packages by default, so the moment you order a new account, you can go on and activate any PHP script-powered web app that needs this particular MySQL database storage engine. A couple of engines are pre-installed on our cloud hosting platform, so when you create a brand new database and start installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer, the engine for the database will be picked depending on the respective app’s requirements. This will permit you to activate and manage InnoDB-specific apps without experiencing any obstacle and without modifying any settings in your semi-dedicated account. To take no chances, we’ll always keep a 1-week-old backup of all your databases, so if you delete or change any content unintentionally, we can easily retrieve it.

InnoDB in VPS

In case our custom Hepsia hosting Control Panel is picked during the signup process for your new Linux VPS packages , InnoDB will be installed on the VPS server together with other required software, so you will not have to do anything if you choose to use PHP-driven software apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can set up a new MySQL database and start the app installation procedure manually or using our single-click installer tool. The system will automatically detect which engine the app in question requires and will assign it to the specific database, so the installation will continue impeccably and the application can dump its data in that database. Thus, you can install applications with different prerequisites about the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Hosting

If you get a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels offered by our company – Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to enable this database storage engine manually to be able to use PHP-powered web apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the server resources that you require to run large-scale sites, it’s very possible that you’ll use InnoDB. You’ll be able to make use of other engines as well, so if a specific application requires MyISAM rather than InnoDB, you won’t run into any impediment while using it. The engine that will be used will be automatically recognized when the app installation process starts, so you won’t need to edit any setting manually at any moment.