Databases Manager

The Databases Manager inside our Web Control Panel contains a powerful nevertheless straightforward interface. It is easy to configure a new MySQL or PostgreSQL database simply by specifying a user name and password. Additionally, you can make a backup file or modify the security password of your database with just a mouse click.

With the Databases Manager you’ll have direct access to the management area for every one of your databases, in order to make convenient corrections should you need to.

Assuming you have worked with databases, you know making a manual database back–up isn’t a simple task. So as to change this, we have developed a simple tool that will back up your complete database with just a single click. The data backup file is going to be ready for you in under a minute, based on the size of the selected database.

There are not any confines on just how many backups you can create for any chosen database.

PgSQL databases are much less popular as opposed to the well–known MySQL databases. Nevertheless, they’re a preferred choice for programmers who seek the finest safety for their web sites and web applications. Thanks to the incredibly user–friendly Databases Manager included in the AfghanDNS.com Control Panel, you can control all of your PostgreSQL databases with merely a click of the mouse.

You can discover PgSQL databases included by default inside the advanced hosting packages. Provided that you are using a basic hosting package, it is easy to ask for PgSQL databases to be added to your website hosting account as upgrades.

The MySQL databases on our servers use the most recent build of the InnoDB storage engine. InnoDB is intended to guarantee the highest possible functionality for web sites that process large amounts of data. It delivers CPU effectiveness that could not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, which means you are able to update/insert/create/alter/drop repeatedly for a single "operation" of your web app. Also, it takes advantage of row–level locking and not MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

We offer you a simple approach to keep tabs on the database use of your dynamic web sites. From the descriptive database statistics user interface, that is integrated into the Web Control Panel, it is possible to keep an eye on the load produced through your busy websites in real time. The delivered information will enable you to evaluate the database load changes on an hourly basis, daily or per month.

It’s possible to keep an eye on the database load for all your sites within the Database Stats portion of the Web Control Panel. The table onscreen features the database lookups generated in the present month. To examine information for a previous month, all you have to do is click on the back arrows situated at the top.