InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has plenty of strengths which make it the preferred engine for lots of script-powered software apps, such as Joomla™ and Magento, which have switched to InnoDB for good. For instance, importing huge amounts of data will be much faster with InnoDB, because it locks only one row to carry out a certain task, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. In simpler words, appending new or editing existing data will either be fully completed, or will be canceled and the procedure will be rolled back in case some issue shows up during the process, so the content that remains in the database won’t be lost.
InnoDB in Web Hosting
InnoDB is available with all our web hosting plans
by default, not upon request or as a paid upgrade, so you will be able to activate and run any open-source script-driven software application which requires the storage engine without encountering any problem as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation process, irrespective of whether you use our 1-click installation tool or create the MySQL database and activate the app manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We will generate regular database backups, so you can be sure that you will never lose any content in case you erase a database by mistake or you overwrite some crucial info – you’ll simply need to get in touch with us and we will restore your database the way it was.
InnoDB in Semi-dedicated Servers
If you create a brand new MySQL database through the hosting Control Panel offered with all our semi-dedicated server
plans and you begin installing a PHP script-powered software application either manually or using our 1-click application installer, the storage engine for the database will be selected automatically on the basis of the prerequisites of the particular application. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any moment. To prevent any chance of losing information if you update an application or if you delete a database unintentionally, we’ll generate a backup of all your MySQL databases every day, so if something goes wrong, we can retrieve your content.
InnoDB in Dedicated Servers
If you get a new dedicated server
, you will be able to select one of the 3 Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to add this storage engine manually in order to be able to run PHP-powered apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you require in order to manage large-scale websites, it’s rather possible that you’ll use InnoDB. You’ll be able to make use of other engines as well, so in case a specific application requires MyISAM instead of InnoDB, you won’t come across any impediment while running it. The engine that will be used will be automatically recognized once the app installation starts, so you won’t need to alter any settings manually at any point.