Databases Manager

Administering your databases is simpler than ever, because of the Online Control Panel interface for MySQL and PgSQL administration! Even though you may not have detailed experience in making use of databases, you will find it simple to manage Real Web Services’s Databases Manager.

You can create a completely new database merely by specifying the user name and security password or create a database back–up with just a mouse click. Also, within the Data Manager you’ll have direct access to the administration area for every database, meaning you can instantly alter it.

We have changed the manual database backup formation into a simple task. To execute that: inside the Databases Manager, click on the ’clock’ icon beside the database that you want to back up and afterwards wait around for a few seconds for the backup process to take place. Depending on the size of the database, the generation of a backup file can take between a couple of seconds and a minute.

You may make as many back–ups of a database as you wish. We’ve not specified any limits for the volume of databases you could back up either.

Nearly all of Real Web Services’s web hosting plans plans feature PgSQL support. Whilst dropping behind MySQL with regard to level of popularity and application, PgSQL databases are famous for supplying the maximum level of stability for your web site content material. That’s the primary reason why companies like Skype and Yahoo go with PgSQL databases in lieu of MySQL.

With regards to database management, PgSQL is equally simple and easy as MySQL.

We have set up InnoDB – the new default MySQL database engine on every one of our machines. InnoDB is great for big database web sites which need high efficiency and scalability. Tests demonstrate that web sites using InnoDB based tables attain a 3–fold overall performance boost for large joins, as compared with those making use of MyISAM tables.

InnoDB employs row–level locking as a way to eliminate efficiency problems noticed at the high consumption times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load made by the databases within your busy website makes it possible to prevent all kinds of overload troubles that could slow it down and ward off website visitors. For this specific purpose, we’ve incorporated a comprehensive Database Stats tool directly into the Online Control Panel. There you can see broad information on the incoming requests to your databases for each and every hour, day and month.

In line with the volume of day–to–day and by the hour queries, it is possible to determine which databases are utilized the most and consider steps to optimize their work.