From within the Database Manager included in the Online Control Panel, you will be able to create brand new MySQL and PgSQL databases immediately! At the same time, you have direct access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), to help you to conveniently alter the database you want.
Tidy and Hassle–free Interface
Maintain all of your databases from just one location
The Database Manager in our Online Control Panel provides a robust but easy to navigate interface. It is easy to set up a completely new MySQL or PostgreSQL database by just specifying a username and security password. Also, you can create a back–up file or customize the password of any database with a click of the mouse.
Within the Database Manager you have immediate access to the administrator area for every one of your databases, so that you can make easy changes if you happen to need to.
Easy Database Backup
Back up your databases in just a minute
We have made the manual database backup formation into a quite easy job. To do this: in the Database Manager, click the ’clock’ symbol on the side of the database that you plan to back up and wait for a few seconds for the backup process to take place. Depending on the size of your database, the generation of a back–up file can take somewhere between a couple of seconds and a minute.
You can create as many backup copies per database as you want. We have not determined any boundaries for the quantity of databases you could back up either.
By far the most risk–free open source databases
The majority of the Linux web hosting packages deliver PgSQL support. Whilst falling behind MySQL when considering global recognition and employment, PgSQL databases are famous for offering the highest level of stability for your web site content material. That is the primary reason why businesses like Skype and Yahoo employ PgSQL databases rather than MySQL.
With respect to database administration, PgSQL is identically uncomplicated as MySQL.
The fresh face of MySQL
We’ve set up InnoDB – the new standard MySQL database engine on all of our machines. InnoDB is made for substantial database sites that require high levels of overall performance and scalability. Tests indicate that web sites working with InnoDB based tables reach a 3–fold effectiveness increase for very big joins, in contrast to those utilizing MyISAM tables.
InnoDB takes advantage of row–level locking in order to be able to remove the functionality issues noticed at the high usage times of the earlier release of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
In depth statistics for your databases
Websites by Fara Dina offers you a simple and easy option to track the database use for your powerful web sites. From the thorough database stats user interface, which is built into the Online Control Panel, it is easy to observe the load produced from your dynamic websites in real time. The presented data will help you assess the database load variations on an hourly basis, each day or each month.
It is possible to keep an eye on the database load for all your sites within the Database Stats part of the Online Control Panel. The table on–screen reveals the database queries accumulated during the present month. To assess data for an earlier month, just click on the back arrows situated at the top.