InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and an improved database crash recovery in comparison to the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by plenty of web developers that write scalable web apps, since it works more effectively with enormous data volumes, while it keeps the server processing load at a minimum. Also, it locks only a single database row if anything should be edited, while lots of other engines lock the entire database table and therefore require more time to accomplish several consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest editions of Joomla are two instances of widespread PHP script-based software applications which have shifted over to InnoDB.
InnoDB in Web Hosting
Every PHP script-powered web app that requires InnoDB will run flawlessly on our avant-garde cloud platform and the storage engine is available with all our web 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 in accordance with the app’s specifications without the need to change any setting in your shared web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to get the most out of its full potential. We’ll store daily backups of your content, so if you accidentally remove a database that’s important to you or you overwrite a certain part of it, we will be able to restore everything the way it was only several hours ago.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our Linux semi-dedicated hosting plans by default, so as soon as you obtain a new semi-dedicated account, you can go on and install any PHP-based web app that needs the MySQL database engine. A number of engines are pre-installed on our cloud web hosting platform, so when you set up a new database and start installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be picked in accordance with the concrete app’s requirements. This will allow you to activate and manage InnoDB-specific apps without running into any impediment and without configuring any settings in your semi-dedicated account. To be on the safe side, we’ll always have a 1-week-old backup of all your MySQL databases, so if you delete or alter any content by mistake, we can easily recover it.
InnoDB in VPS Servers
If you get a VPS server from us, you will be able to take full advantage of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-managed VPS will allow you to run any PHP script-based application that needs InnoDB, as this MySQL database engine is part of the default software package that will be pre-installed on the server during its setup. When you create a brand-new MySQL database through the Control Panel, you simply need to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you won’t need to do anything else in your account. Identically, if a given application needs MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
InnoDB comes as standard with all Linux dedicated servers ordered with the Hepsia Control Panel. It’s an integral part of the standard software package that we install on all Hepsia-managed servers, so as soon as your machine is ready, you will be able to log in and to activate a various PHP-driven application that requires this particular storage engine. If you create a new database via the Control Panel, there won’t be any active engine until you begin installing an app. As soon as the app setup wizard starts entering data into the database, the engine will be chosen automatically on the basis of the particular app’s requirements, so you can run both MyISAM and InnoDB without selecting either one explicitly at any point. Therefore, you can make use of a vast variety of apps for your sites.