InnoDB is a very popular database storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has a number of upsides that have made it the engine of choice for a lot of PHP-powered apps, including Joomla and Magento, which have switched to InnoDB permanently. For example, adding enormous volumes of data will be faster with InnoDB, since it locks only a single row to carry out a task, not the entire 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 info is treated. Simply put, appending new or updating existent data will either be entirely completed, or will be annulled and the procedure will be rolled back in case a certain issue shows up in the meantime, thus the content that remains in the database will not be damaged.

InnoDB in Web Hosting

You’ll be able to use any PHP-based application that requires InnoDB if you’ve got a web hosting package with us, as the MySQL storage engine is present on our cutting-edge cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can activate applications that require the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be selected automatically, so you will not have to change any setting manually at any time. Furthermore, we will also make daily backups of all the databases that you have in the shared hosting account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database through the Control Panel offered with each of our semi-dedicated server plans and you begin installing an open-source script-powered application either manually or using our 1-click app installer, the storage engine for the database will be selected automatically on the basis of the specific app’s prerequisites. As InnoDB is available on the cloud hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that requires it without any manual action required on your end at any time. To prevent any risk of losing data if you update an app or if you remove a database by accident, we’ll perform backups of all your databases each and every day, so if something goes wrong, we can recover your data.

InnoDB in VPS Web Hosting

If you pick a virtual private server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the software bundle that will be pre-installed on your VPS server before we give it to you. You will not have to set up anything manually and you’ll be able to install and run any PHP-powered web application that needs InnoDB once your VPS is ready, which takes no more than sixty minutes after the order submission itself. A couple of engines are available, so every time you create a database via the Hepsia Control Panel, a specific engine will be picked when the app installation commences and our system will recognize the engine that is required by the application in question. If you need MyISAM, for example, you won’t have to do anything different from installing the app of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is one of the options that you can select on the order form when you purchase a dedicated server from our company. As this is the most powerful kind of website hosting, it’s very likely that you’ll manage very popular websites that will draw plenty of people, and since InnoDB is one of the very best choices for such sites, we’ll activate it together with all the other software applications that come with a Hepsia-equipped dedicated server. When you set up a brand-new MySQL database in your account, there won’t be any active MySQL database engine till you start installing a script, whether manually through your browser or using the automatic script installation tool that is available in the Control Panel. The required engine will be detected automatically and will be set for the database in question, so you can run scripts that need InnoDB, as well as ones that require the default MySQL engine, MyISAM, without encountering any complication.