Database Manager

Taking control of your databases is much simpler than ever, because of the Hosting Control Panel user interface for MySQL and PgSQL management! In case you do not have detailed expertise in handling databases, you will find it an easy task to use the Database Manager.

You can create a brand new database by just typing the user name and password or generate a database back–up with only a mouse click. Also, via the Data Manager you’ll get direct access to the admin area for every database, to help you to instantly modify it.

We have evolved the manual database backup creation into a simple job. To do this: inside the Database Manager, click the ’clock’ image beside the database that you want to back up and then wait for a few seconds for the process to take place. With respect to the size of your database, the generation of the backup file is going to take between a few seconds and a minute.

You can make as many backup copies per database as you wish. We haven’t specified any limitations about the amount of databases that you can back up too.

A lot of the Linux shared web hosting packages bundles feature PgSQL support. Although dropping behind MySQL in terms of popularity and application, PgSQL databases are renowned for giving the highest level of stability for your site content material. That is the primary reason why companies like Skype and Yahoo rely on PgSQL databases instead of MySQL.

With regards to database management, PgSQL is just as easy to use as MySQL.

The MySQL databases on Dimentum’s servers work with the latest release of the InnoDB storage engine. InnoDB has been made to guarantee the maximum effectiveness for web sites that work with large volumes of data. It features CPU performance that can not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, which means that you are able to update/insert/create/alter/drop a couple of times for one "operation" of your application. Moreover, it employs row–level locking rather than MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Monitoring the load caused by the databases in your powerful website will let you stop any overload troubles that could slow it down and ward off visitors. For this purpose, we have designed a in depth Database Stats tool into the Hosting Control Panel. There you can get in–depth information regarding the incoming requests to your databases for each hour, day and month.

Depending on the volume of day–to–day and by the hour queries, it will be easy to find out which databases are employed the most and then take measures to optimize their load.