Databases Manager

Managing your databases is less complicated than ever before, thanks to the Online Control Panel user interface for MySQL and PgSQL management! Even if you do not have thorough expertise in handling databases, you will find it easy to handle Seed Web Services’s Databases Manager.

You can make a new database just by specifying the user name and security password or produce a database back–up with a simple click of the mouse. In addition, within the Data Manager you’ll get direct access to the admin area for every database, allowing you to efficiently revise it.

In case you have dealt with databases, you are aware that making a manual database backup is not really a simple task. As a way to change this, we’ve developed a simple and easy to use tool that can back up your whole database with a single click of the mouse. The back–up file shall be completely ready for you in under a minute, based on the size of the chosen database.

There are no limitations on the total number of backup copies you could make for any particular database.

A lot of our Linux shared website hosting plans deliver PgSQL support. Whilst falling behind MySQL with respect to level of popularity and usage, PgSQL databases are famous for providing the maximum level of protection for your site content. That is the main reason why companies like Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

When considering database management, PgSQL is just as uncomplicated as MySQL.

We have incorporated InnoDB – the new standard MySQL database engine on every one of our servers. InnoDB is perfect for substantial database sites which need high general performance and scalability. Tests have indicated that sites working with InnoDB based tables attain a 3–fold effectiveness boost for big joins, when compared to those utilizing MyISAM tables.

InnoDB utilizes row–level locking so as to take away the effectiveness difficulties detected at the peak usage times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load caused by the databases in your active website makes it possible to stop any overload difficulties that can slow it down and ward off site visitors. For this purpose, we have integrated a detailed Database Stats tool straight into the Online Control Panel. There you can find complete info on the incoming requests to your databases for each hour, day and month.

Based on the amount of daily and hourly queries, it will be easy to find out what databases are employed the most and also consider procedures to optimize their load.