Databases Manager

Database management may appear like a complicated job to new cloud hosting users, however with our Databases Manager, it’s actually quite simple! To configure a brand new database, you only ought to provide the username and password. Database back–ups are simply a click away at the same time.Those who need to look into their databases and change them can use the phpMyAdmin and phpPgAdmin tools.

We’ve made the manual database backup generation into a quite easy job. To do so: inside the Databases Manager, click the ’clock’ icon next to the database that you intend to back up and then wait for a few seconds for the process to take place. Depending upon the size of the 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 copies of a database as you want. We’ve not determined any boundaries about the number of databases you can back up either.

PgSQL databases are much less famous than the popular MySQL databases. Even so, they represent a favored option for designers who seek the best stability for their websites and web applications. Thanks to the user–friendly Databases Manager incorporated into the Website Servers Control Panel, you can administer all your PostgreSQL databases with simply a click of the mouse.

You’ll find PgSQL databases bundled by default in the advanced shared plans packages. Provided that you are using a standard hosting package, it’s possible to ask for PgSQL databases to be added to your web hosting account as upgrades.

We’ve installed InnoDB – the brand new standard MySQL database engine on all of our web servers. InnoDB is perfect for substantial database sites which need high overall performance and scalability. Experiments demonstrate that sites employing InnoDB based tables reach a 3–fold operation grow for massive joins, in comparison to those utilizing MyISAM tables.

InnoDB works by using row–level locking as a way to eliminate effectiveness issues discovered at the top consumption times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load generated by the databases on your active web site will help you avoid all overload problems that might slow it down and chase away site visitors. For that reason, we’ve built–in a comprehensive Database Stats tool within the Web Hosting Control Panel. There you shall find comprehensive information about the incoming requests to your databases for every single hour, day and month.

In line with the volume of daily and per hour queries, you are going to be able to determine which databases are employed the most and also take steps to optimize their load.