Databases Manager

The Databases Manager in our Website Control Panel contains a refined nevertheless convenient interface. You are able to set up a completely new MySQL or PostgreSQL database by simply entering a username and security password. Furthermore, you can make a back–up file or modify the security password of an database with only a mouse click.

Through the Databases Manager you’ll get immediate access to the admin area for every one of your databases, so that you can make convenient corrections if you ever have to.

If you have worked with databases, you are aware that generating a manual database back–up is not really a basic task. As a way to change this, we’ve developed a simple tool that can back up the entire database with merely a single mouse click. The back–up file is going to be set for you in under a minute, with regards to the size of the chosen database.

There are no confines on the actual number of backups you may make for a chosen database.

You can find PgSQL support in each of our Linux cloud web hosting service bundles. PgSQL databases may not be as well–known and widespread as MySQL, nevertheless they supply the best level of security for your web site content and articles. Due to this, several well–known companies such as Skype and Yahoo take advantage of PgSQL databases. Managing PgSQL databases is as elementary as MySQL, as a result of the easy–to–use interface of the Databases Manager.

PgSQL databases are bundled automatically inside the most sophisticated web hosting bundles. For the standard plans, they are included as upgrades.

The MySQL databases on our machines make use of the latest build of the InnoDB storage engine. InnoDB was developed to guarantee the highest efficiency for sites that work with sizeable volumes of data. It boasts CPU performance that could not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, meaning you are able to update/insert/create/alter/drop repeatedly for one "operation" of your web application. At the same time, it takes advantage of row–level locking as an alternative to MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

From the broad database statistics tool included in the Website Control Panel, you are going to be able to keep a record of the stress generated from your dynamic web sites 24 x 365. Virtually any overload problem with your sites can reduce the loading rates and have a bad effect on the overall impression of your site visitors. Hence, by having data about the database work in real time, you will be able to mend overload issues straight away.

The database stats interface shows details of the volume of daily, hourly and monthly queries, so you can examine just how the load is spread over various periods of time.