Database Manager

Supervising your databases is simpler than before, because of the Web Control Panel user interface for MySQL and PgSQL management! Assuming you do not have detailed experience of handling databases, you will find it effortless to deal with the Database Manager.

You can make a new database by just keying in the username and security password or produce a database backup with a mouse click. Also, through the Data Manager you will get direct access to the administrator area for every database, which enables you to immediately edit it.

From the Database Manager you can produce an archived copy of your database whenever you would like! This way, you are going to always have a data backup of your active content in case your website gets compromised or if you mistakenly delete a database. To create a back–up: click the ’clock’ symbol alongside any database and afterwards wait for a couple of seconds for the process to be executed.

There aren’t any limits about the amount of databases you can back up or the volume of backup copies you can make for a database.

PgSQL databases are much less famous than the common MySQL databases. Nevertheless, they’re a favorite choice for designers who are looking for the utmost safety for their sites and web apps. Through the incredibly user–friendly Database Manager built–into the webstore-4u Control Panel, you can control all your PostgreSQL databases with a simple click of the mouse.

Yow will discover PgSQL databases included automatically inside the best Linux website hosting packages. Provided that you are with a regular hosting package, it’s possible to request PgSQL databases to be added in your web hosting account as upgrades.

We’ve set up InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is designed for big database websites that need high levels of functionality and scalability. Experiments have demonstrated that web sites utilizing InnoDB based tables attain a 3–fold effectiveness increase for substantial joins, compared to those making use of MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to clear away the functionality issues witnessed at the maximum usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Checking the load caused by the databases for your powerful site makes it possible to stop all sorts of overload issues that might slow it down and chase away visitors. For that reason, we have built in a complete Database Stats tool within the Web Control Panel. There you can see all–encompassing information about the incoming requests to your databases for each and every hour, day and month.

In line with the number of daily and per hour queries, it will be easier to find out which databases are used the most and then consider procedures to enhance their work.