InnoDB is a popular database engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has numerous advantages which have made it the engine of choice for lots of open-source script-powered apps, such as Magento and Joomla, which have moved to InnoDB permanently. For instance, adding large data volumes will be much faster with InnoDB, as it locks only one row to perform a specific 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 way in which the information is handled. Simply put, importing new or editing existent data will either be fully completed, or will be aborted and the procedure will be rolled back if any issue shows up in the meantime, hence the content that remains in the database will not be lost.
InnoDB in Shared Website Hosting
You’ll be able to run any open-source script-powered web application that needs InnoDB if you have a Linux shared website hosting with our company, as the database engine is present on our innovative cloud platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can install apps that use the MyISAM engine without encountering any problem as well and, again, the engine will be selected automatically, so you will not need to edit any setting manually at any point. In addition, we will also create daily backups of all the databases that you have in your shared account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Hosting
InnoDB is included with each of our Linux semi-dedicated hosting by default, so once you purchase a new semi-dedicated account, you can go on and install any open-source script-powered software application that needs the MySQL database storage engine. A few engines are pre-installed on our cloud hosting platform, so when you set up a brand new database and begin installing an app manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be chosen in accordance with the requirements of the specific app. This will allow you to install and run InnoDB-specific applications without encountering any obstacle and without needing to update any settings in your account. To avoid any risk, we’ll always keep a one-week-old backup of all your MySQL databases, so if you delete or change any content by mistake, we can swiftly retrieve it.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting that are ordered with our custom-built Hepsia hosting Control Panel come with a software package that’s pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t have to activate it manually in case you would like to activate open-source scripts that require it. All it takes to activate such a script is to set up a new database and to start the installation process – once the script setup wizard gets access to the database in question and begins importing content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that need MyISAM – the other very popular MySQL engine, so you will not need to modify any settings on the dedicated server. This will enable you to install various scripts on one single physical server and to use the latter to its fullest potential.