Database Manager

Database management may appear like a complicated job to novice hosting customers, however with the Database Manager, it’s in fact quite simple! To set up a new database, you only have to provide the username and password. Database backup copies are a click away too.People that want to look into their databases and then modify them can make use of the phpMyAdmin and phpPgAdmin tools.

With the Database Manager it’s possible to create an archived duplicate of your database whenever you wish! That way, you’ll always have a back–up of your active content material in the event your web site gets hacked or you accidentally get rid of a database. To create a back–up: click on the ’clock’ symbol beside a certain database and then just wait for a couple of seconds for the backup process to be concluded.

There are no confines on the number of databases you are able to back up or the volume of back–ups you can create for a database.

Most of the shared web hosting plans deliver PgSQL support. Although falling behind MySQL when considering popularity and utilization, PgSQL databases are renowned for providing the top level of security for your website content. It is the basic reason why brands like Skype and Yahoo make use of PgSQL databases instead of MySQL.

In relation to database management, PgSQL is as simple as MySQL.

We have set up InnoDB – the new default MySQL database engine on our machines. InnoDB is made for large database web sites that need high levels of general performance and scalability. Tests have shown that web sites working with InnoDB based tables reach a 3–fold overall performance boost for big joins, in comparison with those using MyISAM tables.

InnoDB uses row–level locking as a way to take away the efficiency issues observed at the top usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load accumulated by the databases in your powerful web site will help you reduce all kinds of overload difficulties that could slow it down and ward off site visitors. For this specific purpose, we have incorporated a in–depth Database Stats tool in the Online Control Panel. There you can see all–inclusive info about the inbound requests to your databases for every hour, day and month.

Based on the amount of day–to–day and per hour queries, you’ll be able to determine which databases are used the most and then consider steps to optimize their work.