Database Manager

The Database Manager inside our Web Site Control Panel has a refined but still user friendly user interface. You are able to configure a brand new MySQL or PostgreSQL database by simply entering a username and password. Additionally, you may create a backup file or modify the password of your database with just a mouse click.

With the Database Manager you’ll have immediate access to the administrator area for every one of your databases, so that you can make easy modifications if you happen to need to.

We’ve transformed the manual database backup creation into a quite simple activity. To do this: in the Database Manager, click on the ’clock’ icon beside the database that you would like to back up and hang on for a couple of seconds for the process to take place. With regards to the size of your database, the creation of a backup file is going to take somewhere between a couple of seconds and a minute.

You can create as many back–ups of a database as you wish. We have not fixed any confines about the volume of databases that you can back up too.

A lot of the Linux shared web hosting services bundles feature PgSQL support. While falling behind MySQL when considering global recognition and utilization, PgSQL databases are renowned for providing the best level of stability for your web site content. This is the primary reason why companies such as Skype and Yahoo make use of PgSQL databases instead of MySQL.

With regard to database management, PgSQL is equally simple and easy as MySQL.

The MySQL databases on our servers make use of the most up–to–date release of the InnoDB storage engine. InnoDB has been intended to ensure the maximum effectiveness for websites that work with massive amounts of data. It offers CPU efficiency that could not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, which means that you are able to update/insert/create/alter/drop many times for a single "operation" of your application. Also, it utilizes row–level locking rather than MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

Keeping tabs on the load generated by the databases for your active website will let you reduce virtually any overload difficulties that might slow it down and ward off website visitors. Therefore, we’ve bundled a comprehensive Database Stats tool within the Web Site Control Panel. There you can get comprehensive information regarding the arriving requests to your databases for each hour, day and month.

In line with the amount of day–to–day and per hour queries, you will be able to find out which databases are used the most and then take procedures to optimize their load.