What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a significantly better overall performance and a faster crash recovery compared to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is endorsed by many programmers that write highly scalable apps, because it works much better with immense data volumes, while it keeps the server load low. Additionally, it locks only a single row in the database in case anything should be updated, whereas many other engines lock the entire database table and hence need much more time to execute multiple successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or losing data. Magento and the latest releases of Joomla™ are two instances of famous PHP script-driven web apps which have moved to InnoDB.
InnoDB in Shared Hosting
Any PHP script-based software app that requires InnoDB will function flawlessly on our avant-garde cloud platform and the database storage engine is available with all our shared hosting
packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database will use will be selected on the basis of the app’s specifications without the need to configure any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll maintain regular content backups, so if you unintentionally delete a MySQL database that is important to you or you overwrite certain parts of it, we’ll be able to restore everything the way it was just a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
InnoDB is included with all our Linux semi-dedicated hosting packages
by default, so once you purchase a new account, you can go on and install any PHP script-powered web application that requires this MySQL database storage engine. Several engines are installed on our cloud hosting platform, so when you set up a brand-new database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set in accordance with the requirements of the respective app. This will allow you to activate and manage InnoDB-specific applications without needing to deal with any complication and without the need to change any settings in your semi-dedicated account. To avoid any risk, we will always keep a 7-day-old backup of all your MySQL databases, so if you remove or alter any content by accident, we can swiftly rescue it.
InnoDB in VPS Web Hosting
If you pick a virtual private server
with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the standard software package that will be installed on your Virtual Private Server before we give it to you. You won’t need to configure anything manually and you will be able to install and manage any open-source script-powered software application that requires InnoDB as soon as your VPS server is ready, which takes no more than 60 minutes after the order procedure itself. Several engines are available, so whenever you set up a database through the Hepsia hosting Control Panel, a particular engine will be activated once the app installation process begins and our system will detect the engine that is required by the app in question. If you need MyISAM, for instance, you will not have to do anything different from installing the desired app, whether manually or using our app installer tool.
InnoDB in Dedicated Servers Hosting
When you acquire a new dedicated server
, you will be able to select one of the three hosting Control Panels offered by us – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to activate this storage engine manually to be able to use open-source script-driven web apps that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the system resources that you need in order to manage very large websites, it is rather possible that you’ll use InnoDB. You will be able to make use of other engines too, so in case a given application needs MyISAM instead of InnoDB, you will not experience any problem while using it. The engine that will be used will be automatically detected the moment the app installation procedure starts, so you will not have to fine-tune any settings manually at any point.