InnoDB is a very popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of strengths which make it the engine of choice for lots of open-source script-powered web apps, among them Magento and Joomla, which have switched to InnoDB for good. For example, adding large data volumes will be faster with InnoDB, because it locks only one database row to carry out a certain operation, not the entire table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Simply put, adding new or updating existent data will either be fully completed, or will be canceled and the procedure will be rolled back if any issue appears during the process, thus the content that remains in the database won’t be lost.
InnoDB in Cloud Web Hosting
InnoDB is offered with all our Linux cloud web hosting by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP-based software application which needs the database engine without the need to deal with any problem as soon as you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a particular database during the app installation process, irrespective of whether you use our single-click installation tool or create the database and set up the app manually, on the condition that the app requires it instead of the more famous MyISAM engine. We will make regular database backups, so you can be certain that you’ll never lose any data if you delete a database by mistake or you overwrite some vital information – you just need to contact us and we’ll restore your content the way it was.
InnoDB in Semi-dedicated Hosting
If you set up a new MySQL database through the hosting Control Panel included with each of our semi-dedicated server plans and you start installing a PHP script-based app either manually or using our one-click app installer, the storage engine for the MySQL database will be selected automatically based on the prerequisites of the particular app. As InnoDB is available on the cloud hosting platform where your new account will be set up, it will be set as the default engine for any application that requires it without any manual intervention required on your end at any time. To avoid any risk of losing information if you update an application or if you remove a database unintentionally, we will make a backup of all your MySQL databases every day, so if anything goes wrong, we can recover your content.
InnoDB in VPS Web Hosting
All Linux VPS web hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any PHP script-based app that requires this MySQL database engine without configuring anything manually. You can select Hepsia on the VPS configuration page and your new server will be set up within 1 hour, so you can sign in and begin setting up your web sites straight away. When you create a new MySQL database and start the app installation process, our system will pick the engine for this database automatically. Thus, you can use different apps at the same time without updating anything on the Virtual Private Server. You can set up a WordPress-based personal weblog that uses the default MySQL engine – MyISAM, and a Magento-based online store that uses InnoDB, for instance.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting that are ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to activate it manually in case you need to activate PHP scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to begin the setup process – once the script setup wizard gets access to the database and begins inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You’ll also be able to activate scripts that require MyISAM – the other widely used MySQL engine, so you won’t need to modify any settings on the dedicated server. This will permit you to activate different scripts on one single physical machine and to use it to its maximum capacity.