Database Manager

Database management may sound like a hard task to novice website hosting users, but with our Database Manager, it’s in fact simple! To set up a completely new database, you just need to key in your username and password. Database back–ups are simply a click away too.People who desire to examine their databases and edit them are able to use the phpMyAdmin and phpPgAdmin tools.

We’ve transformed the manual database backup creation into a very simple activity. To execute this: inside the Database Manager, click the ’clock’ symbol next to the database that you would like to back up and after that hang on for a couple of seconds for the backup process to take place. Depending upon the size of your database, the generation of the backup file can take between a few seconds and a minute.

You may create as many backups of a database as you wish. We have not set any limitations about the amount of databases that you can back up either.

You’ll find PgSQL support in our Linux website hosting plans. PgSQL databases may not be as popular and commonly used as MySQL, but they provide the highest possible level of security for your website content. For this reason, a lot of popular companies like Skype and Yahoo use PgSQL databases. Maintaining PgSQL databases is as simple as MySQL, because of the easy–to–use interface of the Database Manager.

PgSQL databases are provided automatically with the most sophisticated web hosting packages. For the standard plans, they’re offered as upgrades.

We’ve integrated InnoDB – the brand new default MySQL database engine on every one of our machines. InnoDB is perfect for big database websites which require high effectiveness and scalability. Trials have indicated that websites employing InnoDB based tables attain a 3–fold operation increase for big joins, in contrast to those applying MyISAM tables.

InnoDB utilizes row–level locking as a way to eliminate the effectiveness problems discovered at the top usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Tracking the load made by the databases within your busy site assists you to prevent all kinds of overload problems that can slow it down and ward off website visitors. For this reason, we’ve built–in a in–depth Database Stats tool within the Site Control Panel. There you can get thorough info about the inbound requests to your databases for every hour, day and month.

Using the volume of day–to–day and by the hour queries, it will be straightforward to determine which databases are being used the most and then take steps to enhance their work.