Read more about InnoDB and see why it’s been picked out as the default MySQL database engine.
InnoDB is a popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has a lot of pluses that make it the engine of choice for a lot of PHP script-driven applications, including Magento and Joomla™, which have shifted over to InnoDB for good. For instance, importing huge amounts of data will be much faster with InnoDB, as it locks only one database row to perform a task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is handled. Put simply, importing new or editing existent data will either be entirely completed, or will be aborted and the operation will be rolled back if a given problem appears in the meantime, which means that the content that remains in the database will not be damaged.
InnoDB in Website Hosting
You will be able to activate any PHP-based software application that needs InnoDB in case you have a website hosting service
with our company, as the MySQL database engine is available on our advanced cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can run applications that require the MyISAM engine without any impediments as well and, again, the engine will be selected automatically, so you will not need to change anything manually at any time. What’s more, we will also make regular backups of all the databases that you’ve got in the shared account, so if you delete or overwrite anything, we can swiftly get it back to the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
You can run a PHP-driven software app that requires InnoDB with any of our semi-dedicated server
packages, due to the fact that all the accounts are set up on our cutting-edge cloud web hosting platform where the MySQL database engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our one-click application installer. Either way, the needed engine will be chosen automatically the moment the application’s activation starts, so you will not need to modify anything manually, irrespective of whether the app requires InnoDB or the more widely used MyISAM. Also, we will always be able to recover any of your databases in case you erase one by mistake, as we carry out a few database backups every day, each of which is stored for 7 days.
InnoDB in VPS Servers
If our custom-developed Hepsia Control Panel is picked during the signup process for your new VPS servers
, InnoDB will be activated on the VPS server together with other essential pieces of software, so you will not need to do anything if you decide to make use of script-driven software apps that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a brand-new MySQL database and start the app installation process manually or using our one-click installer. The system will detect the engine that the particular application needs and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can dump its data in that database. Thus, you can manage applications with different requirements concerning the MySQL engine without having to make any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the options that you can choose on the server configuration page when you purchase a dedicated server
from us. Since this is the most powerful kind of web hosting, it’s rather likely that you will run very popular Internet sites that will draw many visitors, and since InnoDB is among the very best options for such sites, we’ll install it along with all the other software apps that are offered with a Hepsia-managed dedicated server. When you set up a new MySQL database in your account, there won’t be any activated MySQL database engine until you begin installing an open-source PHP script, whether manually through your Internet browser or using the automatic script installation tool that is integrated into the hosting Control Panel. The necessary engine will be automatically detected and will be set for the database in question, so you can activate scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having any difficulty.