Database Manager

The Database Manager inside the Web Hosting Control Panel features a robust but uncomplicated interface. You can set up a completely new MySQL or PostgreSQL database by simply typing a username and password. What’s more, you may create a backup file or customize the security password of an database with just a click of the mouse.

Within the Database Manager you will possess immediate access to the administration area for every one of your databases, which enables you to make uncomplicated alterations when you need to.

We’ve evolved the manual database backup formation into a quite easy activity. To do so: inside the Database Manager, click on the ’clock’ image on the side of the database that you plan to back up and then hang on for a few seconds for the process to take place. With regards to the size of the database, the building of a backup file will need somewhere between a few seconds and a minute.

You may make as many backup copies per database as you wish. We’ve not specified any limits about the volume of databases that you can back up either.

Almost all of StarterWebhosting.com’s Linux hosting packages offer PgSQL support. Although falling behind MySQL regarding level of popularity and employment, PgSQL databases are famous for offering the top level of stability for your site content. That is the primary reason why companies such as Skype and Yahoo employ PgSQL databases in lieu of MySQL.

When it comes to database administration, PgSQL is identically uncomplicated as MySQL.

We have incorporated InnoDB – the brand new default MySQL database engine on our web servers. InnoDB is perfect for sizeable database web sites that demand high levels of functionality and scalability. Trials have indicated that websites employing InnoDB based tables attain a 3–fold general performance increase for very big joins, when compared with those making use of MyISAM tables.

InnoDB makes use of row–level locking so as to clear away the performance problems discovered at the high consumption times of the earlier variant of the database engine – MyISAM, which employs table–level locking.

Keeping track of the load accumulated by the databases for your dynamic site will let you prevent all sorts of overload troubles that could slow it down and ward off site visitors. For that reason, we’ve integrated a in depth Database Stats tool directly into the Web Hosting Control Panel. There you shall find thorough info on the arriving requests to your databases for every hour, day and month.

In line with the amount of daily and by the hour queries, it’s possible to find out what databases are being used the most as well as consider actions to enhance their load.