Database Manager

Supervising your databases is less complicated than in the past, as a result of Control Panel interface for MySQL and PgSQL control! Even though you may not have thorough knowledge in utilizing databases, it will be simple to use Edotmarket Online Hosting Solutions’s Database Manager.

You can create a completely new database by simply keying in the user name and security password or create a database backup with just a click of the mouse. At the same time, within the Data Manager you have direct access to the administrative area for each individual database, to help you to instantly revise it.

We’ve changed the manual database backup formation into a very simple activity. To do this: inside of the Database Manager, click the ’clock’ icon near the database that you want to back up and then wait around for a few seconds for the backup process to take place. With respect to the size of your database, the building of any backup file will require somewhere between a few seconds and a minute.

You may make as many backup copies of a database as you would like. We’ve not set any boundaries on the amount of databases that you can back up too.

You’re going to find PgSQL support in all our website hosting bundles. PgSQL databases are not as sought after and commonly used as MySQL, but they supply the highest level of security for your website content and articles. Due to this, many popular companies such as Skype and Yahoo work with PgSQL databases. Handling PgSQL databases is as easy as MySQL, due to the user–friendly user interface of the Database Manager.

PgSQL databases are incorporated by default within the most advanced web hosting packages. For the normal packages, they’re featured as upgrades.

We’ve set up InnoDB – the brand new default MySQL database engine on every one of our servers. InnoDB is designed for big database web sites which need high performance and scalability. Experiments have indicated that sites working with InnoDB based tables reach a 3–fold effectiveness increase for substantial joins, when compared with those applying MyISAM tables.

InnoDB utilizes row–level locking in order to be able to clear away the general performance problems detected at the top consumption times of the previous release of the database engine – MyISAM, which employs table–level locking.

Tracking the load caused by the databases for your busy website will let you reduce any sort of overload issues that can slow it down and ward off site visitors. Therefore, we’ve provided a detailed Database Stats tool inside the Control Panel. There you can see comprehensive information regarding the arriving requests to your databases for every hour, day and month.

Depending on the number of day–to–day and per hour queries, you are going to be able to determine which databases are utilized the most and consider actions to optimize their work.