Databases Manager

The Databases Manager within our Site Control Panel features a robust yet convenient to use user interface. It is easy to configure a completely new MySQL or PostgreSQL database by just typing in a username and security password. Moreover, you can make a backup file or customize the password of the database with simply a mouse click.

From the Databases Manager you’ll possess direct access to the admin area for every one of your databases, allowing you to make convenient changes should you need to.

We have transformed the manual database back–up generation into a quite easy job. To execute this: inside the Databases Manager, click the ’clock’ image beside the database that you want to back up and then wait for a few seconds for the process to take place. With regards to the size of the database, the building of any back–up file will need somewhere between a couple of seconds and a minute.

You can make as many backups per database as you wish. We haven’t set any restrictions for the number of databases you can back up as well.

You are going to find PgSQL support in all of our Linux shared packages packages. PgSQL databases are not as well–known and commonly used as MySQL, nonetheless they provide you with the highest possible level of safety for your web site content. Therefore, a number of well–known businesses like Skype and Yahoo work with PgSQL databases. Controlling PgSQL databases is as easy and simple as MySQL, on account of the easy–to–use user interface of the Databases Manager.

PgSQL databases are incorporated by default with the most innovative web hosting packages. For the standard plans, they’re offered as upgrades.

We’ve integrated InnoDB – the brand new standard MySQL database engine on each of our web servers. InnoDB is good for sizeable database websites which require high overall performance and scalability. Experiments have shown that websites applying InnoDB based tables reach a 3–fold overall performance boost for large joins, in comparison with those applying MyISAM tables.

InnoDB works by using row–level locking so as to eliminate the functionality issues witnessed at the high usage times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

We offer you a fairly easy solution to observe the database usage for your active web sites. From your detailed database statistics interface, that is built–into the Site Control Panel, you are able to monitor the load made from your dynamic web sites in real time. The offered details will help you analyze the database load fluctuations every hour, every day or per month.

You can keep an eye on the database load for all of your sites in the Database Stats section of the Site Control Panel. The table on–screen reveals the database queries generated during the present month. To examine details for a previous month, just click on the back arrows positioned at the top.