Database Manager

Taking control of your databases is much simpler than in the past, as a result of Hosting Control Panel interface for MySQL and PgSQL control! In case you do not have detailed knowledge in making use of databases, it will be very easy to work with the Database Manager.

You can create a completely new database by simply specifying the username and security password or create a database backup with a click of the mouse. At the same time, with the Data Manager you’ll get direct access to the administrator area for every single database, meaning you can immediately alter it.

We’ve evolved the manual database back–up generation into a quite simple activity. To execute this: inside the Database Manager, click on the ’clock’ icon beside the database that you would like to back up and wait for a couple of seconds for the backup process to take place. With regards to the size of the database, the generation of any back–up file can take somewhere between a few seconds and a minute.

You may create as many backups of a database as you want. We’ve not determined any confines for the quantity of databases that you can back up too.

Just about all of webmailserver’s Linux website hosting packages bundles provide PgSQL support. Although dropping behind MySQL with regards to popularity and usage, PgSQL databases are famous for presenting the maximum level of safety for your web site content. This is the basic reason why businesses like Skype and Yahoo go with PgSQL databases instead of MySQL.

When considering database administration, PgSQL is identically quick as MySQL.

We’ve installed InnoDB – the new standard MySQL database engine on all of our machines. InnoDB is good for large database sites that demand high efficiency and scalability. Tests have shown that websites employing InnoDB based tables reach a 3–fold performance increase for very large joins, as compared with those applying MyISAM tables.

InnoDB utilizes row–level locking in an effort to remove the overall performance issues spotted at the top usage times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

Monitoring the load produced by the databases for your powerful site will help you prevent all sorts of overload issues that could slow it down and chase away site visitors. For that reason, we have built–in a in–depth Database Stats tool directly into the Hosting Control Panel. There you can see in depth info about the incoming requests to your databases for each and every hour, day and month.

Depending on the volume of day–to–day and hourly queries, you are going to be able to find out what databases are used the most and also consider actions to enhance their work.