Database Manager

Database management might sound like a difficult job to newbie website hosting users, however with the Database Manager, it’s in fact reasonably easy! To configure a completely new database, you only need to provide your username and password. Database backup copies are simply a click away at the same time.People that choose to look into their databases and change them can make use of the phpMyAdmin and phpPgAdmin tools.

We’ve developed the manual database back–up generation into a very easy job. To execute that: inside the Database Manager, click the ’clock’ icon next to the database that you intend to back up and afterwards wait for a couple of seconds for the backup process to take place. Depending on the size of your database, the generation of the backup file can take somewhere between a few seconds and a minute.

You can make as many backup copies per database as you want. We’ve not specified any limits for the number of databases you can back up as well.

PgSQL databases are less popular than the well–known MySQL databases. However, they’re a favorite option for developers who seek the ultimate stability for their websites and apps. Via the intuitive Database Manager built into the DuoServersHost Control Panel, you can control all of your PostgreSQL databases with simply a click of the mouse.

Yow will discover PgSQL databases provided automatically within the top Linux shared web hosting packages. Assuming that you are with a regular hosting package, you’re able to ask for PgSQL databases to be added in your website hosting account as upgrades.

The MySQL databases on DuoServersHost’s servers work with the most current version of the InnoDB storage engine. InnoDB was designed to guarantee the top functionality for sites that work with massive amounts of data. It supplies CPU performance that could not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, meaning that you’ll be able to update/insert/create/alter/drop a couple of times for one "operation" of your app. In addition, it makes use of row–level locking in lieu of MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Keeping track of the load produced by the databases on your busy site makes it possible to reduce all sorts of overload problems that might slow it down and chase away site visitors. For this purpose, we have designed a in–depth Database Stats tool directly into the Hosting Control Panel. There you can see all–encompassing information about the inbound requests to your databases for each and every hour, day and month.

Based on the number of daily and per hour queries, you will be able to find out which databases are employed the most and then consider steps to optimize their work.