Database Manager

Database management might sound like a difficult job to unskilled web hosting clients, nevertheless with Big Hammer Hosting’s Database Manager, it’s actually pretty simple! To set up a completely new database, you just ought to enter your username and password. Database backup copies are just a click away as well.People who want to examine their databases as well as edit them should use the phpMyAdmin and phpPgAdmin tools.

In case you have dealt with databases, you already know that creating a manual database backup is simply not an elementary job. In order to change this, we have made an easy to understand tool that can back up your whole database with just one mouse click. The backup file is going to be available for you in under a minute, depending on the size of the selected database.

There are not any limits on the total number of backups you can create for a selected database.

You can find PgSQL support in all our cloud hosting packages plans. PgSQL databases aren’t as sought after and commonly used as MySQL, however they offer the highest level of stability for your site content and articles. For this reason, a number of widely known brands like Skype and Yahoo employ PgSQL databases. Managing PgSQL databases is as simple and easy as MySQL, due to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are provided automatically inside the most innovative web hosting bundles. For the basic bundles, they’re featured as upgrades.

We have integrated InnoDB – the brand new default MySQL database engine on all our servers. InnoDB is designed for large database sites that need high levels of overall performance and scalability. Trials have established that web sites making use of InnoDB based tables reach a 3–fold overall performance boost for big joins, in comparison to those working with MyISAM tables.

InnoDB utilizes row–level locking in order to be able to eliminate efficiency difficulties seen at the top usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Keeping tabs on the load produced by the databases in your active site will let you avoid any sort of overload issues that might slow it down and ward off visitors. As a result, we have bundled a in depth Database Stats tool straight into the Online Control Panel. There you can see comprehensive information about the inbound requests to your databases for each and every hour, day and month.

Depending on the amount of day–to–day and per hour queries, it will be straightforward to find out which databases are being used the most and then consider steps to optimize their load.