Databases Manager

Taking control of your databases is simpler than before, because of the Online Control Panel user interface for MySQL and PgSQL administration! Even if you do not have thorough expertise in making use of databases, you will find it very easy to handle Balaji Webhosting’s Databases Manager.

You can make a new database by just typing the user name and security password or make a database back–up with a simple mouse click. At the same time, from the Data Manager you have direct access to the administrative area for every single database, so its possible to effectively revise it.

We have transformed the manual database back–up formation into a quite simple job. To execute that: inside the Databases Manager, click on the ’clock’ image near the database that you intend to back up and wait for a couple of seconds for the backup process to take place. Depending upon the size of the database, the building of any backup file will require between a few seconds and a minute.

You can create as many backup copies of a database as you want. We’ve not specified any limitations on the amount of databases that you can back up as well.

A lot of Balaji Webhosting’s Linux cloud packages bundles grant PgSQL support. While dropping behind MySQL regarding global recognition and employment, PgSQL databases are famous for delivering the maximum level of safety for your site content material. It is the basic reason why businesses like Skype and Yahoo make use of PgSQL databases as opposed to MySQL.

In relation to database administration, PgSQL is equally easy to understand as MySQL.

The MySQL databases on Balaji Webhosting’s machines use the most current release of the InnoDB storage engine. InnoDB was developed to guarantee the top functionality for sites that deal with large volumes of data. It provides CPU efficiency that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, which means you can update/insert/create/alter/drop many times for a single "operation" of your web app. In addition, it works by using row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

From the in–depth database statistics tool built–into the Online Control Panel, it’s possible to make a record of the stress generated by your dynamic sites around the clock. Virtually any overload issue with your websites could slow the loading rates and have a negative impact on the overall experience of your respective site visitors. Thus, having info for the database work in real time, you’ll be able to fix overload difficulties at once.

The database data user interface displays info of the amount of daily, hourly and monthly lookups, in order to evaluate how the load is allocated over various time periods.