Database Manager

Administering your databases is simpler than before, because of the Site Control Panel user interface for MySQL and PgSQL administration! In case you do not have substantial knowledge in handling databases, you will find it effortless to manage Astaan Host’s Database Manager.

You can create a whole new database just by entering the username and password or generate a database backup with merely a click of the mouse. In addition, from the Data Manager you’ll possess direct access to the admin area for each database, so you’re able to almost instantly manage it.

We’ve made the manual database backup formation into a quite easy activity. To do so: in the Database Manager, click the ’clock’ image on the side of the database that you intend to back up and afterwards wait for a few seconds for the process to take place. Depending upon the size of your database, the generation of the backup file will take between a couple of seconds and a minute.

You can create as many copies of a database as you would like. We haven’t fixed any limits about the volume of databases you could back up too.

PgSQL databases are less common in comparison to the well–known MySQL databases. Nonetheless, they are a preferred selection for developers who seek the best protection for their web sites and web applications. Due to the easy–to–use Database Manager included in the Astaan Host Control Panel, you can control all of your PostgreSQL databases with a click of the mouse.

You are going to find PgSQL databases included by default inside of the best Linux web hosting packages packages. Provided that you are using a standard hosting package, you’ll be able to request PgSQL databases to be added in your cloud hosting account as upgrades.

With Astaan Host, you shall inevitably discover the most up–to–date release of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is far more secure as compared to the previous storage engine’s version – MyISAM. It is ACID–compliant and, above all – it offers complete transaction support. Additionally, it employs row–level locking, as an alternative to MyISAM’s table–level locking, that used to trigger effectiveness problems at high usage periods.

Tracking the load made by the databases within your active site will help you stop all sorts of overload problems that might slow it down and chase away site visitors. For that reason, we have designed a in depth Database Stats tool into your Site Control Panel. There you can see all–inclusive information regarding the arriving requests to your databases for each and every hour, day and month.

Depending on the volume of daily and hourly queries, it will be easy to find out which databases are being used the most and also take measures to enhance their load.