Database Manager

Supervising your databases is much simpler than in the past, because of the Hosting Control Panel interface for MySQL and PgSQL control! Even though you may not have extensive knowledge of making use of databases, it will be very easy to work with our Database Manager.

You may create a whole new database simply by specifying the username and password or generate a database back–up with a simple click of the mouse. Moreover, through the Data Manager you will possess direct access to the administration area for every database, to help you to effectively edit it.

We have changed the manual database back–up formation into a quite simple activity. To execute this: inside of the Database Manager, click the ’clock’ image near the database that you would like to back up and wait around for a couple of seconds for the process to take place. With regards to the size of the database, the generation of a backup file will take somewhere between a couple of seconds and a minute.

You can create as many backups of a database as you would like. We’ve not determined any limits for the amount of databases you could back up as well.

PgSQL databases are less common compared to the well–known MySQL databases. Having said that, they’re a favored choice for web developers seeking the uttermost stability for their sites and applications. Due to the easy–to–use Database Manager included in the WWW Solutions Control Panel, you can administer all your PostgreSQL databases with a click of the mouse.

Yow will discover PgSQL databases provided by default inside of the best Linux cloud hosting packages packages. If you are using a regular hosting package, you’re able to request PgSQL databases to be included in your cloud hosting account as upgrades.

We have incorporated InnoDB – the brand new standard MySQL database engine on all our servers. InnoDB is ideal for substantial database websites which need high general performance and scalability. Experiments demonstrate that websites utilizing InnoDB based tables attain a 3–fold general performance grow for very big joins, when compared to those applying MyISAM tables.

InnoDB utilizes row–level locking so as to eliminate the performance problems noticed at the high usage times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

We provide you a surprisingly simple method to keep an eye on the database usage for your powerful web sites. From the thorough database statistics interface, that is built into the Hosting Control Panel, it is possible to track the load made from your active sites in real time. The provided details will let you assess the database load changes every hour, each day or on a monthly basis.

It is easy to keep track of the database load for your websites within the Database Stats part of the Hosting Control Panel. The table on–screen features the database queries created in the present month. To have a look at details for an earlier month, click on the back arrows located at the top.