Database Manager

The Database Manager in our Website Control Panel features a powerful but still simple to operate interface. You’re able to configure a completely new MySQL or PostgreSQL database by just typing a user name and password. Moreover, you can make a back–up file or customize the password of an database with just a click of the mouse.

With the Database Manager you will have direct access to the admin area for all your databases, meaning you can make simple adjustments when you have to.

We have changed the manual database backup creation into a simple task. To execute this: in the Database Manager, click the ’clock’ icon near the database that you plan to back up and afterwards wait for a few seconds for the backup process to take place. With regards to the size of your database, the building of any backup file can take somewhere between a couple of seconds and a minute.

You can create as many backup copies per database as you wish. We’ve not specified any boundaries on the quantity of databases that you can back up too.

PgSQL databases are much less popular than the common MySQL databases. Then again, they are a favorite choice for developers who seek the best safety for their sites and apps. Through the incredibly user–friendly Database Manager integrated into the Hosting NG Control Panel, you can administer all your PostgreSQL databases with only a mouse click.

You’ll find PgSQL databases incorporated by default in the advanced Linux cloud hosting packages. Provided that you are with a basic hosting package, you can request PgSQL databases to be included in your cloud hosting account as upgrades.

The MySQL databases on our machines make use of the most recent release of the InnoDB storage engine. InnoDB was created to guarantee the top functionality for sites that operate with significant amounts of data. It presents CPU efficiency that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, meaning that you can update/insert/create/alter/drop more than once for one "operation" of your web application. Furthermore, it takes advantage of row–level locking in place of MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

Through the complete database stats tool incorporated into the Website Control Panel, it’s possible to keep track of the load accumulated from your dynamic web sites 24 / 7. Every overload difficulty with your web sites can reduce the loading speeds and have a damaging effect on the overall impression of your respective website visitors. Which means that, having information for the database work immediately, it will be easy to resolve overload troubles quickly.

The database data user interface reveals data of the quantity of daily, hourly and monthly lookups, so its possible to review just how the load is allocated over several time frames.