Databases Manager

The Databases Manager within our Hosting Control Panel provides a robust but still simple to operate user interface. It is possible to set up a new MySQL or PostgreSQL database simply by specifying a username and security password. Also, you could make a backup file or alter the security password of a database with just a click of the mouse.

Through the Databases Manager you have immediate access to the administrative area for all of your databases, which means you can make simple and easy corrections if you happen to need to.

We’ve transformed the manual database back–up generation into a simple activity. To execute that: in the Databases Manager, click the ’clock’ image next to the database that you plan to back up and then wait for a couple of seconds for the process to take place. Depending upon the size of your database, the creation of the back–up file will require somewhere between a couple of seconds and a minute.

You may make as many copies of a database as you would like. We haven’t determined any boundaries on the volume of databases you can back up either.

You will find PgSQL support in all of our website hosting packages plans. PgSQL databases might not be as popular and frequently used as MySQL, but they deliver the greatest level of safety for your site content and articles. Due to this, many popular companies such as Skype and Yahoo work with PgSQL databases. Controlling PgSQL databases is as easy and simple as MySQL, on account of the user–friendly user interface of the Databases Manager.

PgSQL databases are provided by default within the most advanced web hosting bundles. For the basic plans, they are included as upgrades.

The MySQL databases on our machines utilize the most up–to–date release of the InnoDB storage engine. InnoDB has been meant to guarantee the max performance for websites that work with substantial volumes of data. It grants CPU effectiveness that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, meaning that it’s possible to update/insert/create/alter/drop repeatedly for one "operation" of your web app. Moreover, it uses row–level locking as an alternative for MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

We supply you a simple and easy way for you to keep track of the database usage for your busy sites. From your detailed database statistics user interface, that’s included in the Hosting Control Panel, it’s possible to keep an eye on the load accumulated through your active web sites in real time. The offered data will help you to evaluate the database load fluctuations each hour, each day or each month.

You’re able to monitor the database load for all your sites from the Database Stats area of the Hosting Control Panel. The table on–screen reveals the database lookups made within the present month. To assess data for a past month, click on the back arrows positioned at the top.