InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got plenty of strong sides which make it the preferred engine for many PHP script-powered software apps, among them Joomla and Magento, which have shifted over to InnoDB permanently. For example, adding immense data volumes will be faster with InnoDB, as it locks only one row to perform a certain task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. In simpler words, adding new or updating existing data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case a given issue occurs during the process, so the content that remains in the database won’t be damaged.
InnoDB in Shared Website Hosting
Every script-based software application that needs InnoDB will function flawlessly on our innovative cloud platform and the MySQL storage engine is available with all our shared website hosting plans. Every time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected based on the app’s specifications without having to update any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We’ll store regular backups of your content, so if you accidentally delete a database that’s important to you or you overwrite specific parts of it, we’ll be able to restore everything the way it was just several hours earlier.
InnoDB in Semi-dedicated Hosting
If you set up a brand-new MySQL database from the Control Panel offered with each of our semi-dedicated server plans and you start installing an open-source script-based app either manually or using our single-click app installer, the storage engine for the MySQL database will be picked automatically on the basis of the requirements of the given application. As InnoDB is present on the cloud platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any time. To prevent any risk of losing data if you update an application or if you remove a database accidentally, we will perform backups of all your databases each day, so if something goes wrong, we can retrieve your data.
InnoDB in VPS Hosting
In case our in-house developed Hepsia Control Panel is picked during the registration process for your new Linux VPS hosting packages , InnoDB will be installed on the Virtual Private Server together with other necessary pieces of software, so you won’t need to do anything if you decide to manage PHP script-driven web apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand-new MySQL database and begin the app installation process manually or through our 1-click installation tool. The system will automatically recognize which engine the application in question needs and will assign it to the specific database, so the installation process will proceed impeccably and the app can dump its data in that database. Thus, you can install apps with different requirements with regard to the MySQL engine without the need to make any modifications on your server.
InnoDB in Dedicated Web Hosting
If you purchase a new dedicated server, you’ll be able to pick one of the three hosting Control Panels offered by us – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not have to activate this database storage engine manually so as to be able to use PHP script-driven apps that need it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you need to manage large-size Internet sites, it is pretty likely that you’ll use InnoDB. You will be able to use other engines as well, so if a certain application requires MyISAM instead of InnoDB, you won’t come across any problem while running it. The engine that will be used will be detected automatically when the app installation procedure begins, so you will not need to alter any setting manually at any moment.