InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has many pluses which make it the engine of choice for numerous script-driven web apps, such as Magento and Joomla™, which have switched over to InnoDB for good. For instance, adding immense data volumes will be much faster with InnoDB, as it locks only one database row to execute a specific task, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the info is treated. Simply put, adding new or updating existent data will either be entirely completed, or will be canceled and the operation will be rolled back if any problem appears in the meantime, which means that the content that remains in the database won’t be lost.
InnoDB in Hosting
InnoDB is available with all our hosting
by default, not upon request or as a paid upgrade, so you will be able to install and run any open-source script-powered web application which needs the InnoDB storage engine without any difficulties as soon as you activate your shared account. InnoDB will be selected automatically as the default engine for a certain database during the app installation, regardless of whether you use our one-click installation tool or create the database and activate the app manually, as long as the app requires it instead of the more famous MyISAM engine. We will store daily MySQL database backups, so you can be sure that you won’t ever lose any data if you delete a database by mistake or you overwrite some important information – you’ll just have to notify us and we’ll restore your data the way it was.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our semi-dedicated service
by default, so the moment you create a new semi-dedicated account, you can go ahead and activate any open-source script-based application that needs this particular database storage engine. Several engines are installed on our cloud platform, so when you set up a brand new database and start installing an app manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be set in accordance with the prerequisites of the respective application. This will permit you to install and manage InnoDB-specific apps without experiencing any difficulty and without having to edit any settings in your semi-dedicated account. To avoid any risk, we’ll always have a seven-day-old backup of all your databases, so if you remove or change any content accidentally, we can easily recover it.
InnoDB in VPS Servers
In case our custom Hepsia hosting Control Panel is selected during the registration process for a new VPS servers
, InnoDB will be activated on the server along with other needed software, so you won’t have to do anything if you choose to run PHP script-based software applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new MySQL database and start the app installation procedure manually or using our 1-click installation tool. The system will detect the engine that the particular app requires and will assign it to the specific database, so the installation will continue impeccably and the app can insert its data into that database. Therefore, you can manage apps with different requirements regarding the MySQL engine without making any changes on your VPS server.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the features which you can pick on the order page when you buy a dedicated server
from us. As this is the most powerful kind of website hosting, it is very likely that you’ll manage popular websites that will draw lots of individuals, and since InnoDB is among the very best options for such sites, we’ll install it along with all the other software apps that come with a Hepsia-managed server. When you set up a brand new database in your account, there won’t be any activated storage engine till you start installing a script, whether manually via your web browser or using the automatic script installer that is integrated into the Control Panel. The required engine will be automatically detected and will be assigned to the database in question, so you can install scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without coming across any difficulty.