Database Manager

The Database Manager in the Control Panel has an effective nevertheless simple to use interface. You can easily configure a new MySQL or PostgreSQL database by just typing a user name and security password. Moreover, you could make a backup file or customize the security password of any database with only a click of the mouse.

Within the Database Manager you will possess direct access to the admin area for all of your databases, allowing you to make easy modifications if you ever need to.

Within the Database Manager it is easy to produce an archived backup of your database whenever you want! This way, you’ll always have a backup of your active information in case your website gets compromised or you erroneously erase a database. To produce a backup: click on the ’clock’ image next to a particular database and then simply wait for a few seconds for the process to be completed.

There are not any restrictions about the number of databases you would be able to back up or the number of back–ups you can create for any database.

Practically all of our shared hosting packages present PgSQL support. Although falling behind MySQL in terms of acceptance and utilization, PgSQL databases are famous for delivering the top level of stability for your website content. That’s the main reason why businesses like Skype and Yahoo rely upon PgSQL databases rather than MySQL.

With regards to database administration, PgSQL is just as easy to use as MySQL.

We have installed InnoDB – the new standard MySQL database engine on each of our machines. InnoDB is made for substantial database sites which require high levels of efficiency and scalability. Experiments have revealed that web sites working with InnoDB based tables reach a 3–fold functionality boost for large joins, in comparison to those making use of MyISAM tables.

InnoDB employs row–level locking so as to eliminate the operation issues found at the top consumption times of the prior version of the database engine – MyISAM, which employs table–level locking.

Keeping tabs on the load caused by the databases in your powerful web site makes it possible to reduce virtually any overload troubles that might slow it down and ward off visitors. For this specific purpose, we have integrated a in–depth Database Stats tool inside the Control Panel. There you can see thorough info on the inbound requests to your databases for each and every hour, day and month.

In line with the volume of day–to–day and by the hour queries, it will be straightforward to find out what databases are employed the most and also consider steps to optimize their work.