InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got plenty of advantages which have made it the preferred engine for lots of script-driven software apps, such as Magento and Joomla™, which have shifted over to InnoDB permanently. For example, adding large data volumes will be much faster with InnoDB, due to the fact that it locks only one database row to accomplish a particular operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is tackled. Put simply, appending new or updating existing data will either be entirely completed, or will be annulled and the operation will be rolled back if a certain problem shows up in the meantime, which means that the content that remains in the database won’t be damaged.

InnoDB in Website Hosting

You will be able to run any PHP-driven web app that requires InnoDB if you’ve got a website hosting with us, as the storage engine is available on our leading-edge cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is required. You can run applications that require the MyISAM engine without encountering any impediment as well and, once again, the engine will be selected automatically, so you will not have to configure any setting manually at any point. Furthermore, we’ll also perform daily backups of all the databases that you’ve got in the account, so in case you delete or overwrite anything, we can swiftly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you’ll be able to use all the features of this MySQL database engine with any script-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 requirements of the specific app. You won’t have to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we will perform daily backups of all your databases, so if anything goes wrong after some update or if you delete some content by accident, we will be able to get your database back to the way it was on any of the past seven days.

InnoDB in Dedicated Servers

If you get a new dedicated server, you’ll be able to select one of the 3 hosting Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to install this MySQL storage engine manually so as to be able to use open-source script-powered applications that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you require to run large-size Internet sites, it’s rather possible that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so if a specific app requires MyISAM instead of InnoDB, you won’t experience any difficulty while running it. The engine that will be used will be automatically recognized when the app installation procedure begins, so you won’t need to tweak any settings manually at any time.