Databases Manager

Database management may sound like a hard task to inexperienced web hosting users, nevertheless with FAIHAD Hosting’s Databases Manager, it’s in fact reasonably easy! To set up a new database, you simply ought to provide your username and password. Database back–ups are a click away as well.Those who want to explore their databases and edit them may use the phpMyAdmin and phpPgAdmin tools.

With the Databases Manager you can produce an archived duplicate of your database when you want! This way, you will always have a backup of your active content material in the event your site gets compromised or if you accidentally remove a database. To produce a backup: click on the ’clock’ image beside a particular database and after that wait for a few seconds for the backup process to be finalized.

There are no restricts on the quantity of databases you can back up or the volume of back–ups you can create for any database.

You can find PgSQL support in every one of our Linux shared hosting service plans. PgSQL databases aren’t as well–known and frequently used as MySQL, nonetheless they offer the best level of stability for your web site content. Because of this, a number of widely known companies like Skype and Yahoo implement PgSQL databases. Managing PgSQL databases is as simple as MySQL, as a result of the user–friendly interface of the Databases Manager.

PgSQL databases are included by default with the most innovative web hosting bundles. For the normal plans, they are included as upgrades.

We have set up InnoDB – the new standard MySQL database engine on our servers. InnoDB is good for substantial database web sites which require high overall performance and scalability. Tests have shown that web sites utilizing InnoDB based tables achieve a 3–fold overall performance boost for significant joins, as compared to those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to eliminate effectiveness difficulties witnessed at the peak usage times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

Checking the load made by the databases in your powerful web site assists you to avoid all sorts of overload difficulties that might slow it down and chase away site visitors. For this specific purpose, we have built–in a in–depth Database Stats tool within the Web Hosting Control Panel. There you will find comprehensive info about the arriving requests to your databases for every single hour, day and month.

Using the number of day–to–day and per hour queries, it’s possible to find out which databases are utilized the most and also consider procedures to optimize their load.