Database Manager

The Database Manager in our Web Control Panel contains a powerful but simple to operate interface. It is possible to set up a completely new MySQL or PostgreSQL database by just typing in a username and security password. Additionally, you can create a back–up file or change the security password of your database with merely a mouse click.

From the Database Manager you will have direct access to the admin area for all your databases, which enables you to make convenient changes if you happen to have to.

Through the Database Manager you can make an archived copy of your database anytime you desire! Therefore, you will always have a back–up of your dynamic content material in case your website gets hacked or if you incorrectly get rid of a database. To create a back–up: click on the ’clock’ icon beside any database and afterwards simply wait for a couple of seconds for the process to be finalized.

There aren’t any limitations for the volume of databases you are able to back up or the volume of backups you may make for any database.

A lot of our Linux website hosting packages packages deliver PgSQL support. Whilst dropping behind MySQL with regard to global recognition and application, PgSQL databases are famous for presenting the top level of stability for your web site content. This is the primary reason why brands like Skype and Yahoo use PgSQL databases rather than MySQL.

In relation to database management, PgSQL is as hassle–free as MySQL.

We have set up InnoDB – the brand new standard MySQL database engine on all of our web servers. InnoDB is designed for significant database web sites which need high general performance and scalability. Trials indicate that web sites working with InnoDB based tables achieve a 3–fold operation grow for big joins, in comparison with those applying MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to get rid of the performance problems noticed at the top consumption times of the earlier version of the database engine – MyISAM, which uses table–level locking.

Tracking the load generated by the databases within your dynamic web site will let you prevent any sort of overload difficulties that can slow it down and chase away website visitors. For this specific purpose, we have built–in a complete Database Stats tool directly into the Web Control Panel. There you will find all–encompassing info on the inbound requests to your databases for every hour, day and month.

Depending on the volume of day–to–day and by the hour queries, it will be easier to find out which databases are utilized the most and take measures to enhance their load.