Find out more on InnoDB and find out why it’s already been picked out as the default MySQL database engine.
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.