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 got a lot of strengths that have made it the preferred engine for a lot of PHP script-powered web applications, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, adding huge amounts of data will be much faster with InnoDB, due to the fact that it locks only one database row to perform a specific task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is handled. Simply put, adding new or updating existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back in case a given issue appears during the process, so the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

You will be able to install any PHP script-powered web application that requires InnoDB if you’ve got a cloud hosting service with our company, as the MySQL database engine is available on our leading-edge cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can install apps which use the MyISAM engine without encountering any difficulty as well and, again, the engine will be selected automatically, so you will not have to change any setting manually at any moment. Furthermore, we will also make daily backups of all the databases that you have in the shared web hosting account, so if you erase or overwrite something, we can easily restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our Linux semi-dedicated service by default, so the moment you order a new account, you can go on and install any open-source script-based software application that needs the MySQL storage engine. Several engines are pre-installed on our cloud web hosting platform, so when you set up a new database and start installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be selected on the basis of the requirements of the specific app. This will permit you to activate and run InnoDB-specific apps without encountering any problem and without having to edit any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 1-week-old backup of all your MySQL databases, so if you remove or change any content by mistake, we can swiftly restore it.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an indivisible part of the software pack that will be installed on your server before we give it to you. You won’t need to set up anything manually and you will be able to enable and run any open-source script-powered web app that needs InnoDB when your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission process itself. A number of engines are available, so whenever you set up a MySQL database using the Hepsia Control Panel, a specific engine will be activated when the app installation commences and our system will automatically detect the engine that is required by the application in question. If you need to use MyISAM, for example, you won’t need to do anything different from installing the app of your preference, whether manually or using our application installer.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options that you can pick on the server order page when you buy a dedicated server from us. Since this is the most powerful type of web hosting, it’s rather likely that you’ll run popular websites that will draw a lot of visitors, and since InnoDB is one of the very best options for such sites, we will install it along with all the other software applications that come with a Hepsia-equipped server. If you set up a brand new database in your account, there won’t be any activated MySQL database storage engine until you start installing an open-source PHP script, whether manually via your web browser or using the automatic script installation tool that is available in the hosting Control Panel. The necessary engine will be automatically detected and will be set for that database, so you can make use of scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without having any obstacle.