Database Manager

Database management might sound like a hard task to inexperienced web hosting users, but with GeeksCloud’s Database Manager, it’s actually quite simple! To configure a new database, you simply ought to key in the username and password. Database backup copies are a mouse click away as well.Those who need to look into their databases and then edit them should use the phpMyAdmin and phpPgAdmin tools.

We have changed the manual database back–up creation into a very easy activity. To execute this: in the Database Manager, click the ’clock’ icon next to the database that you would like to back up and after that wait for a few seconds for the process to take place. Depending on the size of your database, the building of the back–up file can take between a few seconds and a minute.

You may create as many back–ups per database as you wish. We haven’t set any restrictions for the amount of databases that you can back up as well.

You are going to find PgSQL support in our Linux hosting bundles. PgSQL databases are not as famous and widely used as MySQL, nevertheless they give the greatest level of security for your website content and articles. Because of this, a lot of popular brands like Skype and Yahoo utilize PgSQL databases. Managing PgSQL databases is as easy as MySQL, as a result of the user–friendly user interface of the Database Manager.

PgSQL databases are included by default with the most advanced web hosting plans. For the normal packages, they are presented as upgrades.

The MySQL databases on our web servers employ the most current build of the InnoDB storage engine. InnoDB was designed to guarantee the maximum performance for websites that process big amounts of data. It delivers CPU performance that could not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, so that you are able to update/insert/create/alter/drop repeatedly for a single "operation" of your application. Moreover, it takes advantage of row–level locking as a substitute for MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Keeping track of the load generated by the databases on your dynamic website will let you prevent any overload problems that might slow it down and chase away visitors. For that reason, we have built–in a complete Database Stats tool inside the Online Control Panel. There you shall find broad information about the arriving requests to your databases for every single hour, day and month.

Using the volume of day–to–day and per hour queries, you will be able to find out which databases are employed the most as well as consider steps to optimize their load.