InnoDB is a popular database storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got lots of strong sides which make it the preferred engine for many PHP-powered software applications, among them Magento and Joomla™, which have moved to InnoDB permanently. For instance, importing enormous data volumes will be faster with InnoDB, because it locks only a single database row to complete a specific operation, 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 handled. In simpler words, appending new or updating existent data will either be fully completed, or will be aborted and the operation will be rolled back if any problem occurs during the process, therefore the content that remains in the database won’t be lost.
InnoDB in Website Hosting
You’ll be able to make use of any PHP script-driven app that requires InnoDB in case you have a website hosting
with our company, as the MySQL storage engine is present on our avant-garde 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 impeccably in case this engine is needed. You can activate apps which need the MyISAM engine without any difficulty as well and, once again, the engine will be pre-selected, so you will not have to modify anything manually at any moment. Furthermore, we’ll also make regular backups of all the databases that you’ve got in your shared hosting account, so if you delete or overwrite something, we can swiftly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated hosting service
come with InnoDB and you will be able to get the most out of all the features offered by this database storage engine with any PHP script-driven app that needs it. It is among the engines that are available on our cloud hosting platform, so the one that will be used depends on the prerequisites of the given application. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our one-click app installer. To be on the safe side, we’ll generate regular MySQL database backups, so if something goes wrong after some update or if you delete some data by mistake, we’ll be able to restore your database the way it was on any of the previous seven days.
InnoDB in VPS Servers
All Linux VPS web hosting service
that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you will be able to take advantage of any PHP script-driven web application that needs the database engine without setting up anything manually. You can select Hepsia on the VPS configuration page and your new VPS server will be up and running within 1 hour, so you can sign in and start setting up your web sites straight away. Once you create a new MySQL database and start the app activation process, our system will pick the engine for this MySQL database automatically. In this way, you can run various apps simultaneously without editing anything on the VPS server. You can create a WordPress-powered online blog that uses MyISAM – the default MySQL engine, and a Magento-powered e-commerce website that uses InnoDB, for instance.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the options that you can select on the server order page when you buy a dedicated server
from us. As this is the most powerful type of web hosting, it’s pretty likely that you’ll manage popular Internet sites that will attract a lot of people, and since InnoDB is one of the best options for such sites, we will enable it together with all the other software applications that come with a Hepsia-equipped dedicated server. If you set up a brand-new database in your dedicated server account, there won’t be any activated MySQL database engine till you start installing an open-source PHP script, whether manually via your browser or using the automatic script installer that is included in the hosting Control Panel. The needed engine will be recognized automatically and will be assigned to the database in question, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having to deal with any obstacle.