Database Manager

Database management may seem like a complicated job to inexperienced web hosting clients, but with the Database Manager, it’s in fact relatively easy! To configure a whole new database, you only have to provide the username and password. Database backup copies are simply a mouse click away as well.People who need to explore their databases and also update them can make use of the phpMyAdmin and phpPgAdmin tools.

Within the Database Manager you can easily generate an archived copy of your database whenever you desire! Thus, you will always have a backup of your operating content if your website gets hacked or if you accidentally delete a database. To create a backup: click on the ’clock’ image beside a certain database and then wait for a couple of seconds for the process to be executed.

There are not any confines for the amount of databases you are able to back up or the number of backups you can create for a database.

You’re going to find PgSQL support in all of our Linux hosting packages. PgSQL databases might not be as well–known and frequently used as MySQL, nonetheless they provide the top level of security for your web site content. For this reason, a number of well–known companies like Skype and Yahoo make use of PgSQL databases. Maintaining PgSQL databases is as easy and simple as MySQL, thanks to the user–friendly interface of the Database Manager.

PgSQL databases are bundled by default within the most sophisticated web hosting plans. For the regular packages, they are featured as upgrades.

The MySQL databases on Web Developer Express’s servers utilize the most up–to–date release of the InnoDB storage engine. InnoDB has been designed to ensure the optimum effectiveness for web sites that operate with huge volumes of data. It presents CPU effectiveness that can not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides full transaction support, so that you are able to update/insert/create/alter/drop a couple of times for a single "operation" of your application. Furthermore, it uses row–level locking in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

Keeping tabs on the load made by the databases in your busy website makes it possible to prevent virtually any overload troubles that can slow it down and chase away site visitors. As a result, we have provided a comprehensive Database Stats tool inside the Website Control Panel. There you can get all–encompassing information about the inbound requests to your databases for each and every hour, day and month.

Depending on the amount of day–to–day and per hour queries, it is possible to find out which databases are being used the most as well as consider measures to optimize their work.