Databases Manager

Database management may appear like a difficult task to unskilled web hosting customers, however with the Databases Manager, it’s in fact really simple! To make a whole new database, you just need to type in the username and password. Database back–ups are a click away too.People that need to examine their databases and then revise them may use the phpMyAdmin and phpPgAdmin tools.

If you have dealt with databases, you know generating a manual database backup is not really a basic task. So as to change this, we have created a simple and easy to use tool that can back up the entire database with simply a single click. The back–up file is going to be ready for you in less than a minute, based on the size of the selected database.

You won’t notice any limitations on the amount of copies you can make for a chosen database.

PgSQL databases are much less sought after in comparison to the common MySQL databases. However, they are a preferred selection for programmers who seek the greatest security for their sites and applications. Thanks to the user–friendly Databases Manager incorporated into the Webbia Control Panel, you can control your PostgreSQL databases with a simple click of the mouse.

You can find PgSQL databases bundled by default inside of the best Linux shared hosting packages. In case you are with a regular hosting package, it is easy to ask for PgSQL databases to be included in your web hosting account as upgrades.

We have installed InnoDB – the new standard MySQL database engine on all of our machines. InnoDB is great for significant database web sites which need high levels of functionality and scalability. Tests have indicated that websites employing InnoDB based tables attain a 3–fold effectiveness boost for substantial joins, as compared with those working with MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to eliminate operation issues noticed at the high consumption times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load generated by the databases on your busy web site assists you to stop any overload issues that could slow it down and chase away website visitors. For that reason, we have built–in a descriptive Database Stats tool in the Online Control Panel. There you shall find broad info about the incoming requests to your databases for every single hour, day and month.

Using the number of day–to–day and per hour queries, you are able to find out what databases are employed the most and then consider procedures to enhance their work.