Databases Manager

Database management may seem like a hard task to beginner hosting users, however with the Databases Manager, it’s actually pretty simple! To configure a whole new database, you only have to enter your username and password. Database backup copies are just a mouse click away as well.People who need to explore their databases and then change them can use the phpMyAdmin and phpPgAdmin tools.

We’ve changed the manual database backup formation into a very easy task. To do so: in the Databases Manager, click on the ’clock’ icon near the database that you intend to back up and after that hang on for a few seconds for the process to take place. Depending on the size of the database, the creation of a back–up file can take somewhere between a few seconds and a minute.

You can create as many backups of a database as you want. We have not fixed any confines on the quantity of databases you can back up as well.

The majority of Quarter Pie Interactive’s web hosting plans packages provide PgSQL support. While dropping behind MySQL with respect to global recognition and employment, PgSQL databases are renowned for offering the highest level of security for your site content and articles. This is the reason why businesses like Skype and Yahoo make use of PgSQL databases as a substitute for MySQL.

With regards to database management, PgSQL is equally effortless to use as MySQL.

We’ve set up InnoDB – the brand new standard MySQL database engine on all our servers. InnoDB is perfect for large database sites that need high overall performance and scalability. Experiments have indicated that websites employing InnoDB based tables attain a 3–fold effectiveness increase for significant joins, when compared to those employing MyISAM tables.

InnoDB uses row–level locking in order to remove the operation problems discovered at the maximum consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

We provide you a pretty simple approach to keep track of the database use for your powerful websites. Via the thorough database statistics user interface, which is built–into the Website Control Panel, you can keep track of the load accumulated by your busy sites in real time. The provided information will help you to analyze the database load changes by the hour, on a daily basis or on a monthly basis.

It is possible to monitor the database load for all of your web sites through the Database Stats section of the Website Control Panel. The table onscreen features the database queries created during the present month. To look at information for an earlier month, simply click on the back arrows positioned at the top.