We present you with a user friendly Database Manager, incorporated in the Site Control Panel, from which you could create brand–new MySQL and PgSQL databases directly. Furthermore, you are enabled to be in charge of each of their adjustments through the immediate access provided to the phpMyAdmin and phpPgAdmin software tools.
A User–friendly and uncomplicated User interface
Be in charge of your databases with only a mouse click
Managing your databases is much simpler than ever before, thanks to the Site Control Panel interface for MySQL and PgSQL control! Even though you may not have considerable expertise in handling databases, it will be very easy to manage our Database Manager.
You can make a brand new database by merely typing the username and security password or produce a database back–up with just a click of the mouse. Additionally, within the Data Manager you will have direct access to the admin area for each and every database, so you can instantly manage it.
Quick and Simple Database Back–up
Database backups are just a mouse click away
Within the Database Manager you can produce an archived backup of your database when you want! Therefore, you are going to always have a back–up of your dynamic content material in the event your site gets compromised or you mistakenly delete a database. To produce a back–up: click the ’clock’ icon on the side of a particular database and after that wait for a couple of seconds for the backup process to be completed.
There won’t be any restrictions on the amount of databases you can back up or the amount of back–ups you can create for any database.
The most stable open source databases
Practically all of the Linux shared website hosting packages feature PgSQL support. While dropping behind MySQL when considering reputation and application, PgSQL databases are renowned for offering the greatest level of stability for your web site content. That’s the basic reason why businesses like Skype and Yahoo employ PgSQL databases in lieu of MySQL.
When it comes to database management, PgSQL is equally quick as MySQL.
The new face of MySQL
The MySQL databases on ROWorld’s web servers use the latest release of the InnoDB storage engine. InnoDB was made to guarantee the top performance for websites that operate with large amounts of data. It grants CPU effectiveness that can not be equalled by other different disk–based relational database engines.
InnoDB is ACID–compliant and provides 100% transaction support, which means that it is easy to update/insert/create/alter/drop more than once for one "operation" of your application. Furthermore, it uses row–level locking instead of MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.
Detailed Database Stats
In depth stats for all of your databases
Tracking the load caused by the databases within your powerful site makes it possible to stop all kinds of overload issues that can slow it down and chase away site visitors. For this purpose, we have built in a in depth Database Stats tool into the Site Control Panel. There you can get all–encompassing info about the arriving requests to your databases for each hour, day and month.
Depending on the volume of daily and hourly queries, it is possible to find out what databases are being used the most and also consider measures to enhance their load.