InnoDB is a very popular database storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got a number of pluses that make it the engine of choice for plenty of script-powered apps, such as Joomla and Magento, which have moved to InnoDB for good. For example, adding immense amounts of data will be faster with InnoDB, because it locks only a single row to complete a task, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. Put simply, adding new or modifying existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case some issue shows up in the meantime, so the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud hosting by default, not as a paid upgrade or upon request, so you can install and manage any PHP-driven app that requires the MySQL database engine without having any difficulty as soon as you activate your shared web hosting account. InnoDB will be pre-selected as the default engine for a certain database during the app installation, regardless of whether you use our single-click installation tool or create the database and install the application manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We’ll store daily MySQL database backups, so you can rest assured that you won’t ever lose any content in case you delete a database unintentionally or you overwrite some crucial information – you simply have to contact us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database from the Control Panel offered with all our semi-dedicated server packages and you begin installing an open-source script-powered app either manually or using our 1-click app installer tool, the MySQL database storage engine will be selected automatically depending on the requirements of the given app. Since InnoDB is available on the cloud web hosting platform where your new account will be created, it will be set as the default engine for any application that needs it without the need for any manual intervention on your end at any moment. To avoid any risk of losing information if you update an app or if you delete a database unintentionally, we’ll perform backups of all your MySQL databases each day, so if anything happens, we can retrieve your data.
InnoDB in VPS Servers
All Linux VPS hosting service that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to run any script-powered application that needs this particular MySQL database engine without needing to activate anything manually. You can select Hepsia on the VPS configuration page and your new Virtual Private Server will be ready within 60 minutes, so you can log in and start building your web sites straight away. Once you create a brand-new MySQL database and begin the app installation process, our system will set the engine for that MySQL database automatically. Thus, you can use different applications at the same time without having to configure anything on the server. You can create a WordPress-powered personal weblog that uses the default MySQL engine – MyISAM, and a Magento Internet shop that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
All dedicated service ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually in case you would like to activate scripts that need it. All it takes to install such a script is to create a new MySQL database and to begin the setup process – as soon as the installer wizard gains access to the database and starts entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to install scripts that need MyISAM, the other very popular MySQL engine, so you will not need to change any settings on the server. This will permit you to use a variety of scripts on a single machine and to use the latter to its fullest potential.