InnoDB is a database engine for MySQL databases, which is used by popular script-powered apps like Magento and Joomla™ 3.x. It’s ideal for scalable applications, because it works very well when handling immense volumes of data. Rather than locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one row, so it can perform much more operations for the same length of time. In addition, InnoDB offers a faster database crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and updates should be handled. If a particular task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will remain intact and won’t be partially mixed with new content.
InnoDB in Hosting
You can make use of any script-driven web application that requires InnoDB in case you have a hosting with us, as the database engine is available on our cutting-edge cloud platform by default. Throughout the app activation – 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 activate applications which require the MyISAM engine without encountering any difficulty as well and, once again, the engine will be selected automatically, so you will not have to modify anything manually at any point. Furthermore, we’ll also make daily backups of all the databases that you have in the shared account, so if you erase or overwrite anything, we can quickly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Hosting
If you create a brand new MySQL database through the Control Panel coming with all our semi-dedicated server plans and you start installing a PHP script-powered software application either manually or using our single-click application installer tool, the storage engine for the database will be selected automatically depending on the prerequisites of the given application. Since InnoDB is present on the cloud platform where your new account will be set up, it will be set as the default engine for each app that needs it without any manual intervention required on your end at any point. To prevent any chance of losing data if you update an application or if you delete a database unintentionally, we will carry out backups of all your databases every day, so if something happens, we can restore your data.
InnoDB in VPS Web Hosting
In case our in-house built Hepsia Control Panel is chosen during the signup process for your new Linux VPS web hosting packages , InnoDB will be installed on the VPS server along with other needed pieces of software, so you won’t need to do anything if you decide to manage script-based apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand new database and begin the app installation process manually or using our one-click installer. The system will automatically recognize the engine that the particular application requires and will assign it to the specific database, so the installation will continue impeccably and the app can enter its content into that database. In this way, you can use apps with different requirements in regard to the MySQL engine without having to make any changes on your VPS.
InnoDB in Dedicated Servers Hosting
InnoDB is included as standard with all Linux dedicated servers hosting ordered with the Hepsia Control Panel. It is an integral part of the default software package that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is up and running, you’ll be able to log in and to install any kind of open-source script-driven app that requires this particular MySQL database engine. When you set up a new MySQL database through the Control Panel, there won’t be any active engine until you start installing an app. As soon as the app setup wizard starts entering content into the database, the engine will be set automatically depending on the prerequisites of the specific application, so you can run both InnoDB and MyISAM without selecting either of them specifically at any point. In this way, you can make use of a broad selection of applications for your websites.