Database Manager

Database management may sound like a hard task to novice web hosting customers, but with our Database Manager, it’s in fact simple! To set up a new database, you only ought to enter in the username and password. Database back–ups are simply a mouse click away on top of that.People that choose to look into their databases and update them are able to use the phpMyAdmin and phpPgAdmin tools.

We have designed the manual database back–up formation into a very simple job. To execute this: inside of the Database Manager, click on the ’clock’ icon on the side of the database that you plan to back up and afterwards wait around for a couple of seconds for the process to take place. With regards to the size of the database, the creation of the back–up file can take somewhere between a few seconds and a minute.

You can make as many back–ups per database as you want. We have not specified any limitations on the number of databases you could back up either.

Nearly all of our cloud website hosting plans bundles feature PgSQL support. Although dropping behind MySQL when considering global recognition and utilization, PgSQL databases are famous for supplying the top level of protection for your web site content. This is the main reason why companies like Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.

In terms of database administration, PgSQL is equally straightforward as MySQL.

We have incorporated InnoDB – the new default MySQL database engine on all of our web servers. InnoDB is great for sizeable database websites which need high levels of effectiveness and scalability. Trials show that websites working with InnoDB based tables attain a 3–fold performance grow for large joins, when compared to those utilizing MyISAM tables.

InnoDB uses row–level locking in an effort to clear away the general performance difficulties discovered at the peak consumption times of the previous version of the database engine – MyISAM, which employs table–level locking.

Tracking the load generated by the databases in your powerful site assists you to avoid any sort of overload issues that could slow it down and chase away website visitors. For this specific purpose, we’ve integrated a descriptive Database Stats tool inside the Web Control Panel. There you can find broad info on the incoming requests to your databases for each hour, day and month.

Using the quantity of day–to–day and per hour queries, you will be able to find out which databases are employed the most and then take procedures to optimize their work.