InnoDB is a popular database engine for MySQL. It is an alternative to the default MyISAM engine and it has got a number of upsides which have made it the engine of choice for numerous PHP-powered web applications, including Magento and Joomla, which have moved to InnoDB for good. For example, importing immense data volumes will be faster with InnoDB, as it locks only one row to carry out a certain task, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is handled. Simply put, importing new or editing existent data will either be fully completed, or will be canceled and the procedure will be rolled back if any issue appears during the process, so the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
You can make use of any PHP-driven web application that needs InnoDB in case you’ve got a Linux shared hosting with our company, as the storage engine is present on our advanced cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is required. You can activate apps that need the MyISAM engine without the need to deal with any difficulty as well and, once again, the engine will be pre-selected, so you won’t have to modify anything manually at any moment. On top of that, we’ll also generate daily backups of all the databases that you have in your shared account, so in case you delete or overwrite anything, we can easily get it back to the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
You can install a PHP-driven web application that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our avant-garde cloud web hosting platform where the storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click application installer. Either way, the needed engine will be chosen automatically the moment the app’s activation begins, so you will not need to edit anything manually, no matter if the application requires InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to recover any of your databases if you remove one by accident, as we generate a couple of MySQL database backups every day, each of which is stored for 1 week.
InnoDB in VPS Servers
If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the software pack that will be pre-installed on your VPS server before we hand it over to you. You will not need to activate anything manually and you will be able to enable and use any PHP-driven application that requires InnoDB as soon as your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission process itself. Several engines are available, so anytime you create a MySQL database through the Hepsia hosting Control Panel, a specific engine will be picked once the app installation process commences and our system will detect which engine is required by the application in question. If you need MyISAM, for example, you will not need to do anything different from installing the chosen app, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
If you purchase a new dedicated server, you will be able to select one of the three Control Panels that we’re offering – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you will not need to enable this database engine manually so as to be able to run PHP script-driven apps that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the server resources that you need in order to manage large-scale Internet sites, it’s quite possible that you’ll resort to InnoDB. You’ll be able to use other engines too, so if a particular application requires MyISAM instead of InnoDB, you won’t have any impediment while running it. The engine that will be used will be automatically recognized once the app installation process commences, so you will not have to modify any setting manually at any time.