Database Manager

Supervising your databases is easier than ever before, because of the Website Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have extensive experience in dealing with databases, it will be simple to work with our Database Manager.

You could make a whole new database merely by specifying the username and security password or make a database backup with simply a click of the mouse. At the same time, through the Data Manager you will get direct access to the administrator area for each and every database, which means you can conveniently edit it.

Through the Database Manager it’s possible to create an archived backup of your database whenever you would like! Therefore, you will always have a backup of your dynamic content in the event your site gets broken into or you mistakenly erase a database. To make a back–up: click on the ’clock’ icon alongside a certain database and afterwards simply wait for a few seconds for the process to be finished.

There aren’t any limitations for the number of databases you are able to back up or the volume of backups you can create for a database.

Nearly all of the Linux cloud hosting packages provide PgSQL support. While falling behind MySQL regarding popularity and application, PgSQL databases are renowned for supplying the greatest level of protection for your site content material. That’s the basic reason why businesses like Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.

In relation to database administration, PgSQL is identically hassle–free as MySQL.

We have installed InnoDB – the new standard MySQL database engine on all our machines. InnoDB is perfect for big database websites which need high performance and scalability. Tests show that web sites making use of InnoDB based tables reach a 3–fold efficiency increase for very big joins, when compared to those applying MyISAM tables.

InnoDB employs row–level locking in an effort to eliminate efficiency difficulties detected at the high usage times of the earlier variant of the database engine – MyISAM, which employs table–level locking.

Through the in depth database statistics tool integrated into the Website Control Panel, it will be possible to keep a record of the stress created through your active sites around the clock. Virtually any overload issue with your sites could reduce the loading rates and have a negative effect on the online experience of your respective visitors. Consequently, by having details about the database load immediately, it will be easier to eliminate overload problems as quickly as possible.

The database stats user interface displays data of the quantity of daily, hourly and monthly lookups, in order to review how the load is spread over different time periods.