InnoDB is a popular database storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got lots of upsides which make it the engine of choice for lots of open-source script-based web apps, among them Magento and Joomla™, which have switched over to InnoDB for good. For instance, importing enormous data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to perform a certain operation, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is tackled. In simpler words, appending new or updating existing data will either be fully completed, or will be canceled and the operation will be rolled back if a given problem appears in the meantime, hence the content that remains in the database will not be lost.

InnoDB in Shared Hosting

You’ll be able to run any script-driven web app that needs InnoDB in case you’ve got a shared hosting with our company, as the MySQL storage engine is present on our innovative cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can install apps that use the MyISAM engine without encountering any problem as well and, once again, the engine will be selected automatically, so you will not need to change any setting manually at any moment. Furthermore, we will also generate regular backups of all the databases that you’ve got in your account, so in case you delete or overwrite something, we can easily get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database through the Control Panel coming with each of our semi-dedicated server plans and you start installing a PHP-driven software application either manually or using our 1-click application installer tool, the MySQL database storage engine will be picked automatically based on the requirements of the given app. Since InnoDB is present on the cloud platform where your new semi-dedicated account will be set up, it will be set as the default engine for each application that needs it without any manual action needed on your end at any point. To prevent any risk of losing info if you update an app or if you delete a database unintentionally, we’ll perform a backup of all your databases every day, so if something goes wrong, we can retrieve your data.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features which you can pick on the order page when you purchase a dedicated server from our company. As this is the most powerful kind of website hosting, it’s quite likely that you will run popular Internet sites that will draw plenty of people, and since InnoDB is one of the best options for such sites, we will activate it together with all the other software applications that are available with a Hepsia-equipped server. If you set up a brand-new MySQL database in your dedicated server account, there won’t be any activated MySQL database engine until you start installing a PHP script, whether manually through your web browser or using the automatic script installer tool that is available in the Control Panel. The needed engine will be recognized and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without having to cope with any impediment.