Databases Manager

Overseeing your databases is much simpler than in the past, on account of the Online Control Panel interface for MySQL and PgSQL control! Even though you may not have considerable experience of working with databases, you will find it easy to work with our Databases Manager.

You can make a new database by simply typing the user name and security password or produce a database back–up with merely a click of the mouse. At the same time, via the Data Manager you will have direct access to the administrative area for every database, so you’re able to effortlessly edit it.

We have transformed the manual database backup formation into a quite simple task. To do this: within the Databases Manager, click the ’clock’ image on the side of the database that you intend to back up and afterwards wait for a couple of seconds for the process to take place. Depending on the size of your database, the generation of a backup file will take between a couple of seconds and a minute.

You can make as many backup copies of a database as you would like. We’ve not fixed any restrictions about the volume of databases that you can back up either.

Almost all of the shared website hosting packages offer PgSQL support. While dropping behind MySQL with regards to level of popularity and application, PgSQL databases are renowned for offering the top level of security for your web site content and articles. This is the basic reason why brands like Skype and Yahoo employ PgSQL databases rather than MySQL.

With regard to database management, PgSQL is equally simple as MySQL.

We’ve incorporated InnoDB – the brand new standard MySQL database engine on all of our machines. InnoDB is great for huge database sites which require high efficiency and scalability. Tests have established that websites using InnoDB based tables attain a 3–fold efficiency boost for large joins, when compared to those applying MyISAM tables.

InnoDB makes use of row–level locking in order to be able to remove the effectiveness problems discovered at the maximum usage times of the prior version of the database engine – MyISAM, which uses table–level locking.

We offer you an uncomplicated solution to observe the database use for your powerful web sites. Via the descriptive database stats user interface, that’s built–into the Online Control Panel, you’ll be able to keep an eye on the load generated through your dynamic websites in real time. The delivered information will allow you to analyze the database load variations every hour, daily or monthly.

You are able to monitor the database load for your web sites from the Database Stats area of the Online Control Panel. The table onscreen features the database lookups generated during the present month. To inspect details for a previous month, all you have to do is click on the back arrows positioned at the top.