Databases Manager

Database management may sound like a difficult task to novice cloud hosting users, however with the Databases Manager, it’s in fact pretty simple! To set up a brand new database, you just have to enter the username and password. Database backup copies are a click away on top of that.People that choose to look into their databases and alter them can use the phpMyAdmin and phpPgAdmin tools.

We’ve transformed the manual database back–up generation into a simple activity. To do so: inside the Databases Manager, click the ’clock’ icon beside the database that you plan to back up and wait for a couple of seconds for the backup process to take place. Depending on the size of the database, the creation of any backup file can take between a couple of seconds and a minute.

You can create as many backups of a database as you want. We haven’t set any boundaries on the quantity of databases that you could back up too.

You can find PgSQL support in each of our Linux shared hosting packages bundles. PgSQL databases may not be as sought after and widely used as MySQL, but they supply the highest possible level of safety for your site content. Due to this, several popular businesses like Skype and Yahoo make use of PgSQL databases. Dealing with PgSQL databases is as simple and easy as MySQL, as a result of the easy–to–use interface of the Databases Manager.

PgSQL databases are incorporated by default in the most sophisticated web hosting packages. For the regular bundles, they’re included as upgrades.

The MySQL databases on our servers use the most current version of the InnoDB storage engine. InnoDB has been built to guarantee the optimum effectiveness for sites that process significant volumes of data. It delivers CPU performance that can not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, so that it is easy to update/insert/create/alter/drop more than once for a single "operation" of your application. In addition, it utilizes row–level locking as an alternative to MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

Monitoring the load generated by the databases within your dynamic web site will help you stop any sort of overload issues that can slow it down and chase away website visitors. For this reason, we have included a in depth Database Stats tool inside the Web Hosting Control Panel. There you can get comprehensive info about the inbound requests to your databases for every hour, day and month.

Depending on the amount of daily and hourly queries, it is possible to determine which databases are used the most and then take measures to optimize their load.