Database Manager

Supervising your databases is much easier than ever, on account of the Web Control Panel interface for MySQL and PgSQL administration! Even if you do not have thorough knowledge of dealing with databases, you will find it very easy to work with the Database Manager.

You could make a completely new database just by keying in the username and security password or generate a database backup with merely a click of the mouse. Also, from the Data Manager you’ll have direct access to the admin area for every database, so that you can quickly revise it.

Within the Database Manager you can easily make an archived backup of your database when you want! For this reason, you are going to always have a back–up of your active content material in case your site gets hacked or if you mistakenly remove a database. To produce a back–up: click the ’clock’ icon next to a given database and then just wait for a couple of seconds for the backup process to be performed.

There aren’t any restricts for the volume of databases you are able to back up or the number of back–ups you can make for any database.

A lot of our Linux cloud hosting bundles offer PgSQL support. While falling behind MySQL when considering acceptance and utilization, PgSQL databases are renowned for presenting the maximum level of stability for your web site content material. That’s the main reason why brands like Skype and Yahoo employ PgSQL databases in lieu of MySQL.

With respect to database administration, PgSQL is equally uncomplicated as MySQL.

We’ve added InnoDB – the brand new default MySQL database engine on all of our machines. InnoDB is good for substantial database sites that need high efficiency and scalability. Experiments show that web sites working with InnoDB based tables achieve a 3–fold general performance grow for huge joins, as opposed to those utilizing MyISAM tables.

InnoDB makes use of row–level locking so as to take away the operation difficulties observed at the maximum consumption times of the prior release of the database engine – MyISAM, which uses table–level locking.

Our company offers you an effortless solution to track the database utilization of your powerful web sites. From the in–depth database statistics user interface, which is built–into the Web Control Panel, you’re able to observe the load created by your dynamic websites in real time. The delivered data will let you evaluate the database load fluctuations on an hourly basis, each day or per month.

It is easy to track the database load for all of your sites within the Database Stats part of the Web Control Panel. The table on–screen presents the database queries accumulated during the present month. To have a look at info for a previous month, just click on the back arrows placed at the top.