Databases Manager

The Databases Manager inside the Online Control Panel includes a powerful yet easy to use user interface. You’ll be able to set up a completely new MySQL or PostgreSQL database simply by typing a username and password. Additionally, you can make a backup file or change the security password of an database with only a mouse click.

With the Databases Manager you’ll get immediate access to the administrator area for every one of your databases, which means you can make simple adjustments if you ever have to.

We have made the manual database back–up generation into a quite easy task. To do this: inside the Databases Manager, click the ’clock’ image on the side of the database that you want to back up and wait around for a couple of seconds for the backup process to take place. Depending upon the size of the database, the creation of any backup file will need between a couple of seconds and a minute.

You can create as many backups of a database as you wish. We haven’t set any limitations on the amount of databases you could back up as well.

PgSQL databases are significantly less widespread as compared to the common MySQL databases. Then again, they are a preferred option for designers who seek the uttermost security for their websites and web applications. Due to the easy–to–use Databases Manager built–into the WebHostNexus.com Control Panel, you can manage your PostgreSQL databases with a mouse click.

You can discover PgSQL databases provided by default inside the advanced cloud hosting plans packages. Provided that you are using a basic hosting package, it’s possible to request PgSQL databases to be included in your cloud hosting account as upgrades.

We’ve installed InnoDB – the brand new standard MySQL database engine on each of our web servers. InnoDB is designed for huge database sites that demand high levels of general performance and scalability. Experiments have demonstrated that sites making use of InnoDB based tables attain a 3–fold general performance boost for big joins, when compared to those making use of MyISAM tables.

InnoDB uses row–level locking in an effort to remove the functionality problems found at the top consumption times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

With the all–encompassing database statistics tool included in the Online Control Panel, it is possible to keep tabs of the load accumulated by your dynamic web sites 24 / 7. Any overload problem with your web sites could reduce the loading speeds and have a negative effect on the overall impression of your visitors. Hence, having info for the database load live, you’ll be able to mend overload issues as soon as possible.

The database stats user interface reveals details of the number of daily, hourly and monthly queries, so its possible to assess just how the load is allocated over several periods of time.