Databases Manager

Taking control of your databases is simpler than ever before, because of the Online Control Panel interface for MySQL and PgSQL administration! In case you do not have thorough knowledge of dealing with databases, you will find it easy to work with Web and Host Service’s Databases Manager.

You can create a whole new database just by specifying the username and security password or make a database backup with only a click of the mouse. Furthermore, through the Data Manager you’ll possess direct access to the administration area for each and every database, so its possible to effortlessly modify it.

We have evolved the manual database backup generation into a very easy activity. To execute this: in the Databases Manager, click on the ’clock’ icon near the database that you would like to back up and then wait around for a few seconds for the process to take place. Depending upon the size of your database, the generation of the back–up file will require between a couple of seconds and a minute.

You may make as many backups of a database as you wish. We’ve not specified any confines for the number of databases you can back up too.

Nearly all of our Linux shared hosting plans plans offer PgSQL support. Although falling behind MySQL with regard to level of popularity and utilization, PgSQL databases are renowned for supplying the highest level of protection for your site content and articles. That is the key reason why companies such as Skype and Yahoo use PgSQL databases as an alternative to MySQL.

In terms of database management, PgSQL is as easy to understand as MySQL.

The MySQL databases on our web servers use the most current build of the InnoDB storage engine. InnoDB has been meant to guarantee the maximum performance for web sites that process large amounts of data. It supplies CPU efficiency that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, which means that you’re able to update/insert/create/alter/drop many times for a single "operation" of your web application. In addition, it takes advantage of row–level locking in lieu of MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

We provide you a very easy route to observe the database use for your powerful web sites. Through the in depth database statistics interface, which is built into the Online Control Panel, it is possible to record the load made by your active sites in real time. The presented info will help you analyze the database load changes every hour, each day or on a monthly basis.

You can easily keep an eye on the database load for all your web sites within the Database Stats part of the Online Control Panel. The table onscreen presents the database lookups made within the present month. To inspect data for a previous month, just click on the back arrows situated at the top.