Database Manager

Taking control of your databases is simpler than ever, as a result of Site Control Panel user interface for MySQL and PgSQL administration! Provided you do not have detailed experience in managing databases, it will be effortless to manage the Database Manager.

You could make a new database simply by entering the user name and security password or produce a database back–up with merely a click of the mouse. Also, through the Data Manager you’ll have direct access to the management area for every database, which enables you to immediately modify it.

Within the Database Manager it’s easy to produce an archived duplicate of your database when you desire! This way, you are going to always have a backup of your dynamic content material in the event your web site gets hacked or you accidentally delete a database. To generate a back–up: click the ’clock’ image on the side of a given database and then simply wait for a few seconds for the process to be concluded.

There won’t be any limitations on the volume of databases you can back up or the amount of back–ups you may make for a database.

The majority of Webjalebihosting.com’s Linux hosting plans packages provide PgSQL support. Although falling behind MySQL with regard to popularity and employment, PgSQL databases are renowned for supplying the best level of safety for your site content. It is the primary reason why companies like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

With regard to database administration, PgSQL is just as easy to understand as MySQL.

We have installed InnoDB – the brand new standard MySQL database engine on all our machines. InnoDB is ideal for sizeable database websites that demand high efficiency and scalability. Tests show that websites making use of InnoDB based tables reach a 3–fold overall performance boost for huge joins, when compared with those applying MyISAM tables.

InnoDB employs row–level locking so as to get rid of the functionality problems observed at the peak consumption times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load produced by the databases on your active website will help you avoid all overload issues that could slow it down and ward off website visitors. For this specific purpose, we’ve incorporated a descriptive Database Stats tool into the Site Control Panel. There you can get all–encompassing information about the incoming requests to your databases for each and every hour, day and month.

In line with the number of day–to–day and by the hour queries, you are going to be able to determine which databases are utilized the most and also take actions to optimize their load.