Database Manager

Database management may appear like a complicated job to inexperienced hosting clients, nevertheless with the Database Manager, it’s in fact relatively easy! To make a completely new database, you simply need to enter in the username and password. Database backups are simply a click away at the same time.People that want to examine their databases as well as alter them are able to use the phpMyAdmin and phpPgAdmin tools.

We have designed the manual database back–up generation into a quite simple task. To do this: within the Database Manager, click on the ’clock’ icon near the database that you would like to back up and after that wait around for a couple of seconds for the process to take place. Depending on the size of the database, the creation of the back–up file can take somewhere between a couple of seconds and a minute.

You can create as many back–ups of a database as you desire. We haven’t set any boundaries on the volume of databases you could back up too.

PgSQL databases are significantly less common as compared to the popular MySQL databases. Nevertheless, they are a preferred option for designers who seek the uttermost safety for their websites and applications. Thanks to the incredibly user–friendly Database Manager built–into the DjPCs Control Panel, you can manage all of your PostgreSQL databases with only a mouse click.

You’ll find PgSQL databases included automatically inside of the best Linux shared website hosting packages. In case you are using a regular hosting package, you’re able to ask for PgSQL databases to be added to your hosting account as upgrades.

We’ve installed InnoDB – the new standard MySQL database engine on all our web servers. InnoDB is ideal for significant database sites which need high levels of efficiency and scalability. Experiments have established that web sites applying InnoDB based tables attain a 3–fold general performance increase for large joins, as compared to those applying MyISAM tables.

InnoDB uses row–level locking in order to be able to clear away the performance difficulties noticed at the peak usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load caused by the databases on your active website will let you prevent all overload issues that might slow it down and chase away site visitors. As a result, we have bundled a thorough Database Stats tool inside the Website Control Panel. There you can find in–depth information on the incoming requests to your databases for each hour, day and month.

In line with the quantity of day–to–day and hourly queries, you are going to be able to determine which databases are being used the most and take measures to enhance their work.