Databases Manager

The Databases Manager within our Site Control Panel contains a powerful but well designed user interface. It’s possible to set up a completely new MySQL or PostgreSQL database by just entering a user name and password. Moreover, you may create a back–up file or change the security password of an database with simply a click of the mouse.

Through the Databases Manager you will have immediate access to the administration area for every one of your databases, in order to make simple and easy changes when you need to.

We’ve evolved the manual database backup formation into a simple activity. To execute that: in the Databases Manager, click on the ’clock’ symbol near the database that you would like to back up and wait for a few seconds for the process to take place. Depending on the size of your database, the building of any backup file can take somewhere between a few seconds and a minute.

You may create as many backups per database as you desire. We have not specified any confines for the number of databases you could back up as well.

You can find PgSQL support in all of our cloud service packages. PgSQL databases may not be as famous and widely used as MySQL, nonetheless they supply the maximum level of stability for your website content. Due to this, a lot of famous companies like Skype and Yahoo implement PgSQL databases. Maintaining PgSQL databases is as easy as MySQL, on account of the user–friendly user interface of the Databases Manager.

PgSQL databases are bundled automatically inside the most sophisticated web hosting packages. For the standard packages, they are suggested as upgrades.

The MySQL databases on our servers utilize the most recent version of the InnoDB storage engine. InnoDB was intended to ensure the highest possible effectiveness for web sites that work with significant volumes of data. It provides CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers 100% transaction support, which means that you can update/insert/create/alter/drop many times for a single "operation" of your application. At the same time, it uses row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

With the in–depth database statistics tool integrated into the Site Control Panel, you are able to keep track of the load produced by your active web sites at any hour. Every overload issue with your websites could reduce the loading rates and have a damaging impact on the overall experience of your visitors. Thus, having data for the database load right away, it is possible to mend overload troubles in a timely manner.

The database statistics interface displays information of the quantity of daily, hourly and monthly queries, meaning you can analyze how the load is distributed over several periods of time.