InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP-based web applications such as Magento and Joomla™ v3. It is perfect for scalable apps, because it works stunningly well when handling large data volumes. Instead of locking the entire table to import new information into a database like many other engines do, InnoDB locks only one row, so it can process much more tasks for the same period of time. Plus, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be handled. In case a specific operation hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the database content will be preserved safe and sound and won’t be partially mixed with new content.
InnoDB in Shared Web Hosting
Every PHP-based web application that requires InnoDB will function flawlessly on our avant-garde cloud web hosting platform and the MySQL storage engine comes with all our shared web hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected on the basis of the app’s requirements without having to update any setting in your shared account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We’ll create daily content backups, so if you unintentionally remove a MySQL database that is important to you or you overwrite certain parts of it, we will be able to restore your data the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Servers
If you set up a brand new MySQL database from the hosting Control Panel coming with all our semi-dedicated server accounts and you begin installing a script-driven app either manually or using our one-click application installer tool, the storage engine for the MySQL database will be selected automatically depending on the prerequisites of the specific application. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any app that needs it without any manual action required on your end at any time. To prevent any risk of losing data if you update an application or if you erase a database accidentally, we’ll carry out a backup of all your MySQL databases each and every day, so if something happens, we can rescue your content.
InnoDB in VPS Servers
If you purchase a VPS server from our company, you’ll be able to take advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will allow you to run any PHP script-based app which requires InnoDB, as this particular MySQL database storage engine is an essential part of the standard software bundle that will be installed on the server during its creation. When you set up a brand-new MySQL database through the hosting Control Panel, you’ll just need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine if the application in question requires it, so you will not have to do anything else in your VPS account. Similarly, if a given app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
InnoDB is included as standard with all Linux dedicated servers that are ordered with the Hepsia hosting Control Panel. It’s included in the software bundle that we install on all Hepsia-equipped servers, so once your physical machine is ready, you’ll be able to log in and to activate any kind of PHP script-driven web application that requires this MySQL storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any activated engine till you start installing an application. As soon as the app activation wizard starts dumping content in the newly created database, the engine will be picked automatically on the basis of the requirements of the specific app, so you can run both MyISAM and InnoDB without the need to select either one specifically at any moment. Therefore, you can make use of an immense variety of applications for your Internet sites.