InnoDB is a database engine for MySQL relational databases, which is used by popular script-powered web applications like Joomla 3.x and Magento. It’s perfect for scalable applications, because it performs astonishingly well when managing huge amounts of data. Instead of locking the entire table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can handle much more operations for the same length of time. In addition, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – rules that determine how data inserts and modifications should be treated. If a certain operation has not been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will remain intact and will not be partially merged with newly imported content.
InnoDB in Shared Website Hosting
InnoDB is offered with all our shared website hosting plans by default, not upon request or as a paid upgrade, so you will be able to activate and manage any PHP script-powered app that needs the MySQL database storage engine without having any problem as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation process, irrespective of whether you use our 1-click installer or create the MySQL database and activate the app manually, provided that the app requires it instead of the more popular MyISAM engine. We’ll store regular backups of all your MySQL databases, so you can rest assured that you won’t ever lose any data if you delete a database unintentionally or you overwrite some essential info – you’ll just have to get in touch with us and we’ll restore your database back to normal.
InnoDB in Semi-dedicated Servers
All our semi-dedicated plans include InnoDB and you will be able to use all the options offered by this storage engine with any PHP-powered software app that requires it. InnoDB is one of the engines that are available on our cloud platform, so the one that will be selected depends on the requirements of the given app. You won’t have to do anything manually to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click app installer tool. To avoid any risk, we will generate regular database backups, so if something goes wrong after some update or if you remove some data unintentionally, we will be able to restore the database the way it was on any of the past seven days.
InnoDB in VPS Servers
In case our in-house built Hepsia Control Panel is chosen during the signup process for a new VPS hosting plans , InnoDB will be installed on the VPS server together with other necessary pieces of software, so you won’t need to do anything if you decide to install PHP script-based web apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a new MySQL database and begin the app installation procedure manually or using our one-click installer tool. The system will detect which engine the particular application requires and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the application can dump its data in that database. In this way, you can use apps with different requirements concerning the MySQL engine without making any changes on your VPS server.
InnoDB in Dedicated Servers
InnoDB is available by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is included in the standard software package that we install on all Hepsia-managed servers, so once your machine is set up, you’ll be able to sign in and to activate any type of PHP-based software app that requires this MySQL storage engine. If you set up a new database via the hosting Control Panel, there won’t be any active engine until you start installing an application. Once the app configuration wizard starts inserting data into the database, the engine will be selected automatically on the basis of the prerequisites of the given application, so you can run both MyISAM and InnoDB without selecting either one specifically at any moment. Thus, you can make use of an extensive variety of applications for your Internet sites.