Databases Manager

Supervising your databases is easier than before, thanks to the Web Control Panel interface for MySQL and PgSQL control! Assuming you do not have thorough knowledge in making use of databases, you will find it an easy task to manage our Databases Manager.

You can make a brand new database simply by specifying the username and password or produce a database back–up with merely a mouse click. Moreover, through the Data Manager you’ll have direct access to the administration area for each individual database, so its possible to immediately update it.

We’ve changed the manual database backup creation into a simple job. To execute that: inside of the Databases Manager, click on the ’clock’ image near 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 your database, the creation of any backup file can take between a couple of seconds and a minute.

You may make as many backups of a database as you wish. We have not determined any limits about the volume of databases that you can back up either.

Just about all of Blue Shade Technologies’s Linux website hosting plans grant PgSQL support. While dropping behind MySQL in terms of popularity and application, PgSQL databases are renowned for delivering the highest level of safety for your site content and articles. That is the main reason why companies like Skype and Yahoo rely upon PgSQL databases instead of MySQL.

With respect to database administration, PgSQL is equally hassle–free as MySQL.

We’ve installed InnoDB – the new default MySQL database engine on all of our web servers. InnoDB is good for significant database web sites that need high levels of overall performance and scalability. Trials indicate that sites applying InnoDB based tables achieve a 3–fold performance grow for big joins, as compared to those utilizing MyISAM tables.

InnoDB utilizes row–level locking so as to get rid of the functionality issues found at the peak usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

From your in–depth database stats tool built–into the Web Control Panel, you will be able to keep track of the load produced through your busy websites at any hour. Virtually any overload trouble with your websites can lower the loading speeds and have a damaging influence over the online experience of your website visitors. Consequently, by having information for the database load instantly, it will be possible to resolve overload issues as fast as possible.

The database data interface shows information of the quantity of daily, hourly and monthly lookups, which means you can review just how the load is spread over different time frames.