Database Manager

The Database Manager in the Web Control Panel includes a refined yet convenient to use user interface. You’re able to set up a new MySQL or PostgreSQL database by simply specifying a username and password. Moreover, you could make a back–up file or alter the security password of an database with only a click of the mouse.

Through the Database Manager you will have direct access to the admin area for every one of your databases, which means you can make uncomplicated corrections in case you have to.

We’ve designed the manual database backup generation into a very simple job. To execute this: inside of the Database Manager, click the ’clock’ image next to the database that you want to back up and then wait around for a few seconds for the process to take place. Depending on the size of your database, the creation of the backup file is going to take somewhere between a couple of seconds and a minute.

You may create as many backup copies of a database as you desire. We’ve not set any boundaries about the amount of databases you could back up either.

You are going to find PgSQL support in our shared web hosting bundles. PgSQL databases aren’t as popular and commonly used as MySQL, nonetheless they provide the highest level of security for your site content and articles. Due to this, several famous businesses like Skype and Yahoo use PgSQL databases. Controlling PgSQL databases is as easy as MySQL, on account of the easy–to–use user interface of the Database Manager.

PgSQL databases are included automatically in the most advanced web hosting bundles. For the regular bundles, they are suggested as upgrades.

The MySQL databases on our servers use the most current build of the InnoDB storage engine. InnoDB was meant to guarantee the highest efficiency for websites that operate with significant volumes of data. It grants CPU performance that could not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, meaning that it is easy to update/insert/create/alter/drop many times for one "operation" of your web application. Moreover, it employs row–level locking instead of MyISAM’s table–level locking, that improves multi–user concurrency and performance.

From your detailed database statistics tool built–into the Web Control Panel, it is possible to make a record of the load produced through your active web sites round the clock. Every overload trouble with your websites can reduce the loading speeds and have a damaging impact on the online experience of your website visitors. Hence, by having information about the database load live, it will be easy to solve overload troubles right away.

The database stats interface reveals data of the quantity of daily, hourly and monthly lookups, allowing you to evaluate how the load is allocated over different time frames.