Databases Manager

Database management may seem like a hard task to beginner web hosting customers, however with our Databases Manager, it’s in fact really simple! To set up a brand new database, you simply ought to provide the username and password. Database backup copies are simply a click away as well.Those who would like to look into their databases and also change them can make use of the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager it is simple to generate an archived duplicate of your database anytime you wish! For this reason, you are going to always have a backup of your dynamic information in case your website gets compromised or you incorrectly remove a database. To generate a backup: click the ’clock’ symbol next to a given database and afterwards wait for a few seconds for the backup process to be done.

There aren’t any limits for the number of databases you are able to back up or the quantity of backups you can create for any database.

A majority of our Linux cloud hosting plans bundles provide PgSQL support. While falling behind MySQL in terms of popularity and application, PgSQL databases are renowned for delivering the maximum level of protection for your site content. That’s the key reason why companies like Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

With regards to database management, PgSQL is identically straightforward as MySQL.

The MySQL databases on our web servers employ the most current version of the InnoDB storage engine. InnoDB was designed to ensure the highest possible performance for web sites that deal with big volumes of data. It provides CPU performance that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning it is possible to update/insert/create/alter/drop many times for one "operation" of your web app. Additionally, it employs row–level locking in contrast to MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.

Monitoring the load produced by the databases in your dynamic website makes it possible to stop any kind of overload troubles that can slow it down and chase away visitors. As a result, we’ve included a thorough Database Stats tool in the Web Control Panel. There you can find in–depth info about the incoming requests to your databases for each and every hour, day and month.

In line with the amount of daily and per hour queries, it will be easier to determine which databases are utilized the most as well as consider steps to enhance their work.