Databases Manager

Supervising your databases is much simpler than before, on account of the Web Hosting Control Panel interface for MySQL and PgSQL control! Assuming you do not have detailed knowledge in managing databases, it will be an easy task to manage our Databases Manager.

You may create a new database just by specifying the username and password or produce a database backup with just a click of the mouse. Moreover, within the Data Manager you will get direct access to the management area for each and every database, which enables you to effectively manage it.

We have changed the manual database back–up generation into a very easy task. To execute this: inside of the Databases Manager, click the ’clock’ symbol beside the database that you plan to back up and afterwards wait for a few seconds for the process to take place. With respect to the size of the database, the creation of a back–up file will take somewhere between a few seconds and a minute.

You may create as many backups of a database as you would like. We have not specified any limitations on the amount of databases you can back up too.

PgSQL databases are much less famous when compared to the standard MySQL databases. However, they’re a favored selection for web developers who seek the uttermost protection for their sites and applications. Due to the easy–to–use Databases Manager built–into the AngelStarHosting Control Panel, you can manage all of your PostgreSQL databases with only a mouse click.

You can find PgSQL databases integrated by default inside the top Linux shared hosting packages. Assuming that you are using a basic hosting package, you can easily request PgSQL databases to be added to your hosting account as upgrades.

With AngelStarHosting, you will invariably discover the most current release of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is more stable when compared to the past storage engine’s version – MyISAM. It’s ACID–compliant and, most significantly – it gives 100% transaction support. In addition, it uses row–level locking, as a substitute for MyISAM’s table–level locking, that would always trigger functionality troubles at high usage periods.

Keeping tabs on the load accumulated by the databases within your dynamic web site assists you to stop all sorts of overload troubles that might slow it down and ward off website visitors. Therefore, we’ve designed a detailed Database Stats tool into your Web Hosting Control Panel. There you can find in depth info about the incoming requests to your databases for each and every hour, day and month.

In line with the amount of daily and per hour queries, it is possible to determine which databases are used the most as well as consider steps to enhance their load.