InnoDB is a very popular database storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has a lot of advantages which make it the engine of choice for numerous PHP-powered web applications, including Joomla™ and Magento, which have switched over to InnoDB for good. For instance, adding huge amounts of data will be faster with InnoDB, because it locks only one row to carry out a certain operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is treated. Put simply, adding new or editing existent data will either be fully completed, or will be canceled and the procedure will be rolled back if any problem shows up during the process, which means that the content that remains in the database won’t be damaged.
InnoDB in Website Hosting
InnoDB is available with all our website hosting
by default, not as a paid upgrade or upon request, so you will be able to install and manage any script-driven app which requires the storage engine without having to deal with any obstacle once you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation, irrespective of whether you make use of our one-click installer or create the MySQL database and activate the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll perform regular database backups, so you can be certain that you won’t ever lose any content if you erase a database by accident or you overwrite some important info – you simply have to get in touch with us and we will restore the database back to normal.
InnoDB in Semi-dedicated Servers
InnoDB is included with each of our semi-dedicated servers
by default, so the moment you obtain a new account, you can go on and activate any open-source script-driven application that needs this particular database storage engine. A couple of engines are installed on our cloud web hosting platform, so when you set up a new database and begin installing an application manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen on the basis of the requirements of the specific app. This will permit you to activate and manage InnoDB-specific applications without having any problem and without having to modify any settings in your account. To avoid any risk, we’ll always have a seven-day-old backup of all your MySQL databases, so if you delete or alter any content accidentally, we can swiftly retrieve it.
InnoDB in Dedicated Servers
If you obtain a new dedicated server
, you will be able to pick one of the 3 hosting Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to add this database storage engine manually in order to be able to use PHP script-driven apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you need to manage very large sites, it is pretty likely that you’ll resort to InnoDB. You will be able to use other engines as well, so in case a given app requires MyISAM rather than InnoDB, you will not need to deal with any problem while running it. The engine that will be used will be automatically detected the moment the app installation starts, so you will not have to configure any settings manually at any moment.