Database Manager

The Database Manager inside our Website Control Panel incorporates a powerful but still intuitive user interface. You are able to set up a new MySQL or PostgreSQL database by just specifying a username and security password. Moreover, you could make a back–up file or alter the security password of your database with only a mouse click.

Via the Database Manager you’ll possess immediate access to the administrative area for all your databases, so you’re able to make hassle–free changes in the event you need to.

Through the Database Manager it is simple to make an archived copy of your database anytime you desire! For this reason, you’ll always have a data backup of your active content material in case your website gets compromised or you erroneously delete a database. To create a backup: click on the ’clock’ symbol next to any database and then just wait for a couple of seconds for the process to be done.

There are no boundaries for the quantity of databases you can back up or the number of backup copies you may make for any database.

A majority of the shared website hosting plans feature PgSQL support. Whilst falling behind MySQL regarding reputation and utilization, PgSQL databases are renowned for delivering the top level of safety for your web site content material. This is the key reason why businesses like Skype and Yahoo rely upon PgSQL databases as a substitute for MySQL.

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

We’ve set up InnoDB – the new standard MySQL database engine on each of our web servers. InnoDB is made for huge database sites that need high overall performance and scalability. Experiments demonstrate that websites utilizing InnoDB based tables reach a 3–fold functionality increase for massive joins, in comparison to those working with MyISAM tables.

InnoDB makes use of row–level locking in order to be able to eliminate effectiveness difficulties spotted at the peak consumption times of the earlier release of the database engine – MyISAM, which employs table–level locking.

Checking the load made by the databases within your dynamic site will help you avoid any sort of overload troubles that can slow it down and ward off visitors. Therefore, we have incorporated a thorough Database Stats tool into the Website Control Panel. There you shall find detailed information about the arriving requests to your databases for each hour, day and month.

Depending on the amount of daily and hourly queries, it will be straightforward to find out which databases are employed the most and also take actions to optimize their load.