Databases Manager

The Databases Manager in our Site Control Panel includes a refined nevertheless intuitive interface. You can set up a completely new MySQL or PostgreSQL database by just entering a user name and password. Also, you could make a backup file or modify the password of an database with a mouse click.

With the Databases Manager you will possess immediate access to the admin area for every one of your databases, so that you can make easy changes when you have to.

We have transformed the manual database backup creation into a simple job. To execute this: within the Databases Manager, click the ’clock’ image on the side of the database that you would like to back up and wait for a few seconds for the backup process to take place. With regards to the size of the database, the building of a back–up file is going to take between a couple of seconds and a minute.

You may make as many backup copies of a database as you would like. We’ve not set any restrictions on the number of databases you can back up as well.

A majority of the shared hosting plans deliver PgSQL support. Although falling behind MySQL when it comes to level of popularity and application, PgSQL databases are famous for offering up the greatest level of safety for your website content and articles. This is the main reason why companies such as Skype and Yahoo employ PgSQL databases and not MySQL.

With regards to database administration, PgSQL is as simple as MySQL.

The MySQL databases on our servers employ the most current release of the InnoDB storage engine. InnoDB has been intended to ensure the highest possible functionality for web sites that work with substantial amounts of data. It supplies CPU efficiency that could not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, which means that it’s possible to update/insert/create/alter/drop more than once for one "operation" of your application. In addition, it works by using row–level locking in place of MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

Keeping tabs on the load made by the databases on your busy web site assists you to stop all kinds of overload difficulties that might slow it down and chase away visitors. As a result, we have integrated a in depth Database Stats tool inside the Site Control Panel. There you will find in depth information regarding the inbound requests to your databases for each hour, day and month.

In line with the volume of day–to–day and per hour queries, it will be straightforward to find out what databases are employed the most and take procedures to optimize their load.