InnoDB is a storage engine for MySQL relational databases, which is used by widely used script-powered web apps such as Magento and Joomla™ v3. It’s perfect for scalable apps, since it works remarkably well when managing huge data volumes. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same length of time. Besides, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – rules that define how data inserts and updates should be treated. In case a particular operation has not been fully completed for some reason, the action will be rolled back. In this way, the database content will stay intact and will not be partially mixed with newly imported content.
InnoDB in Web Hosting
Every open-source script-driven app that needs InnoDB will run impeccably on our innovative cloud web hosting platform and the database storage engine is offered with all our web hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation is started, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without the need to change any setting in your hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We’ll carry out daily backups of your content, so if you unintentionally remove a MySQL database that’s important to you or you overwrite certain parts of it, we’ll be able to restore the database the way it was just a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting come with InnoDB and you will be able to get the most out of all the options offered by this storage engine with any open-source script-powered web application that requires it. It’s among the engines that we have on our cloud web hosting platform, so the one that will be used depends on the requirements of the app in question. You will not need to do anything manually in order to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer tool. To avoid any risk, we’ll keep regular backups of all your databases, so if something goes wrong following an upgrade or if you remove some data accidentally, we will be able to get your database back to the way it was on any of the previous seven days.
InnoDB in VPS Web Hosting
If our custom-built Hepsia Control Panel is picked during the registration process for your new Linux virtual private servers , InnoDB will be installed on the VPS server along with other required software, so you won’t have to do anything if you choose to use PHP-based web apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand new MySQL database and begin the app installation process manually or through our one-click installer. The system will detect the engine that the application in question needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the app can insert its data into that database. In this way, you can run apps with different requirements about the MySQL engine without making any modifications on your server.
InnoDB in Dedicated Servers Hosting
InnoDB comes by default with all Linux dedicated hosting services ordered with the Hepsia Control Panel. It is an integral part of the default software package that will be pre-installed on all Hepsia-managed servers, so as soon as your physical machine is up and running, you’ll be able to sign in and to install any kind of PHP-driven web app that requires this MySQL database engine. When you create a new MySQL database through the Control Panel, there won’t be any activated engine till you start installing an app. As soon as the app installation wizard begins importing data into the newly created database, the engine will be set automatically depending on the respective app’s requirements, so you can run both MyISAM and InnoDB without having to select either one of them specifically at any point. Therefore, you can use an extensive selection of applications for your websites.