Databases Manager

Database management might sound like a complicated job to unskilled hosting users, nevertheless with our Databases Manager, it’s actually relatively easy! To create a new database, you just have to enter in your username and password. Database back–ups are simply a click away at the same time.People that would like to examine their databases and alter them should use the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager it is easy to produce an archived duplicate of your database whenever you need! Thus, you will always have a backup of your dynamic content material in the event your web site gets broken into or you erroneously eliminate a database. To produce a backup: click the ’clock’ symbol beside any database and then simply wait for a couple of seconds for the backup process to be finalized.

There are no restrictions for the number of databases you are able to back up or the amount of backups you can create for a database.

PgSQL databases are less popular than the well–known MySQL databases. Nonetheless, they are a favorite choice for developers who seek the uttermost security for their web sites and applications. Because of the intuitive Databases Manager integrated into the MoonServers Control Panel, you can administer all your PostgreSQL databases with just a mouse click.

You can find PgSQL databases provided by default inside the advanced web hosting packages. Assuming that you are with a regular hosting package, it is easy to request PgSQL databases to be added in your cloud hosting account as upgrades.

We’ve set up InnoDB – the new standard MySQL database engine on our servers. InnoDB is great for substantial database sites that demand high functionality and scalability. Tests have revealed that websites working with InnoDB based tables achieve a 3–fold operation boost for huge joins, in comparison to those utilizing MyISAM tables.

InnoDB makes use of row–level locking in order to be able to get rid of the operation difficulties noticed at the maximum consumption times of the earlier release of the database engine – MyISAM, which employs table–level locking.

Tracking the load generated by the databases within your dynamic website will help you prevent virtually any overload troubles that can slow it down and ward off site visitors. Therefore, we have provided a in depth Database Stats tool within the Site Control Panel. There you can see thorough information regarding the incoming requests to your databases for each and every hour, day and month.

Based on the amount of day–to–day and hourly queries, you’re going to be able to find out which databases are employed the most and consider steps to enhance their load.