Database Manager

Overseeing your databases is much easier than before, thanks to the Web Hosting Control Panel user interface for MySQL and PgSQL control! Even though you may not have in depth knowledge of making use of databases, it will be easy to work with SmallBizHosting.biz’s Database Manager.

You can make a new database by only keying in the user name and password or generate a database backup with a click of the mouse. Moreover, within the Data Manager you will get direct access to the admin area for every single database, so you can quite simply revise it.

Through the Database Manager you’re able to make an archived copy of your database whenever you desire! Thus, you are going to always have a backup of your dynamic information in case your website gets hacked or you erroneously delete a database. To make a back–up: click on the ’clock’ image on the side of any database and then simply wait for a couple of seconds for the process to be carried out.

There are not any limits about the number of databases you are able to back up or the number of backup copies you may make for a database.

Just about all of the shared web hosting bundles present PgSQL support. While falling behind MySQL when considering global recognition and usage, PgSQL databases are famous for supplying the top level of security for your site content and articles. That’s the primary reason why companies such as Skype and Yahoo rely on PgSQL databases in lieu of MySQL.

When considering database administration, PgSQL is as uncomplicated as MySQL.

The MySQL databases on SmallBizHosting.biz’s servers employ the newest version of the InnoDB storage engine. InnoDB has been intended to guarantee the optimum efficiency for websites that deal with huge volumes of data. It provides CPU efficiency that could not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, meaning that it is possible to update/insert/create/alter/drop a couple of times for one "operation" of your web application. Additionally, it utilizes row–level locking instead of MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

Our company offers you a quick approach to track the database use for your busy sites. From the in depth database stats user interface, that’s incorporated into the Web Hosting Control Panel, it is easy to keep an eye on the load generated from your active web sites in real time. The presented data will let you evaluate the database load changes every hour, on a daily basis or per month.

You’re able to keep an eye on the database load for all of your web sites from the Database Stats part of the Web Hosting Control Panel. The table on–screen presents the database queries accumulated within the present month. To check details for an earlier month, all you have to do is click on the back arrows located at the top.