InnoDB is a popular database engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got many pluses which make it the preferred engine for lots of PHP-based web applications, including Magento and Joomla, which have switched over to InnoDB for good. For instance, adding enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only a single row to complete a given task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. Put simply, importing new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back if some issue shows up in the meantime, therefore the content that remains in the database won’t be damaged.
InnoDB in Web Hosting
You can make use of any open-source script-powered app that needs InnoDB in case you’ve got a web hosting with us, as the MySQL database engine is present on our avant-garde cloud website hosting platform by default. During the app activation – 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 run apps which need the MyISAM engine without having to deal with any obstacle as well and, once again, the engine will be selected automatically, so you won’t have to modify anything manually at any moment. On top of that, we will also create daily backups of all the databases that you have in your shared account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Servers
InnoDB is available with all our semi-dedicated servers by default, so once you create a new semi-dedicated account, you can go ahead and install any open-source script-powered application that requires this MySQL database engine. A number of engines are installed on our cloud web hosting platform, so when you set up a new MySQL database and start installing an app manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be set based on the requirements of the respective app. This will permit you to activate and run InnoDB-specific apps without having to cope with any difficulty and without needing to update any settings in your account. To be on the safe side, we will always have a 1-week-old backup of all your databases, so if you remove or alter any content accidentally, we can easily restore it.
InnoDB in VPS Servers
If you buy a VPS server from our company, you will be able to use our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will permit you to run any PHP script-driven software app that requires InnoDB, as the MySQL storage engine is included in the software bundle that will be pre-installed on the VPS server during its configuration. When you set up a new MySQL database using the hosting Control Panel, you just need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine on the condition that the application in question requires it, so you will not need to do anything else in your account. In the same manner, if a given app needs MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Servers
InnoDB is available by default with all dedicated servers ordered with the Hepsia Control Panel. It is included in the software bundle that will be pre-installed on all Hepsia-managed servers, so once your physical machine is up and running, you’ll be able to log in and to activate any kind of PHP script-driven application that requires this storage engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you begin installing an app. Once the app activation wizard begins importing content into the newly created database, the engine will be chosen automatically based on the prerequisites of the given application, so you can use both MyISAM and InnoDB without selecting either of them specifically at any time. In this way, you can use a huge range of applications for your sites.