Databases Manager

The Databases Manager in our Site Control Panel has a robust nevertheless convenient to use interface. You can set up a completely new MySQL or PostgreSQL database simply by typing a username and security password. Also, you can create a backup file or alter the security password of any database with simply a mouse click.

With the Databases Manager you’ll get direct access to the management area for every one of your databases, allowing you to make effortless adjustments if you happen to need to.

We’ve transformed the manual database back–up formation into a quite easy job. To do so: in the Databases Manager, click on the ’clock’ image beside the database that you would like to back up and after that hang on for a few seconds for the backup process to take place. With respect to the size of the database, the creation of the back–up file will need somewhere between a couple of seconds and a minute.

You can create as many backup copies per database as you wish. We have not fixed any restrictions on the volume of databases that you could back up too.

You can find PgSQL support in every one of our Linux shared hosting packages offers. PgSQL databases aren’t as famous and widely used as MySQL, but they supply the best level of protection for your web site content and articles. For this reason, a lot of well–known brands like Skype and Yahoo apply PgSQL databases. Maintaining PgSQL databases is as simple and easy as MySQL, thanks to the intuitive interface of the Databases Manager.

PgSQL databases are incorporated automatically inside of the most sophisticated web hosting bundles. For the normal plans, they are suggested as upgrades.

We’ve integrated InnoDB – the brand new standard MySQL database engine on each of our servers. InnoDB is great for large database sites that demand high levels of performance and scalability. Trials have demonstrated that websites applying InnoDB based tables reach a 3–fold performance grow for substantial joins, compared to those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking as a way to remove the operation difficulties detected at the maximum usage times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load accumulated by the databases on your powerful website will let you avoid any sort of overload difficulties that can slow it down and ward off site visitors. For this reason, we’ve integrated a thorough Database Stats tool straight into the Site Control Panel. There you can see extensive information on the inbound requests to your databases for every hour, day and month.

Using the amount of day–to–day and by the hour queries, it will be easier to determine which databases are employed the most and take measures to optimize their work.