Database Manager

Overseeing your databases now is easier than before, on account of the Web Hosting Control Panel interface for MySQL and PgSQL administration! Even though you may not have considerable expertise in working with databases, you will find it easy to manage SABWeb Host’s Database Manager.

You could make a whole new database by only entering the username and security password or create a database backup with only a click of the mouse. Moreover, from the Data Manager you have direct access to the administration area for every database, which means you can efficiently edit it.

From the Database Manager it’s easy to make an archived copy of your database anytime you desire! Thus, you’ll always have a data backup of your dynamic information in the event your site gets broken into or if you incorrectly erase a database. To generate a back–up: click on the ’clock’ symbol beside a given database and afterwards just wait for a couple of seconds for the process to be finalized.

There won’t be any limits for the amount of databases you can back up or the volume of backup copies you may make for a database.

PgSQL databases are less common as compared to the prevalent MySQL databases. Then again, they represent a favored alternative for programmers seeking the uttermost safety for their websites and apps. Due to the intuitive Database Manager incorporated into the SABWeb Host Control Panel, you can administer all your PostgreSQL databases with merely a click of the mouse.

You’ll find PgSQL databases bundled by default with the best cloud hosting packages. Assuming that you are with a regular hosting package, it’s possible to request PgSQL databases to be added in your web hosting account as upgrades.

The MySQL databases on SABWeb Host’s web servers use the newest build of the InnoDB storage engine. InnoDB was designed to guarantee the top efficiency for web sites that work with significant volumes of data. It supplies CPU efficiency that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, which means that you’ll be able to update/insert/create/alter/drop several times for a single "operation" of your web app. In addition, it employs row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and performance.

Tracking the load caused by the databases for your busy site will help you prevent virtually any overload issues that can slow it down and ward off site visitors. As a result, we have built in a in depth Database Stats tool straight into the Web Hosting Control Panel. There you will find all–encompassing information regarding the inbound requests to your databases for every single hour, day and month.

In line with the number of daily and by the hour queries, you’re going to be able to determine which databases are employed the most and also consider steps to optimize their load.