Database Manager

Database management might sound like a difficult task to unskilled website hosting users, but with the Database Manager, it’s in fact reasonably easy! To create a brand new database, you simply need to type in the username and password. Database backups are only a mouse click away also.People that would like to examine their databases and then change them can use the phpMyAdmin and phpPgAdmin tools.

From the Database Manager it’s possible to produce an archived duplicate of your database whenever you would like! Therefore, you are going to always have a backup of your dynamic content in the event your web site gets hacked or you accidentally remove a database. To make a backup: click on the ’clock’ image alongside a certain database and after that wait for a few seconds for the backup process to be finished.

There won’t be any boundaries on the volume of databases you can back up or the volume of backups you can make for any database.

PgSQL databases are significantly less common than the popular MySQL databases. However, they represent a preferred choice for web developers seeking the ultimate security for their websites and applications. Because of the incredibly user–friendly Database Manager incorporated into the hostfields Control Panel, you can manage all of your PostgreSQL databases with a simple click of the mouse.

You are going to find PgSQL databases provided by default inside the top cloud hosting packages. Assuming that you are using a regular hosting package, it is easy to ask for PgSQL databases to be included in your web hosting account as upgrades.

We’ve added InnoDB – the new default MySQL database engine on all of our machines. InnoDB is made for big database websites which require high levels of effectiveness and scalability. Experiments demonstrate that web sites using InnoDB based tables reach a 3–fold operation boost for substantial joins, compared with those utilizing MyISAM tables.

InnoDB employs row–level locking in order to be able to remove the overall performance difficulties spotted at the peak usage times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load generated by the databases within your dynamic site will help you avoid any kind of overload issues that could slow it down and ward off site visitors. For this reason, we’ve built–in a comprehensive Database Stats tool inside the Web Site Control Panel. There you can find in depth information on the incoming requests to your databases for each hour, day and month.

Based on the quantity of day–to–day and per hour queries, it will be straightforward to determine which databases are employed the most and also consider procedures to enhance their work.