Database Manager

Database management may sound like a difficult task to inexperienced hosting users, but with A2ZWebDesigner.com’s Database Manager, it’s in fact pretty simple! To set up a brand new database, you just have to key in the username and password. Database back–ups are a click away at the same time.Those who want to examine their databases and also modify them are able to use the phpMyAdmin and phpPgAdmin tools.

Assuming you have dealt with databases, you already know that generating a manual database back–up is not a simple task. So as to change this, we’ve created very simple tool that will back up your entire database with merely one click of the mouse. The back–up file will be prepared for you in less than a minute, with regards to the size of the selected database.

There aren’t any limitations on the total number of backups you can create for a chosen database.

You are going to find PgSQL support in every one of our Linux shared web hosting packages plans. PgSQL databases may not be as famous and commonly used as MySQL, however they supply the maximum level of protection for your web site content. Therefore, several popular businesses like Skype and Yahoo work with PgSQL databases. Taking care of PgSQL databases is as easy and simple as MySQL, thanks to the intuitive user interface of the Database Manager.

PgSQL databases are integrated automatically within the most innovative web hosting bundles. For the normal bundles, they are offered as upgrades.

We have installed InnoDB – the brand new default MySQL database engine on our web servers. InnoDB is great for significant database sites that demand high levels of overall performance and scalability. Trials have indicated that web sites employing InnoDB based tables attain a 3–fold effectiveness increase for very large joins, in comparison with those applying MyISAM tables.

InnoDB uses row–level locking in order to eliminate the operation difficulties discovered at the peak consumption times of the previous release of the database engine – MyISAM, which uses table–level locking.

A2ZWebDesigner.com offers you an easy method to track the database usage on your dynamic websites. Through the detailed database statistics user interface, which is integrated into the Control Panel, you can easily monitor the load accumulated from your active web sites in real time. The displayed data will let you evaluate the database load fluctuations every hour, per day or monthly.

You can keep track of the database load for all your websites from the Database Stats area of the Control Panel. The table onscreen reveals the database lookups accumulated during the present month. To assess info for a previous month, click on the back arrows situated at the top.